Updating Data in two+ worksheets
Solved/Closed
Omar
-
May 6, 2010 at 03:32 AM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Updating Data in two+ worksheets
- Excel auto update data from another worksheet ✓ - Forum - Excel
- How to auto update data in excel from another worksheet - Guide
- Autopopulating multiple sheets from one main sheet ✓ - Forum - Excel
- Copy pivot table data to another worksheet vba - Forum - Excel
- Transfer specific data from one worksheet to another for reports - Guide
1 reply
rizvisa1
May 6, 2010 at 07:42 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
May 6, 2010 at 07:42 AM
Depends on how the tables are matched up
lets say if they match cell for cell
then you can use some thing like this
on sheet 2
=if(Sheet1!a1="", "", Sheet1!a1)
this basically says show me whats on sheet1 cell a1
lets say if they match cell for cell
then you can use some thing like this
on sheet 2
=if(Sheet1!a1="", "", Sheet1!a1)
this basically says show me whats on sheet1 cell a1