View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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!!!