I have two forms when the user clicks the button I need to pull two cell values and put them into the form. The cell values are always in the same column but not in the same row. Anyone have some advice and reference for how I can accomplish this in Excel 2010?

My idea was two make two buttons at the top. Have them highlight the cell values they wanna copy since there next to each other and just copy active cell and paste into the form on worksheet. I can have form cells cleared on each open? Does this seem the best method???

Thanks.