I have a worksheet createed that has a bunch of formulas in it. It is saved
in it's own file.

Standing on its own, the formula is all junk, because there is no data to
count and such.

I want to create a macro that will put this table into a worksheet that has
the data and have all of the formulas work.

This will be a monthly report counting empoloyees and complaints. The
reason I want to have the table seperate is changes can be made more readily
to the table than the macro.

Is this possible, how will I do it?

Can the formulas be put in with the table - ie does the table come from you
as a template?

I tend to look for solutions without macros - one way is to point all the
formulas in the "report" workbook to the "data" workbook. If all the data
workbooks have consistent naming format that just changes the month ie
dataJUL08 dataJun08, then build the set of formulas with then pointing to
Jun08, and when the Jul08 comes along use the REPLACE menu tool to FIND Jun08
and REPLACE with JUL08.

The complexity depends a lot on how often you have to do it, and features
such as the consistency of filenames etc.

Bill



"Jeremy" wrote:

I have a worksheet createed that has a bunch of formulas in it. It is saved
in it's own file.

Standing on its own, the formula is all junk, because there is no data to
count and such.

I want to create a macro that will put this table into a worksheet that has
the data and have all of the formulas work.

This will be a monthly report counting empoloyees and complaints. The
reason I want to have the table seperate is changes can be made more readily
to the table than the macro.

Is this possible, how will I do it?