Analysing Data in 15 Large Excel Spreadsheets

Henner · May 17th, 2002, 10:32 AM

Hi,

I download 15 spreadsheets, every hour, from 15 different geographical locations; they each have 4 column headings : Part Number, Description, Price and Stock Level. Each spreadsheet also has varying rows of data; anything from 300 to 20,000. The only data that is the same in all 15 spreadsheets is the Part Number.

I need an efficient method of analysing all 15 spreadsheets to find and list all the common part numbers showing the price and stock level.

Can anyone help please?

Regards,
Paul

Nimrod · May 17th, 2002, 10:48 AM

Have you tried consolidating information into a pivot table ?
1- copy all sheets into one book
2- goto blank sheet
3- toolbar--data--pivot table--
4- select "multiple consolidation ranges
5- Add the ranges from a 15 sheets
6- configure layout
7- done

After first time just copy sheets in, and right click PVT .. then choose refresh data ...done.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 17th, 2002, 10:32 AM	#1
Henner Board Regular Join Date: May 2002 Posts: 171	Hi, I download 15 spreadsheets, every hour, from 15 different geographical locations; they each have 4 column headings : Part Number, Description, Price and Stock Level. Each spreadsheet also has varying rows of data; anything from 300 to 20,000. The only data that is the same in all 15 spreadsheets is the Part Number. I need an efficient method of analysing all 15 spreadsheets to find and list all the common part numbers showing the price and stock level. Can anyone help please? Regards, Paul

May 17th, 2002, 10:48 AM	#2
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Have you tried consolidating information into a pivot table ? 1- copy all sheets into one book 2- goto blank sheet 3- toolbar--data--pivot table-- 4- select "multiple consolidation ranges 5- Add the ranges from a 15 sheets 6- configure layout 7- done After first time just copy sheets in, and right click PVT .. then choose refresh data ...done.