Hi all. Need help printing commission statements. I have a group of 50 employees receiving commissions. The commissions are summarized in an excel sheet. I created a statement form that has a bunch of vlookup formulas using an employee id and looking to the summary spreadsheet. Currently I load an employee # print to pdf then repeat 50 times. Looking for solution to automate with a macro. Help!
This is easily doable, but would be expedited by your posting of a sample workbook stripped of sensitive information. As is, it's difficult for anyone reading your thread to understand exactly how the data is structured.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
I've posted similar code. With the limited information I'll outline some steps
1. Build a loop to enter the names into the cell that affects the VLOOKUPs
2.In the loop have the code to create the pdf, you will need the pdf addin for Office 2007 & code from Ron de Bruin
Something like
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks