vlookup with VBA
 

I have two worksheets

Say sheet1 and sheet2
sheet1 looks like this
A B C D E F G H and so on
22_1 12 14 55 56--------
22_5 13 34 45 34------
34_3 12 56 67 65---
and so on


sheet2
A B C D E f G H-------
22_1 te
34_3 we
22_5 ty


Write now I am using Vlookup function in ColumnA of both sheets to get the
data in sheet2
in the cells C D and so on. But since my data is very huge. Slowly and
slowly it is becoming
more complicated.
Is there a way out where I can match columnA in both sheets and if it
matches, the values
in sheet1 starting from b2,c2,d2(selecting a range which will be same for
all matches).
select that range and copy it corresponding to the match found value should
be copied
from C1 in sheet2(C1,D1,E1....).The data in sheet2 will look somewhat
similar to this

sheet2
A B C D E f G H-------
22_1 te 12 14 55 56 ----
34_3 we 12 56 67 65
22_5 ty 13 34 45 34

This I have done using vlookup but its consuming lot of time and manual
work. Just looking for a way to automate it

any help would be greatly appreciated

Thanx in advance

Regards


Kittie