To anyone who can help me,

First of all thank you for trying to help me. I need help with two userforms.

For first userform name (BATCH1)with one textbox(BATCHIN)and enter button:
1) When i press enter, i would like the first 8 digits of the number to match the column with same digits and entered at its row.
Example : I have more than 100 product codes. I have created 100 columns with different codes like 00302100 (column A), 12001218(Column B) and etc. So when i enter batchnumber i need the first 8 digits of batchnumber will be compared and if it matches, the batch number will be displayed rows under specified column.

Example : when i press enter button for BATCHIN 00302100080210114
12001218002121314

The code will match and display only 2100080210114(first 4 digits removed) under rows of column A and display 1218002121314((first 4 digits removed)under column B.I need the formula updates empty rows in specific column automatically.
I know the code uses "if" and "match" but i cant come up with working solution.
If anyone can generate the code for "if" and "match" i will modify the codes for
the rest of my products.


For second userform name (BATCH2)with 2 textbox (BATCHOUT & PO NUMBER)and enter button:

The idea is same with userform BATCH1. Difference is once i press the enter button the result will be displayed in two different sheets in same file.

Example : when i press enter button for BATCHOUT 00302100080210114
12001218002121314
The code will match and display only 2100080210114(first 4 digits removed) under rows of column D & po number at column C.It will also display 1218002121314((first 4 digits removed)under column F and po number at column E.

Aside from that, at the same time when i enter the enter button for BATCHOUT,
the po number and batch number(first four digits removed) will be entered in new sheet and displays date and time it was entered. For this, the code doesnt have to match with the batch number. I just need to batch number displayed to check later for errors.

I have tried these for almost a month now. I can create the code for a single fuction but i dont know how to combine them. Any help is much appreciated. Thank you.