MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sharing data between workbooks

Posted by Brett on December 09, 2001 6:56 PM

Is there any way when you are sharing data between worksheets to have a row automatically inserted in one when it has been done in the other!?

I have linked cells etc but when i insert a row it just moves the link for the cells and doesnt insert another line. I have other data in the rows that isnt linked and this needs to be moved as well?

Can anyone out there help!?

Posted by Bariloche on December 09, 2001 7:29 PM


If you "group" the sheets, whatever happens on one happens on the other. You can group sheets in two ways. If you want to group two (or more) sheets that aren't right next to each other, click on the sheet tabs while holding down the Ctrl key; you should see each tab that you click on hilighted. If the sheets you want to group are all next to each other you can click on the first tab, hold down the Shift key and click on the last sheet and all sheet tabs from the first to the last will be hilighted and included in the group.

This is a very useful but "dangerous" technique. Remember, whatever you do on one sheet in the group will also happen to the others.

have fun

Posted by Brett on December 09, 2001 9:38 PM

No the grouping doesnt work unless i can have them grouped at all tims and also the way the sheet is the master sheet has several columns but only one relates to each of the secondary sheets. So i need to link the data in the diff columns to diff sheets.