In the same spreadsheet, I am linking data from the first tab into column A of a second tab. In the second tab, I have typed data in column B. Therefore linked data in column A row 5 would relate to the typed data in column B row 5. If I insert a row in the first tab, in the second tab the linked data in column A is updated, i.e row 5 becomes row 6 but the typed data in column B row 5 does not move in alignment with the linked data in column A row 5. If I insert a new row in the first tab, how can I get the typed data in Column B (e.g row 5) to remain in alignment with column A (row 5)?
Solved by E. Q. in 30 mins