Struggling with VLOOKUP OR IF statement

[MikeJHHT]

I apologize if this sounds confusing in advance,

Column K contains a concatenate for the warehouse software i use for entering sales orders based off the first truck number.
Column R adds additional sales orders with the same truck number so it wont repeat step 1 which is K.

When i copy the sales order information into excel, it will fill in column B and D.

For every same customer, the truck numbers will be the same (unfortunately my example shows D11 should be with truck # 755 but customer service entered the name differently...

Is it possible if there is only truck number 750, column U will show (k2), but if there are more 750's it will add each additional cell from R

for example U2, should be =K2&R2&R3&R4&R5&R6&R7&R8&R9 (which is the start of the concatenate(K2) followed by the additions in (R)

also, im entering the truck numbers manually based off the similar customer names, is there a statement that would automate this?

Ive been struggling to search using the right terminology to get exactly what im looking for.
Thankyou as always for your time.

 

[MikeJHHT]

Ok I have a follow up question, and before i start im more than happy to edit the macro myself with some guidance but get it its easier to do rather than explain.

Truck numbers will be different for each TAB.
meaning
WILL CALL tab column A starts at 750
MTO tab column A starts at 100
FIRESIDE tab, column A starts at 800
Is this possible to do with the same macro depending on what tab im in?

magic test 2 no end.xlsm

Shared with Dropbox

www.dropbox.com

 

[mumps]

Will there always be only those three sheets? Also, what happens if the WILL CALL sheet has more than 50 trucks? This would cause a duplication of some truck numbers with the FIRESIDE sheet.

 

[mumps]

Forgot to mention: please attach a copy of your file that contains some data to make it easier for testing.

 

[MikeJHHT]

will calls will never exceed 799, i will work on getting you a sheet with expected data