Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying from one TAB to another based on certain criteria | New Users to Excel | |||
Copying a range based on criteria | Excel Programming | |||
Copying data from one worksheet to another based on criteria | Excel Discussion (Misc queries) | |||
copying cells based on criteria | Excel Worksheet Functions | |||
Copying whole rows based upon one criteria | Excel Discussion (Misc queries) |