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