How do I have a tab exactly mimic another tab in the same worksheet...constantly?

[stompy]

Does anyone know how to have a tab constantly mimic another tab in the same worksheet? As in, not only will tab A be cell for cell equal to tab B, but if i insert a new row in tab B, tab A will also have the same row inserted. Not sure if this is a vba question or not but I can't figure it out.

Thanks

[Søren Larsen]

A quick way is to select both sheets before making changes; then changes made to the visible sheet are mirrored on the other selected sheet. Not sure if this is what you are looking for.

[Richard Buttrey]

Hi

You can put the sheets (any number of sheets) into Group mode by holding the CTRL key down and selecting a sheet tab name. You'll see the word 'Group' appear after the name of the workbook above the ribbon.

Any change made to any of the grouped sheets will be made to all.

To switch off Group mode either select a non grouped sheet or right click on a grouped sheet tab name and select Ungroup Sheets.

[dfulmer]

Hi

You can put the sheets (any number of sheets) into Group mode by holding the CTRL key down and selecting a sheet tab name. You'll see the word 'Group' appear after the name of the workbook above the ribbon.

Any change made to any of the grouped sheets will be made to all.

To switch off Group mode either select a non grouped sheet or right click on a grouped sheet tab name and select Ungroup Sheets.

I know this thread is long dead, but I've been searching for something like this for a while now. Is there any way to have it group only part of a sheet? Basically I want to be able to add several rows to one sheet and have those mimicked across all of the sheets. BUT I only want it to copy the text I enter in Column A and then the rest of the cells stay unique for each sheet. Does that make sense?

[arlu1201]

dfulmer,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.