User selection and generator

[ysherriff]

To all,

I have a generator that filters based on PSR name and copies to a template. Does anyone know of a resource, where a userbox will show up with the names and then I can select the name I want to generate. As the code stands now, if i hit the generatoreprts macro, all 89 reports will generate. I want to have an option to generate all reports or choose a name and generate it based on that.

I have attached the excel file with the generator code.

I will attempt to see on my own as well if there is something out there.

Thanks

 

[Smallman]

Hi Ysherriff

From what I can tell you have made a relatively simple procedure and created something not so simple. From what I can tell you have two sheets which are linked by unique identifier. Is there any reason this could not be one sheet with Filled, State and NTID all in the one tab? Even if you had a third tab that married the data together it would be better. With a UID you can join them easily. Also with one less sheet you can now put your template inside this workbook and push information into the template. The userfom only serves to further complicate the procedure IMO.

You could have a tab titled List and instead of looping through each of the line items in the PSR REV TGT tab you could just put the line or lines you want to include in the List tab. Then just iterate through that list. It is a simple procedure which would import only the data you want then save an close the file with a unique name and date combination.

I think it should be a simple procedure with few lines of code.

Take care

Smallman

 

[ysherriff]

Thanks for your suggestion Smallman and I am going to work on modifying the process. I do believe the steps are cumbersome.

Thank you very muhc.