2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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?

submitted by /u/stretchingmofos
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#row zero
#google sheets
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#sheet 1
#sheet 2
#data