Same kind of scenario where I need to pull in a picture from a server folder into my spreadsheet from an ID number for a person.
Sheet 1 has my raw data...first name (A2), last name (B2), id number (C2), location code (D2), birth date (E2) in a list format down to row 130
Sheet 2 I am trying to format the data to have the picture with the sheet 1 data listed underneath and the picture pulled in using the id number.
Is there an easy way to repeat the macro code to pull this picture in since I'm not just going in sequential order down in rows.
I have no idea if I'm making any sense or not.
I want to pull in the picture based off of A3 data (which is also the file name of the picture) and have the picture placed in A1. And I want to repeat this process for D1, G1, J1, A6, D6, G6, J6...so on and so forth down my page to J176. Do I need a separate script for each picture I want to pull in or is there an easier way?