Data in multiple workbooks
I have 20 workbooks that are used for forecasting, so they all contain the
same layout. I need to pull from each file and consolidate based on the PRACTICE column and provide each Practice manager their details. example: Security, BSO, Clarity, etc..... I need to be able to have 1 conoslidate file for each practice to show the current forecasting. What would be the best method to pull & consolidate this type of information on a weekly basis. |
Data in multiple workbooks
There are 2 possible solutions:
1) Create a consolidate file and using link/formula to link the desired data to the original 20 workbooks. Everytime open this consolidated file, you need unpdate those links, 2) Use VBA code to extract those desired data (even in closed excel files) and store them into the consolidated file. -- Best regards, --- Yongjun CHEN ================================= XLDataSoft - Data Analysis Expert, Excel/VBA Specialist - - - - www.XLDataSoft.com - - - - Free Excel-Based Data Processing Tool is Available for Download Free Excel / VBA Training Materials is Available for Download ================================= "Krista" wrote in message ... I have 20 workbooks that are used for forecasting, so they all contain the same layout. I need to pull from each file and consolidate based on the PRACTICE column and provide each Practice manager their details. example: Security, BSO, Clarity, etc..... I need to be able to have 1 conoslidate file for each practice to show the current forecasting. What would be the best method to pull & consolidate this type of information on a weekly basis. |
All times are GMT +1. The time now is 03:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com