#1
|
|||
|
|||
macro to pull data from multiple files
I need help with building a macro to pull data from over a 100 worksheets.
I have a questionnaire that I send out and now I need to pull the data from the worksheets. Every work sheet is the same. To give you an example to what I need to pull, I have a question: Is your facility a standalone or a system? In cell C10 and E10 there would be a box for them to put an X. I need to know how many X's or anything typed in that cell from all of the worksheets. To help, I have all of the worksheets saved in one folder. Thank you for your help in advance |
#2
|
|||
|
|||
Quote:
The macro would work with 1 target worksheets or 5 or 500 and can read any number of things from each worksheet as long as what is read does not change from worksheet to worksheet. I assume that you would want the macro to build a table in the master worksheet indicating each worksheet name and the relevant values read. The process steps would be:
|
#3
|
|||
|
|||
This is a great question and answer, let us know if there is going to be a youtube video of the process, I am interested to see it. I teach Excel and the objective of the more advanced groups is to create macros that save work time in cleaning up SAP imports and collect data from various places.
H |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Template pull down menus | terpsichore | Word | 0 | 03-02-2010 02:39 PM |
Macro to export document sections to individual txt files? | MJMR999 | Excel Programming | 0 | 02-18-2010 12:49 PM |
Merging Multiple Word files into One | Stattovic | Word | 0 | 01-06-2010 07:19 AM |
Generating multiple documents from 1 data source | themangoagent | Word | 2 | 08-14-2009 12:12 PM |
Help-overwriting files-could it be macro virus? | Timpotty | Word | 0 | 03-06-2009 04:28 PM |