Jul 06 2022 08:05 PM - edited Jul 06 2022 08:05 PM
Hi, the following is for a multi-vendor marketplace.
I would like to auto-populate vendor emails
listed in one spreadsheet, to appear in a separate column next the vendor’s name listed another spreadsheet- an exported CSV file, in order to pay vendors. Does anyone know how I can do this?
Kind regards.
Jul 06 2022 11:39 PM
Hi @Sdm099
one option would be to load the full email list into Power Query. Copy that list (or make a reference to it) for as many vendors as you need. Then filter these lists by the desired vendor and load the results to the appropriate sheets.