Hi all,
I really appreciate the help you all provide. Cheers.

So my issue is I have a series of files with a column of data which I need to copy then paste into a master destination file based on a value in another column of the destination file.
That is, destination file column B has ID numbers (e.g., 113, 245, etc.) in many rows (180 per ID #) and I have a column A with 180 values in a separate file (one 'target' file for almost every ID) and I would like a bit of code or simple way to get the column A of data from each specific ID's target file into column H in the destination file. So the code could do something like look for the first instance of 113 in column B in destination file and paste the 180 values from target file (there are always 180 rows both in target file and 180 rows in destination file for all matching ID's).

Thanks in advance!