Excel Help/Calendar...

[jacksontho]

Hello, I'm TL,

I'm currently doing some brainstorming and possibly need some ideas and/or help. I created a very simple MS Excel spreadsheet that basically is a "Bed List" for a shelter with all kinds of calculations like start date and end date. This "Bed List" was created to be updated manually each day and saved just for that day. Each day a person goes into the "Bed List" and makes sure it's up to date then save it. So, each day if there are any changes will be saved over the previous days.

Now, they asked me if it's possible to now basically track each day? They want to be able to go back to, lets say, last month on this date and see the people that were on the bed list for that day. I have several issues that I have to deal with for this project. The main one is that it has to be very user friendly as the workers I'm dealing with are very basic when it comes to computers and etc. I really don't want to change the software over to Access but I'm thinking that it will be a more viable solution? An idea just formed in my mind as I signed up for this forum just a few minutes ago. The possible idea is that I would like to keep the "bed list" and then add a "calendar like page" as you see for this forum? The calendar will be displayed as a month and then the user can click on the date they want to pull up the "Bed List" for that day. Is this possible in Excel?

The more and more I type this out, it's beginning to sound like I might have to switch to Access because I'm going to be saving data? Any idea on how I might be able to keep this in Excel? There is an Access Database that the shelter uses that I might be able to use? But it's used very limited by the shelter staff. So, switching isn't really out of the realm of possibility? Any suggestions or feedback will be welcome. If you have more questions, please feel free to ask them. Be happy to clarify anything.

Thank you,


TL

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.