Worksheet Consolidation - Repost requested

[Tyro]

I'm consolidating 3 worksheets into one by using Excel 2007 data
consolidation. The worksheets have product numbers in column A and sales
figures in columns B, C & D for Jan, Feb and Mar which are column headers.
The worksheets are inproduct number sequence. Not all product numbers appear
on each sheet,
so I consolidate by category using "labels in left column", "labels in top
row"
and "create links to source data" to create a consolidation sheet in outline
form. The problem is the consolidated worksheet is not in product number
sequence as I need it to be. I have books on Excel 2007 and Excel 2003 and
their consolidated worksheet examples are not in sequence either although
their input sheets
are. Any ideas? Thanks.

Tyro

 

[Gord Dibben]

I cannot help here without learning all about Data Consolidation how-to's

I have never used the feature so think I would not be much help.


Gord

 

[Guest]

can't you just sort by product code on the consolidated sheet?
i tried it. you might have to add a column heading or two but it works and
it does not break your links to the original data

 

[Tyro]

No, I cannot sort it. The consolidated sheet has product codes in column A
for the total rows and blanks in column B. The supporting detail rows have
blanks in column A and the sheet name of where the detail came from in
column B