You can group your sheets together, so that whatever you do to one, you do
to all.
Click on the Sheet1 tab,
Hold down <Ctrl>, and click in the tabs of the other two sheets.
All tabs are now white, with Sheet1's tab in bold, meaning that's the "main"
sheet.
Also, in the title bar, the name of the WB is appended with "[Group]",
reminding you that sheets are grouped together.
NOW, *whatever* you do to Sheet1, will be duplicated in the other two
sheets.
Don't forget to *ungroup* your sheets when you're finished with your
changes.
Right click in a tab, and choose "UngroupSheets".
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
My workbook has 3 worksheets. Worksheet 2&3 are linked to
worksheet1. When I insert a row to worksheet 1, I would
like the same row to be automatically added to worksheets
2&3. Is this possible? Thanks.
