Macro to copy and paste selected cell to a table.

[JohnDoh]

Hi guys,

Id be grateful for some help with this one.

I have made a sheet to speed up inputting items from a database to a quotation sheet.

Problem is the search works well the selecting of items not so well.

I'm trying to replace the tick boxes with a button which will copy the contents of the search in the cell on the left into the table and fill from top to bottom.

Also for a bit of added flair I was wondering if its possible to add a pop up box to ask for the quantity of the item required and add that to the cell right of the item selected.

Thanks for looking,

Adam

quote builder.xlsx

[JohnDoh]

If its easier maybe forget the pop up?

[AB33]

Adam,
There is no code on the attached. You have also not explained what are trying to do. Please explain, what and where are you searching for and what do you want to do when search is found?

[JohnDoh]

Sorry if my description was off, you're right of course there is no code.

What I am trying to achieve is to find a suitable macro to copy and paste the text contents of the selected search result into the table on the right, essentially the same result as clicking the tick box but the problem is that unless I keep the box ticked I cant perform another search without wiping out the contents of the table. .

Maybe if I describe the chain of events I'm trying to achieve.

When a word is entered in the search box (This bit works) at the top of the page the top 25 results are displayed In column D, the user then clicks the button labelled "select" (This where the macro is required) the text adjacent to the button is then copied into the table to the right of the search results and a pop up box appears which asks for a numerical quantity to be selected, the result of this is then copied in the quantity column of the table.

I hope this makes more sense and thank you for your reply it is much appreciated.

[JohnDoh]

Does this make sense?

[Leith Ross]

Hello Adam,

The following macro has been added to the attached workbook. The Check Boxes have been removed and all the "Select" buttons call this macro to paste the description into the table.

Module1 Code

Please Login or Register  to view this content.