sync data between two tabs in same workbook

I have an excel file that has 2 tabs. The first tab is labeled DATA and has 18,000 lines. The second tab is labeled Requests. I have a task of receiving a request for date change for a particulate part number at a particular location. I add that request to the request tab and then investigate if that date change can happen. If it can happen then I update the request tab with the new date for the part number and location. The pain is trying to find the part number and location in the massive amount of data in the DATA tab. Part numbers can be repeated for different locations. For instance in the attached excel file. Line 2 of the reqest is cookies (C2) to be baked at a bakery (E2) until 3/31/2028 (D2). The reply from the bakery is they can agree to a date that is placed in (F2). Sync: If request tab C2 = data tab B2 and reqeust tab E2=data tab J2 then request tab K2= data tab A2 and reqeust tab F2=data tab K2. Any help is greatly apreicated

sync.xlsx

Thank you Tinbendr.

Your form has captured the Requests tab fine. What I would now like it to do is do something like a vlookup with the DATA tab.
Using the Request tab, look at line 1 and grab the contents of cells C and E. Then look at the the Data tab and match the line that has the same item and location as the reqeust tab.
Once you have the correct line identified in the DATA tab, I need to modify that line with the new date received.

Nick

It may be beneficial to be taken to that line and then I can confirm the correct line was selected. Accept the line and have the data auto populate from the request tab?

Ok I like that when I click on the first line it provides in the second box the line number it matched. I don't think the update is working however. When I click on the update I should see the value in Column F of the reqeust tab, update column K of the matching line for the DATA tab.

Ok I think I saw something happen but I don't think its the correct value yet. I should see cell K2 of the DATA tab change to 3/31/2028 or cell F2 of the Requests tab.

I'm not sure if I understand. I've never used UserForm or ListBox before. My VBA is very limited so I'm a little lost. That being said, Im not sure what 10 to 3 (or 5) refers to. Reqeusts Column D and F are typically the same. It is possible that they may differ but I have yet to run into that situation.

Ok, let me review and try and work this out.

Thank you very much, I think that worked out. Let me play with this and the actual files to see If I get the same results. Thank you Nick

Hi Tinbendr, Sorry for the long wait. I had to do some clean up on my actual file. I somehow forgot the A column when creating the file for this site.
I was able to figure out where to make the change in your code so its good now.
I also had a lot of locations that were spelled differently then what the DATA sheet had. It caused a lot of mis matching.
The "bake date received" is getting correctly pouplated, with the data from the request tab of "bake date received".
However, the effective date on the DATA sheet isn't getting poplulated by the "date response was received" in column K of the reqeust tab.

sync ver3.xlsm

Tinbendr,

Yes, that did it. Thank you very much. This has always been a PITA for me especially when you leave it for a while and need to do a catch up.
The approach by showing the matched line before the change is perfect. And yes, your additional view button to call back user form 2 is a good addition. I'm going to mark this as solved.

Thanks
Nick