Hi and thanks for your response. I have a lot of ideas,
but I guess that I need to think through all of the
possibilities. I have created all the the macros,
summaries and graphs for all my other reports. This is a
little more complex than my other reports because I am
using so mayny sources. You did bring up some good
points on the file names, positions, and vlookup. I will
be sure follow your suggestions. Thanks for your
assistance and have a great day!

Julie
-----Original Message-----
Hi Julie,
Your request is too vague and not possible with just a
few clicks of the mouse and some coding here and there,
consider the following, can you guarantee that the
SELECT
data is always in the same place (same number of rows
columns) for each rerun of the report and for each
report,
the file names are always the same. Alternative, are all
five reports coming from one system, if so surely the
report provider can create a new report to you
requirement. if your company has and IT department, go
an
speak to them and ask them to sort you out an over
summary
report, if that not available then I suggest you take a
look at RentACoder.com, for a small fee someone will
fill
your requirements.... for a small fee of course. If this
option is also not possible you'll need to be more
specific eg what does you data look like, say for
example
the 5 reports are 5 regions that show revenue for
products, if the is a product code you could use a
vlookup
function across all five reports, but remember to call
your workbooks none specific eg don't label them Region
North 200312.xls because you'll only have to update each
referrence link every month. Name the 5 reports
accordingly like Region North.xls this way your
reporting
set of six files can be updated when ever and at the end
of each month you can store the monthly reports so if
required you can replace the Region North.xls with a
stored Region North 200312.xls and rename is to Region
North.xls. Anyway I sure I've proposed many question but
its best that you speak to your IT department.

regards
KM


-----Original Message-----
Hello all! I recently posted a message, but got no
response. I was wondering if anyone could get me
started
on this. Any suggestions would be appreciated. I have
several reports that I want to take select information
from (all in Excel format) and put that information
into
a temporary file (Excel preferably)and hold it until I
am
ready to use it for a mass report? I want the
information update everytime I run one of the reports.

The reason that I am needing this is because I have
five
different reports that I run on a monthly basis. I
want
to take SELECT information from each of those reports
and
put it into one big report. I want the temporary file
to
update when I run one of those five reports. Each
report
needs to be on a separate sheet. I need the sheet to
update when I run the small report. When this update
is
done, I don't want to override the file, I want to
override the sheet. Then, I want to create a macro to
retreive the information from the temporary file.

Are there any suggestions on how to get this started?
I
need to somehow create link between the temporary file
and the five reports that I run every month. Any help
would be greatly appreciated. Thanks in advance and
Happy Holidays!

Julie
.

.