Quote:
Originally Posted by jonpackbosoxfan
No it doesnt have to be in word, but what i see as the true challenge is that if that particular vendor was not there in a particular week, i dont want them to show up on the accounting form. I just want the vendors that were there that particular work
|
Ok I think I got it. So I'm looking at week 7-24 for Wednesday. The only names I see that should come are Byard, Jake, English, Jonathan, Flores, Barbara
and their amounts. Is this correct? if so it can be done a couple ways. The first way is with an auto filter applied and select "Non Blanks" on the date specified column then copy and paste those results on your new worksheet or even your word template. The other would be to do it with VBA. Once we confirm that the 7-24 example above is correct I can start on some VBA code for you to do this.