Repeat same data entry to multiple worksheets without Group Functi

V

vstar

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
 
G

Gord Dibben

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
 
Top