Sep 28 2021 12:52 PM
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?
Oct 04 2021 09:16 PM
Oct 04 2021 10:10 PM