Hello all.
I have searched over this excellent website for ideas to help me with my issue, but haven't found anything that might help. Perhaps I didn't look hard enough!
Here is the problem I'm trying to solve. Please see the attached example file.
The purpose of the spreadsheet is to let the user (any person in Group A, B, or C) know if they should raise cash in any account assigned to them. The actual spreadsheet has up to 3,000 rows of data, so it's very important to be able to sort the accounts and tell with a glance if any assigned accounts need action (based on column M).
The data is pulled and dumped into the "Data Imported Here" tab a few times a week. The row order changes all the time (information in row 4 might be found in row 632 the next time), which creates a problem I will describe later.
On the Cash Balances tab, I'm trying to display the data dumped into the second tab so it can be sorted by any user for their assigned accounts. Columns "A" - "I" all link directly to the Data sheet. Columns "J" - "M" are static and exist only on the first sheet.
Is there a way to link the information in columns J - M to each respective row so that when new data is pulled, the cash target information in J - M will still line up with the right account?
If the row order of the data isn't the same as the previous input data (which happens all the time), then the information in columns J through M won't be relevant to the "new" account and the recommendation in column M is useless.
Any recommendations on a layout for what I'm trying to accomplish? It's almost like I need a way to "Expand the selection" so the data in columns J - M is included when new data is dumped into the second tab.
Thank you! - Chris
I have searched over this excellent website for ideas to help me with my issue, but haven't found anything that might help. Perhaps I didn't look hard enough!
Here is the problem I'm trying to solve. Please see the attached example file.
The purpose of the spreadsheet is to let the user (any person in Group A, B, or C) know if they should raise cash in any account assigned to them. The actual spreadsheet has up to 3,000 rows of data, so it's very important to be able to sort the accounts and tell with a glance if any assigned accounts need action (based on column M).
The data is pulled and dumped into the "Data Imported Here" tab a few times a week. The row order changes all the time (information in row 4 might be found in row 632 the next time), which creates a problem I will describe later.
On the Cash Balances tab, I'm trying to display the data dumped into the second tab so it can be sorted by any user for their assigned accounts. Columns "A" - "I" all link directly to the Data sheet. Columns "J" - "M" are static and exist only on the first sheet.
Is there a way to link the information in columns J - M to each respective row so that when new data is pulled, the cash target information in J - M will still line up with the right account?
If the row order of the data isn't the same as the previous input data (which happens all the time), then the information in columns J through M won't be relevant to the "new" account and the recommendation in column M is useless.
Any recommendations on a layout for what I'm trying to accomplish? It's almost like I need a way to "Expand the selection" so the data in columns J - M is included when new data is dumped into the second tab.
Thank you! - Chris