Roger,
Great feature from Debra's site. This would be great if when I change the
filter criteria and that it would automatically update the filtered data.
Any other suggestions?
Dai
"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Dai
What you need is Advanced Filter.
Rather than me trying to describe the process, there is an excellent
example, along with some downloadable files on Debra Dalgleish's site (and
a video)
http://www.contextures.com/xladvfilter01.html#ExtractWs
Take a look there, and post back if you get stuck.
--
Regards
Roger Govier
"DHN" wrote in message
...
Hi Roger,
If you could help me with one formula I can mimic the othe formula.
Filter 1 = VP1 (say in cell A1 of the blank worksheet) will be setup as
Data Validation List
Filter 2 = Date (say in cell A2 of the blank worksheet) will be setup as
Data Validation List
On a blank worksheet1 (a tab within the workbook where the data is) if I
select VP1 and Date (say 12/31/2009) then it would "lookup" and populate
in column A (starting at row 5) a list of "Project ID" associated with
VP1 (from worksheet2). It would also populate in column B dollar amount
for the "Project ID" associated with VP1 for 12/31/2009 (from
worksheet2). It would also polulate in column C dollar amount for the
"Project ID" associated with VP1 for 12/31/2009 (from worksheet3).
Unfortunately I can not combine worksheet2 and worksheet3. If I could
combine I would just use Pivot Table to get the same result.
Naturally I would have to put formula down column A, B, and C so that
when I select Filter 1 and Filter 2 it would populate the data in column
A, B, and C.
Is this detail enough?
Dai
"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Dai
Not enough information.
What does your data look like?
What are you trying to achieve?
--
Regards
Roger Govier
"DHN" wrote in message
...
Hello MVPs,
I need help with a formula that would be able to do the same as a
filter in a pivot table. I have two filters that I would like to be
able to do. The reason why I can not use a pivot table is because I
have data on multiple tabs within the workbook.
If I am not clear with the issue please let me know. Thanks.
Dai
__________ Information from ESET Smart Security, version of virus
signature database 4741 (20100104) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus
signature database 4741 (20100104) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus
signature database 4743 (20100104) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus
signature database 4743 (20100104) __________
The message was checked by ESET Smart Security.
http://www.eset.com