| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I pull data from multiple user workbooks into one? | Excel Discussion (Misc queries) | |||
| Sorting Data from Multiple Workbooks | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| Putting data from multiple worksheets into one | Excel Discussion (Misc queries) | |||
| Reference multiple cells in if statement | Excel Worksheet Functions | |||
Threaded Mode
