Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Consolidating/summarizing and sorting data
I hope I can explain things well enough to avoid wasting your time. I expect
my explanation will be longer than the solution. The workbook has several worksheets but lets say there just 3, namely Summary, ThisYr and LastYr. The last two are identical in layout. They have 5 formatting rows at the top and data proper starts at row 6. Each row relates to one customer and the early columns have name and contact info and later columns contain sales data. It is quite ordinary stuff really. The only real complication is maintaining the date - inserting rows for new customers disrupt formulae on the Summary sheet. My question relates to the Summary. There isn't a correspondence of rows. Each customer has structure 5 rows tall. For example, one row relates to the current year and another row to the last year and each uses formulae to derive percentage changes etc from the other worksheets. The Customer Name is pulled from other sheets as well I need to sort this entire 5 row structure according to differing criteria within this structure such as Customer Name [top left of structure (say R1C1)] Value of Total Sales this Month [R2C(14+MonthNum)] Value of Sales this Year to Date [R3C(14+MonthNum)] Increase over last year [R5C(14+MonthNum)] Value unpaid [R5C8] etc. Is there a technique to use that will not scramble the formula references on Summary? In other words, having sorted, can I be sure that the data showing against George's name is really his data and not Bill's? T I A Len |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inconsistent Sorting | Excel Discussion (Misc queries) | |||
Sorting Ranges of Data | Excel Worksheet Functions | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Sorting Data From One Column into Multiple Columns | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |