Forum Discussion
how to list multiple invoices against single PO both being seperate sheets in the same workbook
Dear Friends, i have a work book in which there are many worksheets. one of them is named PO and another is invoice. in the PO worksheet there is a list of PO s received along with other details. ...
I suggest you use either Power Query add-in (prior Excel 2016) or the Get&Transform option in Excel 2016 (as this (Get&Transform) is a default functionality starting from 2016).
Here on this site there is even a dedicated community for that:
It does exactly (and many more things) what you need.