See help on linking from one sheet to another.

Basics........................

Select Sheet2 through Sheet5

On Sheet2 enter =Sheet1!A1

Copy down as far as you wish.

Ungroup the sheets. Start entering data in Sheet1

If you don't want to see zeros, use =IF(Sheet1!A1="","",Sheet1!A1)


Gord Dibben MS Excel MVP


On Tue, 8 Jul 2008 17:11:00 -0700, vstar
wrote:

Can anyone help

How can I add data to one column of a worksheet and have the data
automatically add to the same column of several other worksheets without
having to group all the worksheets each time I enter data.

Thanks