Filter for date range across multiple columns and multiple worksheets

Hello there,

First post here, so apologies if I'm out of line on anything.

I have a series of worksheets that I'd like to be able to filter and display on a summary worksheet any upcoming dates that are contained in 20 columns on each worksheet.

The date range for the upcoming dates has to be set by someone who has no idea about the inner workings of spreadsheets (pretty much like myself actually!).

It's basically going to be used for managing upcoming patient appointments so that the operator can see which people are going to be coming in at any date range point they set. The sheet works out the rest of the patient appointment dates from the date entered on the "1st Cycle" column.

I've attached a sample (with made up details) of the file for people to have a look at.

Any help would be greatly appreciated!

Thanks in advance.

Hi David,

Apologies for not getting back to you sooner - have been working from home and the broadband went down (again!).

Thanks for the update to the sample sheet that I posted. Unfortunately it wasn't quite what I was looking for.

In total there are going to be around 40 sheets with quite a lot of rows. I'd hoped to be able to move just the rows affected by the date range to a separate summary sheet (or move them all and then delete anything that wasn't affected) so that I could see what the specific patient names were and the expected appointment date, rather than the number of patients due. Highlighting the names would still give the people I work with about 1200 rows to look through.

I think I sold myself slightly short as well, as I'm not averse to a bit of programming.

I'm trying to make it as simple as possible for other people who are completely scared of spreadsheets so that it'll be possible for them to use the thing without having to ask for help each time they use it.

Thanks,

Paul.