add new data to specific columns in multiple worksheets
 

I have a very large spreadsheet that I'd like to break down into multiple
worksheets. I have only three columns that I need repeated on each worksheet.
When I add new data to these columns on sheet one, I'd like that data to be
inserted into sheets 2 and 3 and so on. I know I can group the worksheets to
accomplish this, however I'm turning the maintenance of this workbook over to
someone who is completely computer illiterate and I need to make the process
as simple as possible. Chances are excellent that the person who will be
maintaining the data will forget to ungroup the sheets and overwrite data. I
suppose I could fully replicate all data on each sheet then hide columns on
the 2nd and 3rd sheets, etc so that others looking at the data will see only
what is relevant on their particular sheets. Is there an easier way? A macro
maybe? Version Excel 2003

add new data to specific columns in multiple worksheets
 

You could link sheets 2 and 3 back to sheet1

In A1 of sheet2 and sheet3(you can group those and enter both at once)

=IF(ISBLANK(Sheet1!A1),"",Sheet1!A1) and drag across to C1

Drag all three down farther than you currently have data in sheet1 to make room
for new entries in sheet1.


Gord Dibben MS Excel MVP


On Mon, 9 Jul 2007 09:02:05 -0700, juliebythesea
wrote:

I have a very large spreadsheet that I'd like to break down into multiple
worksheets. I have only three columns that I need repeated on each worksheet.
When I add new data to these columns on sheet one, I'd like that data to be
inserted into sheets 2 and 3 and so on. I know I can group the worksheets to
accomplish this, however I'm turning the maintenance of this workbook over to
someone who is completely computer illiterate and I need to make the process
as simple as possible. Chances are excellent that the person who will be
maintaining the data will forget to ungroup the sheets and overwrite data. I
suppose I could fully replicate all data on each sheet then hide columns on
the 2nd and 3rd sheets, etc so that others looking at the data will see only
what is relevant on their particular sheets. Is there an easier way? A macro
maybe? Version Excel 2003

add new data to specific columns in multiple worksheets
 

Brilliant! Thank you so much. This does exactly what I need.

"Gord Dibben" wrote:

You could link sheets 2 and 3 back to sheet1

In A1 of sheet2 and sheet3(you can group those and enter both at once)

=IF(ISBLANK(Sheet1!A1),"",Sheet1!A1) and drag across to C1

Drag all three down farther than you currently have data in sheet1 to make room
for new entries in sheet1.


Gord Dibben MS Excel MVP


On Mon, 9 Jul 2007 09:02:05 -0700, juliebythesea
wrote:

I have a very large spreadsheet that I'd like to break down into multiple
worksheets. I have only three columns that I need repeated on each worksheet.
When I add new data to these columns on sheet one, I'd like that data to be
inserted into sheets 2 and 3 and so on. I know I can group the worksheets to
accomplish this, however I'm turning the maintenance of this workbook over to
someone who is completely computer illiterate and I need to make the process
as simple as possible. Chances are excellent that the person who will be
maintaining the data will forget to ungroup the sheets and overwrite data. I
suppose I could fully replicate all data on each sheet then hide columns on
the 2nd and 3rd sheets, etc so that others looking at the data will see only
what is relevant on their particular sheets. Is there an easier way? A macro
maybe? Version Excel 2003