Suggestions needed on filling in a form automatically

**carden2** · 03-29-2013, 12:59 PM

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.

**xladept** · 03-29-2013, 02:11 PM

Hi Carden,

If you know the rows they'll be in then you can just copy the defined range and paste that:

Please Login or Register  to view this content.

**Richard Buttrey** · 03-29-2013, 02:42 PM

Hi,

What determines which of the two cells should be used?
Assuming there is some rule then I can't see why you can't encapsulate the rule in an Excel formula which you can place in the appropriate cell in the form.

**carden2** · 03-29-2013, 02:50 PM

There are about 200 rows each row is a specific location and number. There both side by side one is column b the other column c. It just has to do if someone comes in for a form instead of copying the numbers and location since some locations are lengthy. I just wanted to make two buttons. One to each type of form then it would fill location and the number on the form whichever is selected. I am not sure how to make them select the row. I was thinking just highlight the one you want and then click the form and I can copy the highlighted cells and use them in my code.

**Richard Buttrey** · 03-29-2013, 02:56 PM

Hi,

I think you'd better upload the workbook along with some notes which describe what you want to happen, and show the result. On the face of it I can't see why you can't use a formula, but we need to see the request in context.

**carden2** · 03-29-2013, 03:09 PM

I made an example exactly like the spreadsheet I am working with.

I made two buttons for each form. I was thinking now maybe prompt them for the number in Column A and then put Location Code and Custodian # into the Form they open. They want to print the form then clear the form and go back to the spreadsheet.

Hope this helps and thanks a ton for the assistance.