Updating Data in two+ worksheets

Solved/Closed

Omar - May 6, 2010 at 03:32 AM
rizvisa1 Posts 4478 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 ?

Updating Data in two+ worksheets
Transfer data from one excel worksheet to another automatically - Guide
Tmobile data check - Guide
Display two columns in data validation list but return only one - Guide
How to be offline in whatsapp when data is on - Guide
Hosted app data ✓ - Google Chrome Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

AMD data change update new data to DMI

Comparing Two Excel Sheets and copying like data to third sheet

Unlock safe folder without losing any data

How To Fix Mint Mobile Data Not Working?

Is this a scam?

Similar discussions

Subscribe To Our Newsletter!