I have a list of data with order numbers, contact names, addresses etc. Each line is a different order and I would like to be able to either:

Click on a command button situated on each row to open and populate a separate blank form with data from that row

Or

Click on a command button which then asks which line of data to use to populate a separate blank form.

Can this be done in Excel?

Any help would be extremely gratefull