I'm not sure my subject title was clear but basically I've designed a
list where in Column A we have the date a song was introduced, Column
B the title of the song and in Columns C through X the various days,
weeks, months that the song will be rotated through. For example Song
a was introduced on Feb 9th and it will play that week, the second
week, the fourth week and then once per month for three months, then to
a 6 week rotation for 3 months then onwards until we've reached the time
period in the third and fourth years where it gets played only twice a
year. I have set up the calculations for each of these dates and each
of the songs. Here is a small look at the spreadsheet to at least see
what I'm talking about (hopefully).

[image: http://www3.telus.net/public/mcilpuf...nSnapshot.jpg]


However, I now need to pull into another sheet the songs that need to
be played this week and next, as well as last weeks songs. I tried
using the Advanced Filter for this but I must be doing something wrong
because it is just not working. I need to pull the Song title(s) from
Column B and the appropriate date(s) from Column C through X that will
give me a new short list of songs for the upcoming and preceeding week.
Does this make sense? Should I be using something other than advanced
filter? Maybe a Macro? Is the problem because there are so many
columns of dates? Or?

Thank you in advance for any help as I've been going backwards and
forwards trying to get it to do this but I'm not having much luck. 10
years ago I could have done this like the back of my hand and now it's
eluding me.

mcilpuf


--
mcilpuf
------------------------------------------------------------------------
mcilpuf's Profile: http://www.excelforum.com/member.php...o&userid=31678
View this thread: http://www.excelforum.com/showthread...hreadid=513718