Vlookup Macro

[sn152]

Column A of JOBS UPDATED to Column C Of JOBSHi Somendra,

Thank you so much. This one is working. But can i ask you one last question.
In the output sheet I want only few columns to be filled.

Could you pls help me with the code to change the order of the columns to be updated.

I want the columns to be updated in the below order.

Column I of JOBS UPDATED file should be updated in Column B of JOBS file. Likewise the below list.

Column A of JOBS UPDATED to Column C Of JOBS
Column B of JOBS UPDATED to Column D Of JOBS
Column C of JOBS UPDATED to Column E Of JOBS
Column D of JOBS UPDATED to Column F Of JOBS
Column E of JOBS UPDATED to Column G Of JOBS
Column F of JOBS UPDATED to Column H Of JOBS
Column G of JOBS UPDATED to Column I Of JOBS
Column H of JOBS UPDATED to Column J Of JOBS
I have attached the modified files. Column A of JOBS file remains constant and will not be updated.
Please help me. Thank in advance!

 

[Somendra Misra]

@sn152

See the file.

Regards,

 

[sn152]

Hi Somendra,

This is working fine. Thank you so much Somendra.

Can we have an option to show a snapshot of how many records were updated as Completed and Deleted and How many new records were added. This code can be in a different module. Please help.

Thanks in advance!

 

[sn152]

Hi Somendra,

Can we have an option to show a snapshot of how many records were updated as Completed and Deleted and How many new records were added. This code can be in a different module. Please help.

Thanks in advance!

 

[Somendra Misra]

Hi SN152,

Sorry I completely missed this thread over the period of time, will update something soon.

Regards,

 

[sn152]

Hi Somendra,

Any update on this?

Thanks!

 

[Somendra Misra]

Hi,

See the file, I had used Sheet2 for the snapshot. Check with your original data.

Regards,