VB Comparing data in one sheet to another and copying cells

March 26, 2013 at 03:11:53
Specs: Windows 7
I am new to VB and have searched for existing answers to this problem but no macros or VLOOKUP commands seem to work.

I want to compare date/time in "FINO" sheet column A (in ddmmyy hhmm format) to date/time in "RawScatt" sheet column E (same cell format). Where they match I would like to copy the cells in "RawScatt" columns J and K (numbers) to sheet "FINO" columns I and J.

Thanks for your help!


See More: VB Comparing data in one sheet to another and copying cells

Report •

#1
March 26, 2013 at 10:43:18
I'm not sure what problem you are having. I used a basic VLOOKUP and didn't have any problems.

With my data starting in Row 1 of both sheets, I used this formula in FINO!I1 and dragged it down to retrieve the data from RawScatt!Column J:

=VLOOKUP($A1,RawScatt!$E$1:$K$18,6,0)

I used this in FINO!J1 to retrieve the data from RawScatt!Column K:

=VLOOKUP($A1,RawScatt!$E$1:$K$18,7,0)

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


Report •
Related Solutions


Ask Question