Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to consolidate multiple ranges
I have two worksheets containing 6 columns of data. The data in the first
worksheets represents customer orders at a very detailed level. The second worksheet shows shipments on those orders at a much less detailed level. The columns in both worksheets contain data that when I paste one on top of the other in a third excel worksheet provides meaningful analysis for management. We'd like to elimate the cutting and pasting in order to make the tool more userfriendly. I tried to use pivot tables from multiple ranges and found that while they work, the pivot table is much less meaninful when using that fuctionality. Using a macro or visual basic, is there a way to combine the data in the two worksheets in a third worksheet that can be summarized in a pivot table? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate tables/ranges with text from multiple worksheets | Excel Discussion (Misc queries) | |||
How do I consolidate data into ranges | Excel Discussion (Misc queries) | |||
Combining name ranges to create database. Pivot? Consolidate? I've tried and I'm stuck! | Excel Programming | |||
Consolidate Ranges into 1 Workbook | Excel Programming | |||
Help needed to consolidate variable ranges in excel vba | Excel Programming |