Connecting sheets where I add rows in sheet 1 but want data to stay connected and not change on sheet 2?
My title sucks. But here’s my problem.
On sheet 1 I have data. Most of is is in row A1, B1, C1…etc.
But in sheet 2 I need to break that down into “tiers” so that it shows sheet 1 A1’s data on sheet 2 A1; sheet 1 B1’s data on sheet 2 B2, sheet 1 C1’s data on sheet 2 C3, etc. etc.
Then let’s say a new group of numbers in sheet 1 starts at row A3
New group at A5, and so on.
Now I know how to connect the cells =sheet1! A1, on sheet 2 etc.
The problem is sometimes I need to add rows to sheet 1, but I DON’T want the data in sheet two to change. So like the data I have on sheet 1 A1, B1, C1 has been tiered to sheet 2 but a new set of data comes in and I have to change A1, B1, C1 but now A2, B2, C2 needs to live down on both sheets.
How do I ensure that the rows moved down in sheet 1, also live down but stay in alignment with sheet 2?
[link] [comments]
Want to read more?
Check out the full article on the original site