Button Macro to transfer data.

Hi, I have two worksheets in my workbook. The user is supposed to enter a value into Cells on the A column and then click a button to add them to a row.

I sure could use some help with the VBA macro for the button to function.

The user enters a new part number to add to the equipment like this on sheet1 in column B

UNIT #2 (Title, static, not entered by user)

*New Part Number*


They then Click the button

and the button moves this data to sheet2 on one row like this. Preferable to the end of the row after the last data entry based on the title.
This information needs to find the correct title and add the part number to the end of the row


A1 B1 C1 D1 E1 F1

UNIT #(Static Title not added by button) 3847JHY33 | 37NH | 987JKM | P7-05 | TG474
UNIT #1(Static Title not added by button) 234 | 37NH | 344FRJKM | P7-09 | 342GT
UNIT #2(Static Title not added by button) 23434 | 46NH | 400JKM | P7-07 | *New Part Number*
UNIT #3(Static Title not added by button) 4343 | 47NH | 434JKT | P7-01 | 44FR4F
UNIT #4(Static Title not added by button) 3847JHY35 | 51NH | 334JKM | P7-35 | 234BDB

I have tried to find a solution and have come up blank.

Thanks!

http://www.excelforum.com/attachment...1&d=1462295112

this is a very simplified version of the file. It is too big and complex to give you all. But I can make this work with my file.

Thanks for any help!

SWEET! That works!!! thank you so much!!!