Programming Question

VBA Test Guide

Use case: A team has collected some vendor profiles and need to import all the data into an internal system. To do so, they need to prepare the data by transforming them into the required formats that the system can consume and then conduct the bulk upload.

Requirement:

Develop VBA macro to fulfill below needs and provide How-to-use instruction

1) Extract vendor info, factory info, vendor contact info from each source file (File name: Company Profile*.xlsx) and save them in corresponding sheets in destination file (File Name: Output Sheet Templates.xls)

2) Must consolidate all source files into ONE destination file. No limitation to the source file count.