| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering Data into worksheets Simultaneously | Excel Worksheet Functions | |||
| Format multiple Worksheets Simultaneously | Excel Discussion (Misc queries) | |||
| Add a Row to Multiple Worksheets Simultaneously | Excel Worksheet Functions | |||
| View worksheets simultaneously | Excel Discussion (Misc queries) | |||
| Sorting multiple worksheets simultaneously | Excel Discussion (Misc queries) | |||
Linear Mode
