lose of coherence due to insert rows

%3CLINGO-SUB%20id%3D%22lingo-sub-2793071%22%20slang%3D%22en-US%22%3Elose%20of%20coherence%20due%20to%20insert%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2793071%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20%2C%20used%20excel%202010%3C%2FP%3E%3CP%3Ei%20have%202%20sheets%20in%20a%20book%20that%20contains%20tables.%3C%2FP%3E%3CP%3Ethe%20sheet%201%20is%20the%20pincipal%20%2C%20there%20i%20introduce%20data%20so%20the%20second%20sheet%20takes%20the%20information%20from%20sheet%201%20and%20aplies%20formulas%20then%20sheet%201%20call%20that%20information%20back%20and%20show%20it%20in%20the%20table%20and%20use%20it%20to%20do%20more%20things%20.%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20problem%20is%20%2C%20when%20i%20insert%20a%20row%20in%20sheet%201%20the%20info%20below%20moves%20but%20in%20sheet%202%20it%20doesn't%20.%20It%20is%20important%20to%20have%20the%20rows%20%22aligned%22%20to%20keep%20coherence%20in%20formulas%20in%20sheet%201%20.%26nbsp%3B%3C%2FP%3E%3CP%3EQ%3A%20Is%20it%20posible%20to%20make%20that%20when%20i%20insert%20rows%20in%20sheets1%20the%20same%20happens%20in%20sheet%202%20%3F%20if%20that%20is%20not%20possible%20how%20can%20i%20upgrade%20the%20tables%20without%20draggin%20down%20all%20the%20formulas%20again%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2793071%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2811477%22%20slang%3D%22en-US%22%3ERe%3A%20lose%20of%20coherence%20due%20to%20insert%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2811477%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1169265%22%20target%3D%22_blank%22%3E%40Jorgefar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20is%20that%20setup%20possible%20without%20problems%3F%20can%20you%20share%20your%20workbook%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

hi , used excel 2010

i have 2 sheets in a book that contains tables.

the sheet 1 is the pincipal , there i introduce data so the second sheet takes the information from sheet 1 and aplies formulas then sheet 1 call that information back and show it in the table and use it to do more things . 

the problem is , when i insert a row in sheet 1 the info below moves but in sheet 2 it doesn't . It is important to have the rows "aligned" to keep coherence in formulas in sheet 1 . 

Q: Is it posible to make that when i insert rows in sheets1 the same happens in sheet 2 ? if that is not possible how can i upgrade the tables without draggin down all the formulas again?

2 Replies

@Jorgefar 

 

How is that setup possible without problems? can you share your workbook?

Hi.
I don't know the formula you are using. When you Vlookup to link sheets, this usually happens and is generally overcome by using Index & Match formulas.
You can still fix the cell/table references with the "$" sign in either of these formulas and you'll be good to go.
Kindly share the workbook (or a sample) for further assistance