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
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 23, 2013 at 12:00 PM
Related:
- Excel 2010 - Macro for filling in Top half of several Excel form
- Excel date format dd.mm.yyyy - Guide
- Microsoft office 2010 free download full version with key - Download - Office suites
- Number to words in excel - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Screenshot in excel - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Feb 20, 2013 at 04:03 PM
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 ?
Feb 20, 2013 at 04:47 PM
Feb 20, 2013 at 08:50 PM
Feb 22, 2013 at 09:11 AM
Feb 23, 2013 at 12:00 PM
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, "")