Hi guys,

I am looking to create a VBA macro that extracts data based on a editable cell (I have done this before years ago but cannot for the life of me remember how I did it)

Sheets:
"PDATA" - Contains the data to extract from (B:I)
"FRONTEND" - The front end the employees would use and enter the details
"TEMPLATE" - The template sheet to copy from

So the idea with it is from the "FRONTEND" sheet you can select field from Range("D7") which is a drop down box.
Then hit submit, once it runs it looks for the value in "FRONTEND" Range("D7") in column E on the "PDATA" sheet and when it finds the first one it copies without selection certain cells from the same row into a new workbook using the "TEMPLATE" sheet as a template… The columns to copy in the same row are: B, C, D, F, G.
Then rinse/repeat until all the data has been extracted.

So to summerise:
Run Macro
Finds the value from the "FRONTEND" in "PDATA" E:E
Copies B:D, F:G in the same row to a new workbook using the "TEMPLATE" as the sheets template.
Rinse/Repeat until no more results.

If anyone can help me it would be greatly appreciated.
Ive been pulling my hair out for days :P

Thanks in advance for any assistance
TnT