adding data simultaneously onto 3 worksheets
 

I have a worksheet with multiple columns.
Col A date, Col B text, Column C cash, Column D cash, Column E cash.
When I add data to sheet 1, I would like the same data I have entered in
column A only to appear on sheets 2 and 3.
If possible I would also like
any data entered in column C of worksheet 1 and column D of worksheet 2 to
appear in (new) columns F & G of worksheet 3.
Can anyone tell me if this is possible? I am using Excel 2000 (9.0.3821 SR -1)
Thanks

adding data simultaneously onto 3 worksheets
 

Joy

In A1 of sheet2 enter =IF(sheet1!A1="","",sheet1!A1)

Copy down as far as you wish.

Do same for A1 of sheet3

Following the same pattern for linking sheet3 columns F and G back to sheet1
column C and sheet2 column D


Gord Dibben MS Excel MVP


On Sun, 13 May 2007 10:48:00 -0700, Joy wrote:

I have a worksheet with multiple columns.
Col A date, Col B text, Column C cash, Column D cash, Column E cash.
When I add data to sheet 1, I would like the same data I have entered in
column A only to appear on sheets 2 and 3.
If possible I would also like
any data entered in column C of worksheet 1 and column D of worksheet 2 to
appear in (new) columns F & G of worksheet 3.
Can anyone tell me if this is possible? I am using Excel 2000 (9.0.3821 SR -1)
Thanks