View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeremy Jeremy is offline
external usenet poster
 
Posts: 85
Default Pulling table into new worksheet

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?