Some part(red marked) in vba code not working

Dear Mambers,

I have below VBA Code which run well but red marked code is not working means it is not entering the data in to "Dispatch" sheet

Please Login or Register  to view this content.

Regards,
Nandkumar S.

Dear Members,

for more clarification pls find attached file. In this File I search for Thc No. details of thc displays in user form. But code for Entering the data in to Dispatch sheet is not working. pls look in to

thanks for replying,

I have to insert data to Dispatch sheets which is found from data sheets, I am newbie in VBA. Can you please correct all code.

Dear sir,

I tried this but not working. Kindly see attached file.

Regards,
Nandkumar S.

I don't know why but it's not stamping the value in Dispatch Sheet

The code works for me as long as a valid THC number is entered and a match for it found in column B on 'data'.

Had to change 2 lines of code in the uploaded workbook to match the code in your first post.

In the workbook you had Sheets("Dispatch"). in front of both these lines which would cause an error and isn't needed - LastRow already refers to 'Dispatch'.

Please Login or Register  to view this content.

Sorry Boss,

I am very very sorry to confusing to you. There was little mistake from my side. I have corrected it and now code is working fine.

Thanks a lot.

Regards,
Nandkumar S.