Excel 2010 - Macro for filling in Top half of several Excel form

[Closed]
Report
Posts
1
Registration date
Wednesday February 20, 2013
Status
Member
Last seen
February 20, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have about 14 Excel 2010 forms that lines 2-6 contain the identical information, after filing in the information in on the first form, I would like it to auto populate the rest of the forms. This would be a huge time saver for my Team members. Any advice??? I am not macro savvy at all. Thanks for all your help..... Anne

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
When you say form, do you mean actually excel FORMs or you are talking about sheets that you have designed as forms ?
Sheets that I have desgined as forms
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
How about when you fill in, then you run a macro that populate rest of sheets ?
That would be perfect, that is exactly what I am looking for. Does it matter that the rest of the sheets are not filled in at the same time? They are all filled in at different times. Could be up to several months later.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Come to think about it. why not use formula
So make one sheet as a master sheet where you would enter information. Lets say name is in Cell A1

then in sheet2, use formula to to pull in value from A1 of sheet1 as

=IF('Sheet1'!A1<>"", 'Sheet1'!A1, "")