G
Guest
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.
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.