Macro to copy and paste variable depending on cell content

Hi all,

I'm quite new to macros and have only really used the recorder.

I've created a workbook which has a dropdown list of names. The is also various data related to each name that will be imported into a second sheet each day.

I was hoping to use the macro recorder to make a macro which would copy the name that is selected in the drop down box, automatically filter on this name in the sheet with the imported data, and then copy and paste the data back into the front sheet.

The issue I have is that when I run the macro, it always filters on the name in the dropdown list when the macro was recorded.

The code is below. I can see that in Criteria1 it is equal to the name which was selected when recorded; is there any way to make this a variable, depending on what has been copied?

Please Login or Register  to view this content.

Thanks for your help. I have also attached an example workbook.Example.xlsm


Moderator Edit:

Welcome to the forum, ejh88.

Please notice that [CODE] tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

Give this a try. Put into the Front Sheet worksheet Module

Please Login or Register  to view this content.