Updating Data in two+ worksheets [Solved/Closed]

Question

Updating Data in two+ worksheets [Solved/Closed]

Report

Omar - May 6, 2010 at 03:32 AM
rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

- 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
Excel auto update data from another worksheet ✓ - Forum - Excel
Transfer specific data from one worksheet to another for reports - How-To - Excel
Copy pivot table data to another worksheet vba - Forum - Excel
How to update data in excel using vba - How-To - Programming
Macro to pull data from another worksheet based on criteria ✓ - Forum - Excel

1 reply

Ask a question

rizvisa1 · Answer 1 · 2010-05-06T07:42:29-0400

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

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

Updating Data in two+ worksheets [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!