Hi all, I have a problem that I am hoping someone can help me out with.
I have a large excel document that I keep am using to keep track of customer information. One of sheet of the workbook I have a list of all customers including name, order numbers, start/end dates, then information on ramp up/down on their orders. I have the data for each customer grouped so that I can collapse all of the detail rows leaving only the top row for each customer visible. In that top row, I have a function that pulls the relevant order information from the grouped rows based on the date. Quick example below. Row 1 will always be visible and it pulls the relevant/Current order from the cells below. Rows 2-4 would be grouped and collapsed to be easily reviewed, but out of sight unless needed. Row 5 is the start of the next customer.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Customer A Top Row[/TD]
[TD]Relevant/Current Information[/TD]
[/TR]
[TR]
[TD]Customer A Grouped Row[/TD]
[TD]Historical Order data[/TD]
[/TR]
[TR]
[TD]Customer A Grouped Row[/TD]
[TD]Current Order data[/TD]
[/TR]
[TR]
[TD]Customer A Grouped Row[/TD]
[TD]Future Order data[/TD]
[/TR]
[TR]
[TD]Customer B Top Row[/TD]
[TD]Relevant/Current Information[/TD]
[/TR]
</tbody>[/TABLE]
The part that I am having a problem with is now I am trying to take the customer data and split it by region. Each region having a different sheet. I am hoping there is a way that I can setup Customer A in the region, then drag the formula/cell references down but only get that top row of relevant data for Customer B. If Customer A's information (Row 1 above) is in Cell A19, then when I drag the formula/cell reference down to A20, I would want to get Customer B's information (Row 5 above). The number of rows for each customer can vary between 1 row up to as many as 15 rows, so I can't do a simple offset unless I push each customer to have the same number of rows whether they need it or not. I hope I am making sense with what I am asking here.
Thanks for any help!
I have a large excel document that I keep am using to keep track of customer information. One of sheet of the workbook I have a list of all customers including name, order numbers, start/end dates, then information on ramp up/down on their orders. I have the data for each customer grouped so that I can collapse all of the detail rows leaving only the top row for each customer visible. In that top row, I have a function that pulls the relevant order information from the grouped rows based on the date. Quick example below. Row 1 will always be visible and it pulls the relevant/Current order from the cells below. Rows 2-4 would be grouped and collapsed to be easily reviewed, but out of sight unless needed. Row 5 is the start of the next customer.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Customer A Top Row[/TD]
[TD]Relevant/Current Information[/TD]
[/TR]
[TR]
[TD]Customer A Grouped Row[/TD]
[TD]Historical Order data[/TD]
[/TR]
[TR]
[TD]Customer A Grouped Row[/TD]
[TD]Current Order data[/TD]
[/TR]
[TR]
[TD]Customer A Grouped Row[/TD]
[TD]Future Order data[/TD]
[/TR]
[TR]
[TD]Customer B Top Row[/TD]
[TD]Relevant/Current Information[/TD]
[/TR]
</tbody>[/TABLE]
The part that I am having a problem with is now I am trying to take the customer data and split it by region. Each region having a different sheet. I am hoping there is a way that I can setup Customer A in the region, then drag the formula/cell references down but only get that top row of relevant data for Customer B. If Customer A's information (Row 1 above) is in Cell A19, then when I drag the formula/cell reference down to A20, I would want to get Customer B's information (Row 5 above). The number of rows for each customer can vary between 1 row up to as many as 15 rows, so I can't do a simple offset unless I push each customer to have the same number of rows whether they need it or not. I hope I am making sense with what I am asking here.
Thanks for any help!
