macro for vlookup then copy and paste to another workbook

January 19, 2016 at 15:48:43
Specs: Windows 7
Workbook1 sheet1 has data. column A is dates from a1 to a1554. Workbook2 sheet1 is destination. dates are in g14 to g51. I want a macro to copy cells from column b in workbook1 to column b in workbook2 according to matching dates in column A. I cannot use vlookup formula on destination workbook2 it is protected. it has to be a macro run from workbook1 sheet1

See More: macro for vlookup then copy and paste to another workbook

Report •

#1
January 19, 2016 at 16:15:57
First, it is customary (and polite) to ask for help as opposed to just telling us what you want and what the solution has to be.

Second, if you (as a user) can't use a VLOOKUP in workbook 2 due to its protection status, then a macro can't write data into the workbook either. If a macro could override protection so easily, then workbook/worksheet protection wouldn't be worth anything.

Yes, a macro can unprotect a workbook, even it if has a password, but that password has to written into the code.

If the workbook isn't password protected, then your statement "I cannot use vlookup formula on destination workbook2 it is protected" doesn't make sense.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 19, 2016 at 16:41:51
I don't want to explain the reason why an how I cant use vlookup formula on workbook2, it is just not allowed by the end user. Saying its protected is just my way of saying "its not allowed" it has to be a macro from workbook1. sorry for the confusion.

Report •
Related Solutions


Ask Question