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.

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.