Previous Topic Next Topic

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

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

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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Convert number to spelling
Sukumar -
mrwagh85 -

28 responses