Userform to retreive data from one table and post data to another

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

The easiest way to get a to the point answer is to post an example file with some data in it, including the userforms you created.

Originally Posted by bakerman2

The easiest way to get a to the point answer is to post an example file with some data in it, including the userforms you created.

No problem, I will upload my file as soon as I can. Thanks.