[tloftus]

Hi all,

My first post on this forum, looking for some assistance. I've got a template for a report that I need to run aprox. 500 times each quarter. The template is completly automated, except input is needed for an ID Number, Start Date for the report and End Date for the report.

I'm trying to get a macro set up in a seperate workbook with a list of the ID Numbers, and a seperate field for Start Date and End Date. I need the macro to burn through that list, update the 3 fields in my template and Save As a different file name.

I hope I have explained what I'm trying to do but I'm stuck with this whole looping thing in VB which I'm sure I'll need.

I've attached a simple rendition of what I'm trying to accomplish, when running the macro in generator.xls it will open report.xls and update the three fields (Start Date / End Date / Name) and then 'save as the' 'Name' field (these will all be unique) in the same folder.

Can anyone offer any assistance?

Thanks in advance.

Got looping figured out!!!!! Thanks anyway.

Tom

Attached Files

•  reports.zip   2.97KB   204 downloads

Edited by tloftus, 29 July 2005 - 07:04 PM.

[Advertisements]

tloftus,

I downloaded your zips and have seen a few names in generator.xls but there is only one date. Could you change the structure to
Name Start Date End Date
Joe 12/12/2004 1/1/2005
... .... ....
or any structure to let each name have start and end date?

[paper]

tloftus,

I downloaded your zips and have seen a few names in generator.xls but there is only one date. Could you change the structure to
Name Start Date End Date
Joe 12/12/2004 1/1/2005
... .... ....
or any structure to let each name have start and end date?