Macro to Compute Info if Cell is Red

[ISUCyclones]

I have a spreadsheet (Attached) that tracks a schedule of when certain games are being played each day. I am wondering if there is a way that the open spots (highlighted in Red) could be computed into a sheet that will show me the day and time of all the open "red" cells. So for example in that attached file, the Sunday open times would compute into: Sunday, Jan. 22: 8pm, 10pm, 11pm and so forth.
Any help or direction would be appreciated.
Thanks

Nathan

[stnkynts]

You will need to create a second sheet. Leave it blank but title it Schedule. I am assuming that the format you provided will be the same all the time. If not this will fail on others.

Please Login or Register  to view this content.

[ISUCyclones]

Thank you for your help, this is exactly what I need.
I generally have between 3-8 sheets that I would need to compute. How difficult would it be to adjust the code to allow multiple sheets to compile on the "schedule" sheet?
Thanks again!

[stnkynts]

This should do it for you. With this new code you won't need to create a "Schedule" Sheet. It will do it for you.

Please Login or Register  to view this content.

[ISUCyclones]

Perfect. Works exactly like I need it to! I greatly appreciate your help!

[ISUCyclones]

I have a spreadsheet (Attached - SampleSheet1) that tracks a schedule of when certain games are being played each day. The open spots (highlighted in Red) are computed into a sheet that will show me the day and time of all the open "red" cells. So for example in that attached file, the Sunday open times would compute into: Sunday, Jan. 22: 8pm, 10pm, 11pm and so forth.

I have changed the format of my spreadsheet (also attached - SampelSheet2) and need help updating the code to allow it to continue to do what it does. Can anyone take a quick look and help me make the appropriate adjustments to the code?
Thanks

Nathan