Adding a row in a linked worksheet

W

Warlizard

Hey there. I'm unable to add a row in a worksheet and have
it show up in a linked worksheet. The blank row appears in
the original sheet, but not in the linked one. Ideas?
 
G

Gord Dibben

Lizard

That's not how links work. Links work with cell contents only.

If you select sheet1 and CRTL + Click on sheet2 you will "group" the two
sheets.

Insert a row in sheet1 and sheet2 will get a row inserted also.

Right-click and "ungroup" or just click on any other sheet to "ungroup".

BE CAREFUL with grouped sheets. What you do to one will be done to all in the
group.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Syncing between source worksheet and dependent worksheets 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Automatic refresh in linked worksheet if row is added 1
Publisher adding blank page when printing my booklet... 2
Code to cut a paragraph that's followed by a table 2
Copying Portions of Data 0
Shared Link is showing empty notebook 1

Top