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).
\1
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
Bookmarks