Click Button to create a PDF based on criteria (prompts,combobox,other)

[Andre Pereira]

Hi there guys,

hope that you're all well.

I'm writing to you to ask you for help to create \ develop some macro base on combo box and click button that allows me to create a PDF based on some selection (criteria) that should be defined by me, previously (prompt, combo box, other suggestion)

I attached an excel file with my personnel example, but i'll leave you the mainframe of my request for help.

Key1 - With a combo box embedded on file, i link a whole database to a short data sheet of information.
Key2 - An unique identifier marked as "A,B,C,D,etc..."
Timeline - I have all data placed in columns (month by month)

The data sheet have a sumifs linked to a database sheet, this sumifs changes in way the combobox1 changes.

What i seek for this matter.

Have a 3 condition filter (separated), could be base on combobox, that ask's which criteria \ data you want to print or some prompt that comes up everytime the user hits the "Create PDF" button.
Have a click button to, when this 3 conditions are fulfill it generates a PDF base on this criteria. This means that, if i select a KEY1 different from the combobox1 that's already on file, that means the combox should change as well in order to the data sheet is up to date.

The file attached is simple but if i'm not clear with my request feel free to make your questions.

Link to file:
https://www.dropbox.com/s/axx8ujwsf38uy9g/CLICKBUTTON1.xlsm?dl=0

Once again, thank you all for the time

Regards
André

 

[Andre Pereira]

Hi there fellas,

it's a huge request isn't it?
if anyone can help i'll be much appreciated.

Regards
Andre