vlookup formula using vba

[sudbhavani]

Dear friends
I need help with vlookup formula using vba. what I required automatically copy the formula in next row
For example: =VLOOKUP(C2,'C:\Users\username\Desktop\New folder (2)\New folder (2)\[New Microsoft Excel Worksheet.xlsx]Sheet1'!$A:$B,2,0),this is the formula in D2. Now I want Get automatically in next row using VBA

[Sunny18pc]

HI Check this out!!

Please Login or Register  to view this content.

[sudbhavani]

HI Check this out!!

Please Login or Register  to view this content.

Dear Sunny18pc


its working in next cell but i need next row. for example D2 to D3......

[Sunny18pc]

Then change the value of offset from 0,1 to 1,0.

#ActiveCell.Offset(1, 0).Select

Thanks

[sudbhavani]

Then change the value of offset from 0,1 to 1,0.

#ActiveCell.Offset(1, 0).Select

Thanks

Ok sunny thanks but this type i have 5 worksheet how i i apply the vba

[sudbhavani]

Dear sunny

in my excel this format i update the name automatically formula will get in branch this type i have 5 sheet in one workbook


S.No Date Name Branch CLIENT NAME PAX NAME CLIENT
1 28-01-2020 Durai Chennai BR1 BR1 BR1 BR1
2 28-01-2020 Sridhar Chennai BR1 BR1 BR1 BR1

[Sunny18pc]

Dear, I doubt i can assist you better if you can ask your complete query at once as VBA is Ocean.

If you are stuck at some point then we can help you but if you are not sure whats the logic of implementation, would appreciate to discuss here.

*For your last question: You can either paste the same code in each file or can run a loop to call each work book paste the same formula.

[Sunny18pc]

Dear sunny

in my excel this format i update the name automatically formula will get in branch this type i have 5 sheet in one workbook


S.No Date Name Branch CLIENT NAME PAX NAME CLIENT
1 28-01-2020 Durai Chennai BR1 BR1 BR1 BR1
2 28-01-2020 Sridhar Chennai BR1 BR1 BR1 BR1

Worksheets and sheets are 2 different things, as I doubted you are not clear with your logic, add the sample file and let us know your complete requirement.