ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Update one worksheet tab to automatically update all other tabs? (https://www.excelbanter.com/excel-worksheet-functions/231828-update-one-worksheet-tab-automatically-update-all-other-tabs.html)

shoechic1

Update one worksheet tab to automatically update all other tabs?
 
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!!!

Gary''s Student

Update one worksheet tab to automatically update all other tabs?
 
Use linking formulas. For example, to get data from the "Master" tab cell
B9, use:

=Master!B9

--
Gary''s Student - gsnu200854


"shoechic1" wrote:

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!!!



All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com