Excel based schedule

C

Computer User

I have a multipage spreadsheet that all works except for one part.

Let me show you what my sheet says and then I will explain what in need from
it.
On Page 1:
Start Date
End Date

Sunday Monday Tuesday Wednesday Thursday Friday
Saturday
(T/F check box for each, linked to the cell beneath each day)

And on another page I am trying to work with the selected days.

On Page 2:
Cell "A1" list the Date of the first day checked, in cell "B1" list the day
of the first day checked, in cell "A2" list the Date of the second day
checked, in cell "B2" list the day of the first day checked, and so on.
Then for the next week do the same, until end date is reached.

Basically it is trying to create and show a schedule of days based upon the
selected boxes and a start and end date.

I am tweaking an existing spreadsheet so I have certain things that I can
not change on it.

Thanks in advance for any help.
 
F

Frank Kabel

Hi
enter the following array formula in A1 on your second sheet (entered
with CTRL+SHIFT+ENTER)
Assumption: sheet 1 contains in row 3 your data values (just formated
as 'DDDD') and row 4 contains the linked cells for your checkbox
(either TRUE/FALSE)

=INDEX('sheet1'!$A$3:$H$3,1,SMALL(IF('sheet1'!$A$4:$H$4,COLUMN('sheet1'
!$A$4:$H$4)),COLUMN(A:A)))
and copy to the right
 
Top