Good Morning,

First post on here as I am new to excel VBA and have spent hours trawling the web for help on this to no avail!

I have a workbook with two separate sheets, one for vehicle purchases and one for vehicle sales.

The vehicle purchases sheet has a table with my vehicle purchase information and I have managed to build a userform to add new purchases to it.

I now need a userform on the vehicle sales sheet which allows the user to enter the stock number of the vehicle which has sold and hit a command button to search the purchases table and pass the relevant vehicle information to the userform. The form then has the textboxes for the user to enter the sales details associated with that vehicle (customer name, address etc). Then a final command button to post all of the data into the sales table.

I don't expect someone to write the entire code for me I just need a simplified version with all of the elements in place so I can expand from there.

Any help would be greatly appreciated.

Mark