Ok. I thought part of the script was to compare the value of a cell to another data source and then do some action to it.

Say I have another excel file to compare it to. In column A there is a list of names in A1, A2, etc and in column B there is a folder path for each value in column A. Can I compare the value from the first excel file to the second excel files column A and then move the file to the folder path located in column two of the second file?

I hope that makes sense.

thanks.