Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compiling information from multiple workbooks and summarizing
I am trying to extract certain information from multiple workbooks into one
workbook sheet. The data I am wanting to compile varies between workbooks with respect to the row and column addresses. In otherwords, it isn't in the same location everytime. Most of the data is similar, but sometimes the word I am searching for and it's cooresponding value in another column but same row could be spelled wrong or somebody changed the verbiage so when I do a look up function I get N/A. Also, in one case, the look up column is to the right of the column that contains the value I want returned. So the look up function will not work because it needs to be the left most column. What I have done so far is to open each individual workbook, and select the cells that I want to copy. I then create a worksheet in my new workbook and paste special and click on paste link so that I have an updatable link to the original file. From here, I go to my summary sheet, and write my functions to go grab the information from the worksheet that I just pasted the link in. This is the only way I know how to get all the worksheets into one workbook. Any advice or articles to research that may help me would be great. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compiling information from multiple workbooks and summarizing
You can start here
http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Raptor_yf22" wrote in message ... I am trying to extract certain information from multiple workbooks into one workbook sheet. The data I am wanting to compile varies between workbooks with respect to the row and column addresses. In otherwords, it isn't in the same location everytime. Most of the data is similar, but sometimes the word I am searching for and it's cooresponding value in another column but same row could be spelled wrong or somebody changed the verbiage so when I do a look up function I get N/A. Also, in one case, the look up column is to the right of the column that contains the value I want returned. So the look up function will not work because it needs to be the left most column. What I have done so far is to open each individual workbook, and select the cells that I want to copy. I then create a worksheet in my new workbook and paste special and click on paste link so that I have an updatable link to the original file. From here, I go to my summary sheet, and write my functions to go grab the information from the worksheet that I just pasted the link in. This is the only way I know how to get all the worksheets into one workbook. Any advice or articles to research that may help me would be great. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling data from multiple worksheets into one worksheet | Excel Discussion (Misc queries) | |||
Compiling information from multiple excel files | Excel Discussion (Misc queries) | |||
How do I change cell information in multiple workbooks | Excel Discussion (Misc queries) | |||
Sharing Information Between Workbooks | Excel Worksheet Functions | |||
Looking up information in 2 different workbooks | Excel Discussion (Misc queries) |