this is an excellent video. It is almost exactly what i need. workbook 1 I have a user form that is writing a serial number to col A, then has a Combo box with drop down selection of options which are a list of the headers from workbook 2 (columns b thru J). and then col 3 is a date of completion entry. workbook 2 i would like to match workbook1 serial number to the same serial number in col A workbook 2 then match the result of col B workbook 1 to the headers of workbook 2 Col B - J and write the date of completion in the row of the serial number they entered.
@@NaveenTamtaIamExcelVBA I have source data workbook - job ID in column A Column B has inputs that match my headers exactly on the master form. Column C has Dates that the task was completed. I wan to match job ID and Header to the master sheet headers and job ID (job ID Column A and headers all on ROW 1 and write Column C date in corresponding col/row.
Excellent video Naveen.
If your source data have more than 1 sheet, how do you handle vlookup in exactly sheet?
Thank in advance!
Too good bro... excellent video.. keep it up.👍👍
Thank you!!
Very useful video ..Thanks sir
Thank you!!
Thank you, this video helped me a lot ❣️
Thanks.. hope you have subscribed
this is an excellent video. It is almost exactly what i need.
workbook 1
I have a user form that is writing a serial number to col A, then has a Combo box with drop down selection of options which are a list of the headers from workbook 2 (columns b thru J). and then col 3 is a date of completion entry.
workbook 2
i would like to match workbook1 serial number to the same serial number in col A workbook 2
then match the result of col B workbook 1 to the headers of workbook 2 Col B - J and write the date of completion in the row of the serial number they entered.
VLook match is not working here?
@@NaveenTamtaIamExcelVBA I have source data workbook - job ID in column A Column B has inputs that match my headers exactly on the master form. Column C has Dates that the task was completed. I wan to match job ID and Header to the master sheet headers and job ID (job ID Column A and headers all on ROW 1 and write Column C date in corresponding col/row.
Bro i need the vlookup in vba, as i have need same source data