I am creating a spreadsheet that logs dog walks. Initially it was going to be saved monthly. Now I have been asked if it could be made to be selectable so walks can be booked in advance. I have a drop down cell that has the months and this would be used to run what ever code would refresh the sheets with the correct months data.
The workbook consists of 9 sheets, 1 is a database sheet with all the dogs names and owner info. When a dog is added to the list, it is also added to the other sheets tables (VBA) Another is a help sheet. The other sheets are the ones that have the weekly data inputted and are the same for every month, a sheet that displays monthly totals and an invoice sheet. The easy way would be to create\hide the sheets that don't correspond to the current month and have some sort of index sheet to access the others for advanced bookings. If I have the same sheets copied for for each month there will be over 60 sheets and I am sure there is a better way.
I would think that using some sort of database for this would be the best option. As it would only run on one PC, but the simplest would be a self contained sheet. I would be swinging towards SQLite for the DB. I have used it before (in small doses). I want the sheet to be as simple in operation as possible for the people using it, and, if it is copied to another computer for it to work without my involvement. This is were the database option would be a problem unless the driver installation and setup could be done with VBA.
The overall idea is, walks are logged either for the current month or in advance for future dates. The sheets named Week 1, 2 etc are refreshed every time a month is selected with data for that month. I am just looking for some ideas to make the sheet as fast as possible, there will be conditional formatting and as robust as possible. So if someone could point me to so reading material of throw some ideas my way, that would be most helpful.
Here is a link to the file. It contains macros
Thanks
The workbook consists of 9 sheets, 1 is a database sheet with all the dogs names and owner info. When a dog is added to the list, it is also added to the other sheets tables (VBA) Another is a help sheet. The other sheets are the ones that have the weekly data inputted and are the same for every month, a sheet that displays monthly totals and an invoice sheet. The easy way would be to create\hide the sheets that don't correspond to the current month and have some sort of index sheet to access the others for advanced bookings. If I have the same sheets copied for for each month there will be over 60 sheets and I am sure there is a better way.
I would think that using some sort of database for this would be the best option. As it would only run on one PC, but the simplest would be a self contained sheet. I would be swinging towards SQLite for the DB. I have used it before (in small doses). I want the sheet to be as simple in operation as possible for the people using it, and, if it is copied to another computer for it to work without my involvement. This is were the database option would be a problem unless the driver installation and setup could be done with VBA.
The overall idea is, walks are logged either for the current month or in advance for future dates. The sheets named Week 1, 2 etc are refreshed every time a month is selected with data for that month. I am just looking for some ideas to make the sheet as fast as possible, there will be conditional formatting and as robust as possible. So if someone could point me to so reading material of throw some ideas my way, that would be most helpful.
Here is a link to the file. It contains macros
Thanks
