•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to have sheet2 data in sheet1 table not move when using sort column function
Our take
Are you struggling with keeping your totals stable when sorting data across multiple sheets? Many users find that sorting in spreadsheets often disrupts critical calculations, especially when connecting data like account numbers and totals. With the right approach, you can ensure that your sheet2 totals remain aligned with their corresponding rows in sheet1, regardless of how you sort. In this guide, we’ll explore effective strategies to maintain these connections while still allowing for flexible sorting options. Let's dive in and streamline your data management!
So I have order data in sheet 2 that needs to total up into corresponding data in sheet 1.
Every order in sheet 2 gets an account #, and that acc# corresponds to a specific row on Sheet 1, but the actual total calculation goes into a different column of that same row.
Currently, i can get the function to work so long as i dont use the sort header tool which is not ideal since sometimes i need to sort by volume high/low, account name a-b, and so forth.
How do i make it so the sum tracker for each account stays in the corresponding row no matter which row the account ends up in?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Sort data with multiple header rows?Hi everyone! I am trying to see if it's possible for me to sort data in a sheet that has multiple header rows. The sheet is tracking orders in different statuses, I have it separated for the New orders in the top section, then row 11 starts those that have had initial attention, but not fully in progress, on row 25, I have a header row for those who are fully in progress, etc The purpose of the separation is because there is different information I have to keep track of for each of these statuses, but I don't want to have them in different sheets because it's so helpful to be able to refer to them all in one spot. I'm hoping to be able to alphabetically sort customer names and also sort by dates, but the date columns are not uniform throughout the different statuses. If anyone knows if this is possible, help would be so appreciated!! Nevermind everyone! I figured it out by highlighting each section and inserting a table with headers! Leaving this here and marking as solved in case it helps someone! submitted by /u/tashykat [link] [comments]
- 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]
- Is there a way to keep rows together while using the SORT Formula?I am having excel use the sort formula so it’ll automatically sort anytime a new requirement is added onto a table on another sheet. However, anytime a new requirement is added, the data in the rows (user input) doesn’t get sorted. This causes a mismatch between the user input in the row and the requirement. I looked into just using the sort function instead. However, as the column it would need to be sorted by can include letters, excel is putting those at the bottom of the list. submitted by /u/Aromatic_Presence_49 [link] [comments]