W
Ward
I'm very new at VBA and am hoping my problem sounds easy to someone!!
1 workbook; 2 tabs---> summary and data.
summary tab has list of claim nums (A) in one col
need to go to data tab and find a matching claim number in col of raw data
(AA)
on data tab, in cell directly to right of the match (AB) i need text data
returned to a new col on summary tab
does this make any sense to anyone?? can anyone please help?
SUMMARY TAB DATA TAB
A B AA AB
1.clm# Color 1.clm# Color
2.000 Yellow 2.222 Red
3.111 Green 3.333 Orange
4.222 Red 4.000 Yellow
5.333 Orange 5.999 Black
6.111 Green
7.909878 Pink
1 workbook; 2 tabs---> summary and data.
summary tab has list of claim nums (A) in one col
need to go to data tab and find a matching claim number in col of raw data
(AA)
on data tab, in cell directly to right of the match (AB) i need text data
returned to a new col on summary tab
does this make any sense to anyone?? can anyone please help?
SUMMARY TAB DATA TAB
A B AA AB
1.clm# Color 1.clm# Color
2.000 Yellow 2.222 Red
3.111 Green 3.333 Orange
4.222 Red 4.000 Yellow
5.333 Orange 5.999 Black
6.111 Green
7.909878 Pink