Help again!

%3CLINGO-SUB%20id%3D%22lingo-sub-1468464%22%20slang%3D%22en-US%22%3EHelp%20again!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1468464%22%20slang%3D%22en-US%22%3E%3CP%3EI%20don't%20know%20if%20this%20can%20be%20done%20or%20not%20but%20help%20would%20be%20appreciated.%3C%2FP%3E%3CP%3EI%20am%20compiling%20a%20workbook%20spread%20over%204%20sheets%3C%2FP%3E%3CP%3EThe%20first%203%20columns%20on%20each%20sheet%20remain%20the%20same.%3C%2FP%3E%3CP%3EAt%20the%20moment%20I%20simply%20tell%20the%202nd%2C%203rd%20%26amp%3B%204th%20sheet%20to%20copy%20columns%20A%20%26amp%3B%20B%20from%20the%20first%20sheet%20(%20%3D'sheet1'A%3AA%20%26amp%3B%20%3D'sheet1'B%3AB).%3C%2FP%3E%3CP%3Ethis%20works%20in%20that%20it%20copies%20the%20required%20info.%3C%2FP%3E%3CP%3EHowever%20if%20i%20insert%20a%20row%20on%20sheet%201%20it%20is%20not%20replicated%20on%20the%20other%20sheets%2C%20neither%20is%20it%20is%20i%20delete%20a%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20there%20a%20way%20that%20any%20action%20on%20column%20A%20%26amp%3B%20B%20in%20sheet%201%20can%20'auto%20replicate%20'%20onto%20the%20other%20sheets%20(Especially%20if%20i'm%20inserting%20a%20row)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1468464%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

I don't know if this can be done or not but help would be appreciated.

I am compiling a workbook spread over 4 sheets

The first 3 columns on each sheet remain the same.

At the moment I simply tell the 2nd, 3rd & 4th sheet to copy columns A & B from the first sheet ( ='sheet1'A:A & ='sheet1'B:B).

this works in that it copies the required info.

However if i insert a row on sheet 1 it is not replicated on the other sheets, neither is it is i delete a row.

 

is there a way that any action on column A & B in sheet 1 can 'auto replicate ' onto the other sheets (Especially if i'm inserting a row)?

1 Reply
Highlighted

@clk616 

 

One of the interesting things about Excel is that there are often multiple ways to accomplish end goals. You can tell that's the case because often even after a question has been answered somebody else will come along and offer an "alternate take" or "alternate way to look at this."

 

I mention that because it would help here if we could get a more in depth understanding of what you're actually trying to accomplish. Could you back up and just describe the "application" or the "business process" or whatever it is that has given rise to your question.

 

And if you could accompany that with a copy of the workbook you have developed so far, that would go a long way toward helping us understand your situation. Possible? Just make sure there is no private or confidential info in your workbook.