See help on linking between worksheets.


Gord Dibben MS Excel MVP

On Thu, 6 Nov 2008 08:13:01 -0800, twinmommie
wrote:

I have a spreadsheet with 11 tabs. The first tab (tab A) contains all the
info. The subsequent tabs are info (tabs 2 - 10) containing parts (sections)
of the first tab. Can I set up excel so that when I update the info in Tab
A, the info will automatically update in Tabs 2 - 10 without me having to go
into each tab individually and change the info.

Thanks!