sn152
Member
Hi All,
I am trying to do a vlookup macro. I have 2 workbooks named "Job" and "Job - Updated" which are stored in C:\Users\Desktop.
Now I want update the column "G" in the workbook "Job" using the data in the column "I" of workbook "Job - Updated". I would like to do this with a vlookup macro.
But one problem is that the range keeps on changing in both workbooks everyday. "Job" workbook will have all the data updated everyday. And it will be updated everyday using the "Job - Updated" workbook.
Please help me to create a macro for this.
Thanks in advance!
I am trying to do a vlookup macro. I have 2 workbooks named "Job" and "Job - Updated" which are stored in C:\Users\Desktop.
Now I want update the column "G" in the workbook "Job" using the data in the column "I" of workbook "Job - Updated". I would like to do this with a vlookup macro.
But one problem is that the range keeps on changing in both workbooks everyday. "Job" workbook will have all the data updated everyday. And it will be updated everyday using the "Job - Updated" workbook.
Please help me to create a macro for this.
Thanks in advance!