View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Harry's GMail World Harry's GMail World is offline
external usenet poster
 
Posts: 12
Default Data from old WKS to new WKS

Do a report that contains data by Day and Month and categories. This
data is summarized in a 'square' listing totals by Month/Year.

Also, have a template that is used to generate the new report. I have
to then xfer the data from the current monthly 'chart listing' to the
Template which is then renamed to the Current Month.

I thought of a Macro but was stymied by the problem that the month I
was copying FROM would change.

Now, I copy/paste the info. Another way?