Extracting Data from Workbook to Workbook

[hammer2]

Hi Folks
I have done these before but cannot get this one to run for me.

Want to pull values from consecutive Cols in one Workbook to another.

Set Cols to work from with Cols in between that I do not want to reference if possible.

Two Workbooks attached for perusal

Cheers
hammer

[Vikas_Gautam]

Place both files together anywhere in your computer.
and press the button the Book1 file after assigning following macro to it.

Here is the code:-

Please Login or Register  to view this content.

[hammer2]

That looks terrific Vikas!
Thank you for your time and effort
Cheers
hammer