Previous Topic Next Topic

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

Closed
Oma1958
Posts
1
Registration date
Wednesday February 20, 2013
Status
Member
Last seen
February 20, 2013
 - Feb 20, 2013 at 12:24 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 - Feb 23, 2013 at 12:00 PM
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

Answer 1 / 1
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
Feb 20, 2013 at 04:03 PM
When you say form, do you mean actually excel FORMs or you are talking about sheets that you have designed as forms ?
0
Oma1958
Feb 20, 2013 at 04:47 PM
Sheets that I have desgined as forms
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
Feb 20, 2013 at 08:50 PM
How about when you fill in, then you run a macro that populate rest of sheets ?
0
Oma1958
Feb 22, 2013 at 09:11 AM
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.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
Feb 23, 2013 at 12:00 PM
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, "")
0