Excel 2010 - Macro for filling in Top half of several Excel form
Closed
Oma1958
rizvisa1
- Posts
- 1
- Registration date
- Wednesday February 20, 2013
- Status
- Member
- Last seen
- February 20, 2013
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Excel 2010 - Macro for filling in Top half of several Excel form
- Macro for filling data from specific cell to another ✓ - Forum - Excel
- Excel 2010-VB Macro formula into many spreadsheets ✓ - Forum - Excel
- Excel/VBA 2010 Continue with Macro ✓ - Forum - Excel
- Macro to compare two excel sheets ✓ - Forum - Excel
- Macro to insert row in excel based on criteria ✓ - Forum - Excel
1 reply
rizvisa1
Feb 20, 2013 at 04:03 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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, "")