Copying a range based on criteria
 

Hi everyone, hope someone can help:

I have a worksheet called "data" which contains a range of values, ro
A contains the header values and the data within the sheet has th
defined name "database".

I have another sheet called "Report", which contains in cell B1 a dro
down list of all the known dates in the "data". cell B2 contains a dro
down list of all the known "Names" in the "data" worksheet.

What I would like to do on the sheet called "report" is bring acros
all the data which matches the values selected in cell B1 and B2.

Let me know if that isnt explained well.
Thanks for your time
Love Amy x

--
AmyTaylo
-----------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...fo&userid=2097
View this thread: http://www.excelforum.com/showthread.php?threadid=56019

Copying a range based on criteria
 

Start on sheet Data
Turn on the macro recorder and then step through the Data=Filter=Advanced
Filter. Select the database, select copy to another location. Select the
revised criteria range (as shown below). Select the new location on Report.
Execute the query. Turn off the macro recorder and look at the recorded
code.

You will need to change your layout on sheet2 like

B1: Date (change to the header name of the date column)
C1: Name (change to the header name of the name column)
B2: Dropdown with Dates
C2: Dropdown with Names

Make your criteria range Report!B1:C2

--
Regards,
Tom Ogilvy


"AmyTaylor" wrote:


Hi everyone, hope someone can help:

I have a worksheet called "data" which contains a range of values, row
A contains the header values and the data within the sheet has the
defined name "database".

I have another sheet called "Report", which contains in cell B1 a drop
down list of all the known dates in the "data". cell B2 contains a drop
down list of all the known "Names" in the "data" worksheet.

What I would like to do on the sheet called "report" is bring across
all the data which matches the values selected in cell B1 and B2.

Let me know if that isnt explained well.
Thanks for your time
Love Amy xx


--
AmyTaylor
------------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970
View this thread: http://www.excelforum.com/showthread...hreadid=560190