Hello All!

Having trouble with the proper syntax in VBA.

I have 2 sheets, PR and DA. I have already written a macro to import data into those sheets from two separate workbooks, format, etc, works perfectly.

I need vlookup to reference column B in PR to column B in DA and put the data from Column C in DA into column E in PR. The number of rows in column B in both sheets will vary depending on the other two workbooks, anywhere between 80 to 100 rows.

Any advice on how to do this?

Thanks!
CJ