Forum Discussion
3way Match- PR, PO, Receipt and Invoice
Hi folks, I have 10 worksheets, is it possible to use Excel or even Copilot to assist here. I have 10 excel worksheets in a workbook with raw data from PR, PO, Receipts and AP. Is it possible to have you relate the tables using a unique field (of our choice), and you create for me a new worksheet with 3-way match between PR, PO, Receipts and AP data. Is this possible for you to do?
Not sure what you're seeking here. Your use of "you" in "Is this possible for you to do?" is confusing. Are you asking somebody here to do your work for you? Or are you asking for help in doing the work yourself? Or are you asking is it possible to do this task?
In any event, in addition to being a bit more clear with your use of second person pronouns, it would help if you would post a sample workbook. If the actual contains confidential or proprietary information, attach a mockup file that contains enough sample data to illustrate the need. (Actual Excel workbook please, not just an image)
