Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting values from multiple EXCEL spreadsheets into one
I want to extract the values from certain cells or groups of cells in a
set of many (at least 100 or more) Excel files, and transfer then combine these values into a separate Excel spreadsheet, with each set of values from the individual sheets occupying consecutive sets of cells in the combined sheet. I will then be able to do statistical analysis on the values in the combined sheet. Although I can figure out a rudimentary method using Visual Basic for Excel to do this, I am sure there must be a less kludge-y method. Can anyone offer suggestions? Thanks; Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting values from multiple EXCEL spreadsheets into one
Look at Scott's post just before yours
Subj: Cannot get total Regards, Tom Ogilvy Mike Ricks wrote in message ... I want to extract the values from certain cells or groups of cells in a set of many (at least 100 or more) Excel files, and transfer then combine these values into a separate Excel spreadsheet, with each set of values from the individual sheets occupying consecutive sets of cells in the combined sheet. I will then be able to do statistical analysis on the values in the combined sheet. Although I can figure out a rudimentary method using Visual Basic for Excel to do this, I am sure there must be a less kludge-y method. Can anyone offer suggestions? Thanks; Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting data from hyperlinked spreadsheets | Excel Worksheet Functions | |||
Extracting or Referencing named cells in multiple spreadsheets | Excel Discussion (Misc queries) | |||
finding like values in multiple excel spreadsheets | Excel Worksheet Functions | |||
Extracting data from multiple excel files. | Excel Discussion (Misc queries) | |||
Formulae extracting data from other spreadsheets | Excel Discussion (Misc queries) |