conditional dynamic filtering..

[Graham]

Hi all helpers ..

I posted a message late last week regarding filtering
data however I am still a little ( a lot ) confused .!!!

I Have a list with contact details columns a through to
g , some with data , some blank.

I wish to show on a seperate page details from column A
depending on the data in column G.

I was pointed towards Contextures.com which is a mine of
information however I am still a little lost as the list
would be dynamic.

For example
Page 1

Name last contact Method Details Next Contact
Dave 1/6 phone arrange Meet 15/6
Mike 1/5 phone left message 21/6
Jane 1/6 phone left message 22/6


On Page 2 I would like to show

This Week (21/6 - 27/6)

Mike 21/6
Jane 22/6


This list however would need to be dynamic as the next
contact date be constantly updated.

Any help is much appreciated...

Thanks

 

[Debra Dalgleish]

To filter for items in the next seven days, set up a criteria with four
cells:

Start End
=G2>=TODAY() =G2<=TODAY()+6

where column G contains the date, and row 2 is the first row of data.

Activate sheet 2 and apply the Advanced Filter.
To automate this, you could record a macro as the apply the filter, then
run the macro when the workbook is opened.