Loop Print Macro

[jaredmccullough]

This involves two worksheets for the purposes of this they will be "Sheet1" and "Sheet2". "Sheet1" is a report which utilizes a validation (list) of items in columnA of "Sheet2" (starting at row8 otherwise A8 and down). This validation is found on cell F12 of "Sheet1" and uses vlookups to populate the report based upon the value chosen from "Sheet2". The value chosen will then populate the vlookup with data from across the row of that value. I am looking to make a loop print that will print a "Sheet1" report for all values in "Sheet2" that have the status of "NO" in columnV. So essentially how it works is the macro itself will run the validation for items with "NO" populate the report print it then move on to the next.

See similar thread for somewhat of same concept: http://www.mrexcel.com/forum/excel-q...cro-twist.html
Thanks in advance.

[protonLeah]

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

[jaredmccullough]

Proton,

Are you asking that I attach the workbook?

[protonLeah]

Yes, please...

[jaredmccullough]

(PSM-14-02) PSAudit.xlsm

Proton attached is the workbook. WS Name "PSM-14-02A" is the report file cell F12 contains the validation list. WS Name "Recommendations" is the database if you look in columnV it identifies status of "Yes" or "No". What I want the macro to do is run the validation for all "No" and print the report individually for each.

[protonLeah]

Please Login or Register  to view this content.

[jaredmccullough]

Please Login or Register  to view this content.

Proton,

Works perfectly if I could give you a thousand *Rep I would

Jared