Sort on past date

[Wombat]

I have a small spreadsheet that keeps a membership list.
The spreadsheet takes name, joining date and contact
details and calculates and displays next yearly
anniversary in one column and next milestone in the
next. Milestones are at 3, 6 and 9 months and 1, 5, and
10 years.

I have 3 macros set up to sort on next anniversary, next
milestone and joining date.

I want to be able to sort from the day after the previous
meeting date (or at least today's date minus 6 days) as
the group meets once a week and I want to keep current
events at the top of the sort list until after the next
meeting that they fall due. IE The group meets on Fri
but Mary's 9 month milestone falls on the Mon I want it
to stay at the top of sort until at least the Friday
before rolling over to her next milestone.

Thanks
Wombat

 

[Earl Kiosterud]

Wombat,

I'm not sure what you mean by "day after previous meeting date." Are
meeting dates in a column, or a separate table? You talk of members in this
table, but also events. The events might need to be in a separate table.
Read "Database" at www.smokeylake.com\excel\excel_truths.htm for some stuff
that might be helpful.

 

[Guest]

Here is some more info on how the spreadsheet is setup.

Name, DateJoined, {NextBDSort}, {NextMSSort}, Phone,
Address, NextAnniversary, NextMilestone

Above are the columns. Those in brackets are hidden and
just used as sorting references.
The spreadsheet is setup hold the details of 30 members
NextAnniversary is a formula that gives the date of the
next anniversary and how long the person has been a
member.
NextMilestone uses a seperate table for each member and
the Offset, Match and Today functions to return the date
of the next milestone ie 3, 6, 9 months etc and what that
milestone is.

Does this help??

Wombat

I'm not sure what you mean by "day after previous meeting date." Are
meeting dates in a column, or a separate table? You talk of members in this
table, but also events. The events might need to be in a separate table.
Read "Database" at

www.smokeylake.com\excel\excel_truths.htm for some stuff

 

[Earl Kiosterud]

Wombat,

The setup of your worksheet is pretty much the way I imagined from your
description. That's the way it's set up, we might say.

When you say "I want to be able to sort from the day after," I think you're
referring to the Milestones column, and you want to see those whose
milestones have occurred, or will occur since the last meeting. The
upcoming ones, that is. Sorting only puts them in order. Since some will
be before that last meeting, they'll probably have to be hidden. If we sort
on Milestone, then hide those milestones earlier than the last meeting (and
on it -- your six days), will we have what you want?

If so, we probably should not hard-code the 6-day-since-the-last-meeting
date, because a missed or rescheduled meeting would confound the whole
thing. There should be a place to put the last meeting date, for this
process to use, regardless of when it was.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Here is some more info on how the spreadsheet is setup.

Name, DateJoined, {NextBDSort}, {NextMSSort}, Phone,
Address, NextAnniversary, NextMilestone

Above are the columns. Those in brackets are hidden and
just used as sorting references.
The spreadsheet is setup hold the details of 30 members
NextAnniversary is a formula that gives the date of the
next anniversary and how long the person has been a
member.
NextMilestone uses a seperate table for each member and
the Offset, Match and Today functions to return the date
of the next milestone ie 3, 6, 9 months etc and what that
milestone is.

Does this help??

Wombat

I'm not sure what you mean by "day after previous meeting date." Are
meeting dates in a column, or a separate table? You talk of members in this
table, but also events. The events might need to be in a separate table.
Read "Database" at

www.smokeylake.com\excel\excel_truths.htm for some stuff