Loops and Matching: Combine cells from multiple sheets into one.

Example:

  • Sheet1 contains columns: SKU DATE
  • Sheet2 contains columns: SKU ASIN
  • Sheet3 contains columns: ASIN COST
  • Sheet4 contains columns: SKU DATE COST

Sheet4 will populate data from Sheet1, Sheet2, Sheet3.


Sheet4:

  • populate SKU and DATE column from Sheet1
  • loop through Sheet4 SKU column, match SKU in Sheet2, find corresponding ASIN
  • loop through Sheet3 ASIN column, copy corresponding COST to Sheet4