Automatically checkling ranges and selecting contents based on a value

[AmyTaylor]

hi all, can anyone help please?
i attach a zipped excel file which contains the following sheets:

parameters - allows the user to select a given "area" to report on
report - this is where the output would be presented
area a to area d - sheets containing the invidual data collected by each area.

what i am looking for, if possible, is a way, via vba code, to look at the data in the 4 area sheets and, when the Reviewer has been selected in the drop down on the "parameters" sheet cell D3. copy the relevant data to the report sheet.
In my example, you can see that it has returned 6 rows from area A and 1 row from area C.

Any help, gratefully received.
Thanks

[MickG]

Mr Excell _Amy Taylor_Automatically checkling ranges and selecting contents based on a value
----------------------
Hi, Amy
Try this, I've assumed the linked cell is "parameters"- range("D3").
This seems to work so far!

Please Login or Register  to view this content.

Regards Mick

[AmyTaylor]

mick, this is perfect.

thanks soooo much for your help.
amy x