Thank you! I've attached the worksheet, and cut out all of the identifying information. I added three "desired results" tabs, for the three different vendors, and I left the formulas that work intact.
Essentially, on the Memo Creator tab, the only two fields that should be manipulated are B17 (a drop down LOVs) and N9.
When you choose 123 Company, I only want two out of the three invoices listed on the Masters Invoice Entry tab to appear. The ones that match 123 company and are for the month of March. I do NOT want the April 2018 invoice to appear.
Hope this makes sense.
Thank you!!
Bookmarks