I would like to copy selected records from one sheet to another

**royUK** · 10-31-2008, 09:36 AM

You don't need VBA. Just Data validation & VLOOKUP. See

http://www.excel-it.com/data_validation.htm
http://www.excel-it.com/excel_functions.htm

I have added two Dynamic named Ranges to the data sheet

item_ids provides the drop down list to pick from in Column A of price offers
data is the actual price list referred to in the VLOOKUP

**mechant** · 10-31-2008, 10:08 AM

Well, that is a great Idea... and after I saw your example, I would like to create a dropdown list in the price offer sheet ... so I could select a product name from the dropdown menu and it would automatically fill in the weight and the price by the VLOOKUP function. But I cannot use the validation ( list) to create a dropdown menu, because it says that I cannot use data for validation from another worksheet. How can I then make a dropdown menu ( name in the price offers table) and it will take the data from the name column in the pricelist table)? Is it possible to create a search filter in the dropdown menu? so that the user types a first few leters and the dropdown will narrow down to the names containing only those first few letters?

**mechant** · 10-31-2008, 10:32 AM

Well, I have managed to create the dropdown menu by using the dynamic range name as a source , but when I create the Vlookup and use the dropdown menu as the lookup value, then I select the table on the pricelist as my table array, select the weight column as the column_index number and add false for the exact match . I get the N/A value as the result. I send what I have done in the attachment . also I would like to remove name from the dropdown, but It does not accept when I define the range as $B2:$B ... that means that I want as a range the whole B column except from B1, because I do not know how many records I will have in the pricelist