Update one worksheet tab to automatically update all other tabs?

S

shoechic1

I have a spreadsheet that has SEVERAL tabs of information... I want to be
able to edit/add/delete to first "master" tab and have it update information
across all the other tabs.... the other tabs are not in the same order as the
master.... please help!!!
 
G

Gary''s Student

Use linking formulas. For example, to get data from the "Master" tab cell
B9, use:

=Master!B9
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One note creating multiple tabs when collaborating? 0
Consolidation Table from Different Excel Tabs with Different Format 1
How to set tabs in work document 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Use a master workbook to carry over changes to multiple workbooks 1
How to automate update on weekly reports spreadsheet 0
Add additional information to excel form after original data entry 0
renaming tabs to fit formulas 0

Top