Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
gathering values from multiple workbooks
Help! My boss wants some stats. In order to get her what she needs, I will
have to open several hundred password protected workbooks (each workbook has five pages), copy a column from worksheet 4, and paste the values to a new workbook. I tried using Access to gather the data, but it just laughed at me. Any suggestions on how to make the work go faster? WinXP, Office 2003. Thanks! ----- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
gathering values from multiple workbooks
Try this add-in
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rotata" wrote in message ... Help! My boss wants some stats. In order to get her what she needs, I will have to open several hundred password protected workbooks (each workbook has five pages), copy a column from worksheet 4, and paste the values to a new workbook. I tried using Access to gather the data, but it just laughed at me. Any suggestions on how to make the work go faster? WinXP, Office 2003. Thanks! ----- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
gathering values from multiple workbooks
Oops
Here is the link http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rotata" wrote in message ... Help! My boss wants some stats. In order to get her what she needs, I will have to open several hundred password protected workbooks (each workbook has five pages), copy a column from worksheet 4, and paste the values to a new workbook. I tried using Access to gather the data, but it just laughed at me. Any suggestions on how to make the work go faster? WinXP, Office 2003. Thanks! ----- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
gathering values from multiple workbooks
Ron,
Thank you for the add-in. I checked the tips and your web page for instructions. I experimented with both b5:b18 and b5,b6,b7... and also the level of folders. Although it does not do exactly what I need, it keeps me from having to open 637 workbooks. Is there any way to make the outcome look like: Aug Sep Oct Nov 10 11 12 19 43 48 47 45 15 14 15 12 97 99 100 98 Thanks! -- "Ron de Bruin" wrote: Oops Here is the link http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rotata" wrote in message ... Help! My boss wants some stats. In order to get her what she needs, I will have to open several hundred password protected workbooks (each workbook has five pages), copy a column from worksheet 4, and paste the values to a new workbook. I tried using Access to gather the data, but it just laughed at me. Any suggestions on how to make the work go faster? WinXP, Office 2003. Thanks! ----- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
gathering values from multiple workbooks
Almost everything is possible with a macro
But I need more info about the cell range you want to merge and how you want it in the merge sheet -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rotata" wrote in message ... Ron, Thank you for the add-in. I checked the tips and your web page for instructions. I experimented with both b5:b18 and b5,b6,b7... and also the level of folders. Although it does not do exactly what I need, it keeps me from having to open 637 workbooks. Is there any way to make the outcome look like: Aug Sep Oct Nov 10 11 12 19 43 48 47 45 15 14 15 12 97 99 100 98 Thanks! -- "Ron de Bruin" wrote: Oops Here is the link http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rotata" wrote in message ... Help! My boss wants some stats. In order to get her what she needs, I will have to open several hundred password protected workbooks (each workbook has five pages), copy a column from worksheet 4, and paste the values to a new workbook. I tried using Access to gather the data, but it just laughed at me. Any suggestions on how to make the work go faster? WinXP, Office 2003. Thanks! ----- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Gathering rows of data from multiple wrkbks to single column | Excel Worksheet Functions | |||
gathering multiple spreadsheets into one | Excel Worksheet Functions | |||
Gathering data from multiple worksheets | Excel Discussion (Misc queries) | |||
Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions |