add new data to specific columns in multiple worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

juliebythesea - 09 Jul 2007 17:02 GMT

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

Reply to this Message

Gord Dibben - 09 Jul 2007 21:20 GMT

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

>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.
[quoted text clipped - 8 lines]
>what is relevant on their particular sheets. Is there an easier way? A macro
>maybe? Version Excel 2003

Reply to this Message

juliebythesea - 10 Jul 2007 01:24 GMT

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

> You could link sheets 2 and 3 back to sheet1
>
[quoted text clipped - 19 lines]
> >what is relevant on their particular sheets. Is there an easier way? A macro
> >maybe? Version Excel 2003

Reply to this Message

Rate this thread: