macro to copy row based on drop down list

[jimb0693]

im trying to get a row to copy from shreet 2 to sheet 1 based on a drop down list on sheet 1 that links to the list of names on sheet 2 but im stuck. i can get the dropdown list up but cant get it to link correctly to the list of names on sheet 2

i've attached a copy so anyone can look

can any one help me

[davesexcel]

Hi,
Try placing this formula into,
cell F10

=VLOOKUP($D$10,main!D7:F13,3)
And see what happens when you change the name

You could name the range of the staff members then use that named range as the source in data validation

here is a site to learn data validation, and search around the site to find out more on Vlookup

http://www.contextures.com/xlDataVal01.html

[VBA Noob]

Here's some crude code.

You need to first

1) Name D10 on sheet Front End as Filter_Name and
2) Name A5:AB13 on sheet main as Database

Instructions on naming ranges can be found on Link

http://www.contextures.com/xlNames01.html

Please Login or Register  to view this content.