Previous Topic Next Topic

Updating Data in two+ worksheets

Solved/Closed
Omar - May 6, 2010 at 03:32 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 6, 2010 at 07:42 AM
I have a question, I just created a spreadsheet with 8 tables which contain a deferent data
and with Autosum column on each table and I created also 8 tabs where I have a copy of each table which they should get updated from the main worksheet whenever a new data entered ! Is that possible ?

1 reply

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