I have two data sets (lets call them SOURCE & DESTINATION). The SOURCE Excel file has 1 column with 20 cells/rows and the DESTINATION data table has >100 row and multiple rows/columns. I am trying to run a for each loop through DESTINATION file and where ever there is a blank cell in COLUMN XX, input the value from SOURCE file, then move down to the next row in the SOURCE table COLUMN A until it reaches the last row, then circle back to the first row and loop through that until all rows in DESTINATION COLUMN XX have been reviewed.
See attached image for basic view of what I am trying to do. Copy & Paste SOURCE COLUMN A values into DESTINATION COLUMN XX
id2 would get yyy
id4 would get zzz
id5 would get yyy
next blank COLUMN XX would get zzz
and repeat until DESTINATION has gone through all rows
Any suggestions on how to proceed?