below is sheet No1 & 2:
Sheet 2:
i would like to Automate excel so that it takes the inspection number from Sheet 1 (yellow cells) and put it in the appropriate location in sheet 2 (Red Cells).
For example: 1st yellow cell in sheet 1 is "Floor paint" in the "Entrance". now it...