adding data simultaneously onto 3 worksheets

G

Guest

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hidden rows problem 7
Scrabble Value calculation for Welsh words 0
Trying to sum cells across different worksheets in different locat 4
Copy Data from One Spreadsheet to Another ?????? 5
Trying to match 1 value to multiple columns 10
Match with 3 criteria 3
data in single column split to multiple col's based on header 2
matching & combining data from seperate worksheets 2

Top