Help with Find and replace code

[Othafa]

Hi, any help appreciated with using VBA to find data in a table based on user input from a Drop Down Box.

I have attached a Sample Workbook

Data is contained in a Table on Sheet 2 (The real world table is bigger but I reckon if I can be shown how to make this work I'll be able to adapt it to the real world Table

I'd like the User to select a Name from a drop down list of names in Sheet 1 Cell "A6"

This should bring up the related data from Sheet2 in the next cells in that row for the user to then edit/change.

When the Update button is pressed the new data is copied back to the orriginal table.

I'm generally a "Record Macro" kind of user, which works in most cases I need it to but VBA seems reluctant to let me use a drop down box to find data elsewhere when I try to record a macro.

Thanks for any help.

Rob