Auto-populating cells from one spreadsheet to another

Occasional Visitor

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.

1 Reply

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.