macro

[Guest]

Every day I create 2 reports for our accounting department. In these reports
I gather an amount of data for that date, column 1 is the date and I sort and
subtotal the data. I do this for two reports. Is there a way to automatic
this task.

 

[Otto Moehrbach]

John
Certainly. But you don't provide any info for anyone to work on. Post
back and provide examples of what you have to work with and what you want as
the end product. Please don't attach a file to a posting. HTH Otto

 

[Fredrik Wahlgren]

Every day I create 2 reports for our accounting department. In these reports
I gather an amount of data for that date, column 1 is the date and I sort and
subtotal the data. I do this for two reports. Is there a way to automatic
this task.

If you do exactly the same every day, you should be able to automate this
task by recording a macro that you can call.

/Fredrik