Forum Discussion
Auto-populating cells from one spreadsheet to another
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.
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.
