Macro- Save Mult. PDFs (900) Based On Filtered Name

September 30, 2020 at 13:46:38
Specs: Windows 10
Hi there,

I keep records of parts companies purchase, when and the amounts listed in rows. This is listed in a simple filtered excel sheet (did not generate a list). There are 900 companies with multiple purchases each month. I get about 60 - 100 requests each month to see these records.

Instead of setting the print area each time, saving as a pdf, and naming the file the company name, someone told me a macro can do all that for me. I've tried to create one multiple times with no luck. As you can imagine its very time consuming for me to do 60 - 100 of these manually.

Would anyone have suggestions? Ideally I'd like to run a macro to just run all companies and save in a file for when / if its needed.

Header in Row 1
Company Name: Column "D"
Needed Info rows needed column C - column P

I'd like to capture all the order data but some companies order less then others. Some one order, some 5,000.

I usually just send all orders for the year so it can get up there, but also be small.

Not sure really where to start. Currently I have 14,000 rows in this spreadsheet, but there are still 3 months to the year so it will get larger.

Any help or suggestions would be appreciated. New to this and realize there are programs for this but don't have the capital to invest in those, nor an IT department. Just me.



See More: Macro- Save Mult. PDFs (900) Based On Filtered Name


#1
September 30, 2020 at 14:17:42
I don't know how to to do what you want, lots of Free macro tools here that may help.
https://www.softpedia.com/dyn-searc...

Here is a start.

Pulover's Macro Creator
https://www.softpedia.com/get/Syste...
https://www.macrocreator.com/


Reply ↓  Report •

#2
September 30, 2020 at 17:52:23
We would need a little more information related to your sheet layout before any code could be written.

Based on your description, I don't quite understand how your sheet is set up such that you "set a print area" and then create the PDF.

Is your sheet already (and always) sorted by company name?

Are you always printing reports for all companies whenever you print or are you printing select companies per print job?

The more detail you can provide, the better chance than we can come up with something. Sheet layout, printing process, etc.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •
Related Solutions


Ask Question