Hi,

Is it possible to create a vba code to look for each of the values in column A of an open workbook (say, workbook X), search for that value anywhere in a different workbook (with multiple worksheets, call it workbook Y), then copy the value in column G of the row that contains the found value in workbook Y, and paste it back on to column D of workbook X?

If the value in workbook X is not found anywhere in workbook Y, then it should leave column D of workbook X blank, so I can repeat the process for these blank cells by searching in a different workbook (workbook Z, etc..). The "already-populated" cells should remain untouched.

Now, the troublesome task is that, once workbook X is physically closed, when it opens again, it should be able to "update" the values by searching through each of the values all over again (not just the blank cells like the above scenario), as workbooks Y, Z, etc get updated on a daily basis...

I know this is a LOT to ask for, but any help is greatly appreciated! T.T
Thank you for any help!