Create relationship between sheets

[Tyson79]

Hi,

I have a workbook with several worksheets. I want to create a relationship linking the first worksheet to all subsequent worksheets so that when i add a row into the first worksheet, a row is added into the subsequent worksheets, and likewise if i delete a row.

The reason being.....i have a heap of data and to keep it all on the one worksheet is becoming unmanagable, so i want to split it over several worksheets depending upon category i.e Personal info, financial info, statistical info etc etc.

However, as each row relates to an individual, (and is in alphabetial order) and individuals come and go, i need to be able to add and remove rows accordingly in each worksheet, but want an automated way to do this by just doing it on the first main worksheet.

If anyone has understood my ramblings, please tell me this is possible

Thank You

 

[nightcrawler23]

Try selecting all sheets together and adding or deleting rows. This change will occur in all sheets.

 

[nightcrawler23]

Advanced:
Write a code to select all sheets in your workbook. Assign it to a shortcut key( say ctrl+Q: i use this because it is not default assigned to any function and easy to press).

Then everytime you have to add or delete a row, press your shortcut key and perform your action.