HELP Linking worksheet problem

%3CLINGO-SUB%20id%3D%22lingo-sub-73283%22%20slang%3D%22en-US%22%3EHELP%20Linking%20worksheet%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-73283%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20linking%20data%20from%20one%20worksheet%20to%20another.%26nbsp%3BWe%20will%20call%20the%20Main%20Sheet%20A%20and%20the%20worksheet%20with%20the%20data%20as%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20insert%20a%20line%20into%20worksheet%20B%20it%20completely%20throws%26nbsp%3Beverthing%20out%20in%26nbsp%3Bworksheet%20A.%20In%20other%20words%20it%20doesn't%20hold%20the%20original%20cell%20where%20the%20data%20is%20linked%20and%20moves%20everything%20around.%3C%2FP%3E%3CP%3EHELP%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ECarol%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-73335%22%20slang%3D%22en-US%22%3ERE%3A%20HELP%20Linking%20worksheet%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-73335%22%20slang%3D%22en-US%22%3EI%20would%20recommend%20that%20you%20ask%20this%20type%20of%20question%20in%20the%20Excel%20community%20space.%20You%20are%20more%20likely%20to%20get%20the%20attention%20of%20someone%20who%20has%20the%20specific%20expertise.%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi All,

 

I have been linking data from one worksheet to another. We will call the Main Sheet A and the worksheet with the data as B.

 

When I insert a line into worksheet B it completely throws everthing out in worksheet A. In other words it doesn't hold the original cell where the data is linked and moves everything around.

HELP

 

Thanks,

Carol 

1 Reply
I would recommend that you ask this type of question in the Excel community space. You are more likely to get the attention of someone who has the specific expertise.