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

Related:

1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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 767
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 767
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