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. The worksheets are in
product 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.

once you have the consolidated data in one sheet-- can you not sort the data
to get it into the order you want (or use a pivot table)?

"Dave" wrote:

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. The worksheets are in
product 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.

Excel should keep the consolidated worksheet in sequence as the input is in
sequence It turns out you can sort the output sheet, but not keeping the
output in sequence with input sheets in sequence is an Excel problem.


"JB Kuppe" <jb-at-boardwalktech.com wrote in message
...
once you have the consolidated data in one sheet-- can you not sort the
data
to get it into the order you want (or use a pivot table)?

"Dave" wrote:

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. The worksheets are in
product 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.