conditional dynamic filtering..

  • Thread starter Thread starter Graham
  • Start date Start date
G

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
 
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.
 
Back
Top