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