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

Sumif to multiple tabs 1
Reference the same cell based on tab name 1
link worksheets by proper identificaton from master 2
Autofill in Various Tabs 1
Hiding tabs for just some sheets. 4
Function for multiple tabs in one worksheet 2
Find and return name of worksheet tab for referenced cell 2
want to share workbook but limit the sheets each user sees 5

Top