clschofield
New Member
- Joined
- May 24, 2015
- Messages
- 1
I have 34 spreadsheets in a workbook that all look alike, except for the data. Days of the week go across, and time goes down. (rows (1-4) headers (days of week and the particular sheets location), Cols (A-B) time( 24hr clock in ha;f hour increments). I froze these areas, so they appear while scrolling through the work area (c5:i52). I gave the workarea (c5:I52) on each sheet a unique name, related to the sheet. These sheets can be broken into groups of 9, 4,15,5.
I have a beginning sheet that contains userforms (WhatToDo). The user can close the workbook from here, Select the sheet to go to to book time, and each data entry sheet has a home button, to take them back to this WhatToDo Sheet when done.
The one other thing I would like on this sheet (well the same thing 4x's), is what is giving me a major headache. I'm not even sure if it's possible after all the research I have done, but I'm putting this out there just in case I'm brain fried and just not seeing it.
I would like to show a quick overview of all the sheets that are available to book.
I wrote the code to select all the blank spaces on a sheet, but when I try to merge them together it's not working. I even tried to just chart them all together,(kind of like a gant chart) but it doesn't like my range selections. So I'm doing something wrong, or just not seeing the error of my ways.
I need to show what times on what days at which location are available in an overview (quick view), so the user knows where to go when they need to book a time slot. Or vise versus, show whats booked and blanks in what is not booked. either by listing the locations available or color coded chart showing whats available. Then using the userform created to go to a specific location. I'm ready to switch to Access, but since I've already done so much work in excel, I want to finish it, if possible.
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
This is just sample data...I have 33 of these. I need to be able to do a quick view of what's available, or what's booked which ever is easier, but enough data so the user knows where to go to book someone who wants a 6 hours, 5 days a week, or 5 hours 3 days a week, or 9 hours 2 days a week etc.....without having to change location. What location has 9 hours available on Sat and Sun.... What location has 4 hours available Mon thru Thur.....
The user needs to see up front what is available where, instead of having to go through each sheet individually. Can it be done? Should I have layed out my sheets differently than what I did? Recommendation on what I should do differently?
I'm all ears.
I have a beginning sheet that contains userforms (WhatToDo). The user can close the workbook from here, Select the sheet to go to to book time, and each data entry sheet has a home button, to take them back to this WhatToDo Sheet when done.
The one other thing I would like on this sheet (well the same thing 4x's), is what is giving me a major headache. I'm not even sure if it's possible after all the research I have done, but I'm putting this out there just in case I'm brain fried and just not seeing it.
I would like to show a quick overview of all the sheets that are available to book.
I wrote the code to select all the blank spaces on a sheet, but when I try to merge them together it's not working. I even tried to just chart them all together,(kind of like a gant chart) but it doesn't like my range selections. So I'm doing something wrong, or just not seeing the error of my ways.
I need to show what times on what days at which location are available in an overview (quick view), so the user knows where to go when they need to book a time slot. Or vise versus, show whats booked and blanks in what is not booked. either by listing the locations available or color coded chart showing whats available. Then using the userform created to go to a specific location. I'm ready to switch to Access, but since I've already done so much work in excel, I want to finish it, if possible.
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
This is just sample data...I have 33 of these. I need to be able to do a quick view of what's available, or what's booked which ever is easier, but enough data so the user knows where to go to book someone who wants a 6 hours, 5 days a week, or 5 hours 3 days a week, or 9 hours 2 days a week etc.....without having to change location. What location has 9 hours available on Sat and Sun.... What location has 4 hours available Mon thru Thur.....
The user needs to see up front what is available where, instead of having to go through each sheet individually. Can it be done? Should I have layed out my sheets differently than what I did? Recommendation on what I should do differently?
I'm all ears.