I need a excel (2003) macro written which will take specified data
from every separate worksheets within multiple files and paste it to a
separate excel data file, single worksheet.  Basically consolidating
similar data stored in separate files and worksheets into a singe file
and single worksheet.

---

Request for Question Clarification by maniac-ga on 27 Sep 2006 17:11 PDT

Hello Broberts,

Can you please describe the layout of:
 - the source data to be copied
 - the destination worksheet

For example, as source data you have files A, B, and C in a directory,
each having 1, 2, and 3 worksheets respectively; the data to be copied
is in cells C3:C8 (or a named region as suggested by twk187). If the
list of files / sheets is known, please indicate that (e.g., a fixed
list in the macro or perhaps a region in the workbook w/ the macro) or
alternatively if you want all files in a directory / all sheets in
those workbooks to be processed.

For example, as the destination layout, the results should appear in
the first worksheet, starting at cell A2 & going down, being saved in
file D.

The complete solution would include both the macro as well as
instructions on how to load it into one of your workbooks (or the
"personal" workbook used by each user).

Thanks.
  --Maniac

I'm not sure you can do it - Excel macros are workbook specific.  You
would need to copy and paste the macro code into each workbook you
wanted to use as a source for the combined workbook document.

It is possible to have a macro that is available everytime you run Excel.

Do you already have the workbooks open or do you want the macro to select them?

Also, are are you determining which data to consolidate?  Is it the
same cells, rows, columns, named ranges in each workbook?