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 s...
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.