Extract data from rows in one table but place it into columns into another table

[bo_danseuer]

My data (dates, times, names, and guest/student numbers) are in one table (A9:e17). I need to create a second table as a sort of sign up sheet for each date/time. The tables need to be dynamic so that each time the admin person adds a date/time (in one table) the students can sign up accordingly (in the other one).

I need to extract the DATES for the month listed (from A10:A17) into columns I, J, K, L, etc. Then I need to LOOKUP the TIMES and the BOAT names that correspond to that date above (i've just typed them manually). And finally I need to LOOKUP the number of STUDENTS needed for each slot (in this case row 20 / col I, J, K, etc) and subtract the number of "x" that the students will make on the table when signing up.

I've tried 4 times to post with xl2bb but my system keeps crashing. Unable to paste to forum. Perhaps the image and the info above are enough?

 

[Leo Skywalker]

It's been a while since this was posted, maybe the answer is not needed anymore for the OP.

in I4:

=INDEX($A$10:$C$50,COLUMN(A10),ROW(A10)-ROW($A$9))

in I20:

=INDEX($E$10:$E$49,COLUMNS($I$19:I19))-I19

 

[bo_danseuer]

It's been a while since this was posted, maybe the answer is not needed anymore for the OP.

in I4:

=INDEX($A$10:$C$50,COLUMN(A10),ROW(A10)-ROW($A$9))

in I20:

=INDEX($E$10:$E$49,COLUMNS($I$19:I19))-I19

Hey Leo,
Thanks for responding. Yes, I’m still needing help. It’s tedious manually. I look at your reply and get back to you. It may take me a bit as I’m away from my desk at the moment.

 

[Leo Skywalker]

Hey Leo,
Thanks for responding. Yes, I’m still needing help. It’s tedious manually. I look at your reply and get back to you. It may take me a bit as I’m away from my desk at the moment.

Did it work?