Macro to Save to PDF

[avi.sheleg]

Hello Everone,
I have an excel file with two worksheets, in one of them I have a table with names of my sales employees and their sales targets throughout the quarter/year.
In the second sheet I have a table where I'm running VLOOKUP to calculate the commission if each sales employee, I simply type the name of the employee same as I have on sheet #1 and the formula calculates the commission, which then I save as PDF and send to the employee for final signing.
I would appreciate if someone can assist me with a script to automate the entire process including the "save to pdf".
Thank you very much!
Avi

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time.)

[avi.sheleg]

Thank you Ali for pointing this out for me.

[Anthony57]

My first post and I can answer some of the question, I run a macro that does that plus other things, hopefully I have pulled out the relevant bits.

Please Login or Register  to view this content.

End Sub

Hope you find the answer to the other elements of your request.

[avi.sheleg]

Thank you very much Anthony!
Just to make sure I understand, as I don't have an experience with scripts, do I need to change the name of the employee manually? or is it being taken from the sheet and calculated?
If you would like I can add the excel here.
Thank you.

[Anthony57]

I PM'd you but not convinced it was sent?

Tony