I'm working on excel which has assembly numbers. I've assembly names and corresponding numbers by side for each assembling we do. I'm looking to create a dealer sheet, who by clicking on the assembly number, stores the corresponding assembly number and name in another sheet, collect all numbers in a similar way and save/submit.
I could figure out to save entered data to store. But need help to save data which is already there and saves by a click.
Any level of inputs are really appreciated...!!