Hi all;
I am automating a workbook for our night audit team to use for Accounts Payable. My problem is that at the site level we track AP by accounting code, whereas Head Office oonly wants the company & invoice number listed. Our AP is split between 2 categories; General (housing) & Food (Food Services)
I have got the system mostly set but need a hand with the final step. For head office they only want to see 1 line per invooice with company, invoice #, date, & $ total. I have all the listings set but do not know how to make the information compile onto a single line on the page.
I have somewhat denatured the attached workbook but you will see my problem in the "Header General" & "Header Foods" tabs. These are the ones going to H/O.
The PAP tabs can be disregarded as there is never a split invoice on those tabs.
Any ideas would be greatly appreciated by the few remaining strands of hair that I have not yet pulled out.
Bookmarks