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.