Google Answers Logo
View Question
Q: Need an excel macro created ( No Answer,   2 Comments )
Subject: Need an excel macro created
Category: Computers > Programming
Asked by: broberts-ga
List Price: $20.00
Posted: 26 Sep 2006 17:34 PDT
Expires: 26 Oct 2006 17:34 PDT
Question ID: 768693
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).

There is no answer at this time.

Subject: Re: Need an excel macro created
From: rhenerlau-ga on 27 Sep 2006 12:43 PDT
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.
Subject: Re: Need an excel macro created
From: twk187-ga on 27 Sep 2006 13:43 PDT
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?

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy