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