I am trying to work out a solution to this problem...
I have a master data sheet of sobriety dates
<tbody>
</tbody>
The columns continue out to calculate the days on a 250 day interval
I want to be able to create a report table. In this table I want to be able to enter June or 6 and return all of the events that occur in June of current year.
<tbody>
</tbody>
I have gotten as far as knowing I would need something like =indirect("('"&B1&"')!active(range)") at least I think.
But I have over 800+ and growing in the active sheet in both directions new members and events.
I have a master data sheet of sobriety dates
Sobriety Date | Name | 100 days | 500 days | 750 days |
02/06/14 | Sue Morgan | 05/16/14 | 06/20/15 | 02/25/16 |
03/23/15 | John Smith | 06/30/15 | 08/03/16 | 04/07/17 |
06/19/13 | Dave Lee | 09/26/13 | 10/24/14 | 07/15/15 |
<tbody>
</tbody>
The columns continue out to calculate the days on a 250 day interval
I want to be able to create a report table. In this table I want to be able to enter June or 6 and return all of the events that occur in June of current year.
Month | June | |
Name | Date | Event |
John Smith | 06/30/15 | 100 days |
Sue Morgan | 06/20/15 | 500 days |
Dave Lee | 06/19/15 | 2 years |
<tbody>
</tbody>
I have gotten as far as knowing I would need something like =indirect("('"&B1&"')!active(range)") at least I think.
But I have over 800+ and growing in the active sheet in both directions new members and events.
Last edited: