Anyone fancy helping me........
1) Remove all menu bars on load, re-instate on exit (very simple macro)
2) On load, choose not to display tabs (it's in tools->options, can you do it via macro?)
3) Fix the macro to copy data from the completed claims form onto the "database" sheet - examples provided. I've protected the cells of the sheet, but now the macro doesn't work.
4) Create macro to save the "database" sheet as a CSV (very simple macro)
5) Create a new sheet with simple graph to display spending by department AND by month - multiple line graph etc. (some data moving to a new sheet, sorting then create the graph)
6) Ensure buttons are in place to navigate through the sheets without the tabs (very quick)
I need to get this example completed asap!
Password protected sheets: "a"
http://www.2shared.com/file/4791524/449e4ae8/Book2.html
If anyone can do this in the next hour or two, i'll paypal you £10 to say thanks!
1) Remove all menu bars on load, re-instate on exit (very simple macro)
2) On load, choose not to display tabs (it's in tools->options, can you do it via macro?)
3) Fix the macro to copy data from the completed claims form onto the "database" sheet - examples provided. I've protected the cells of the sheet, but now the macro doesn't work.
4) Create macro to save the "database" sheet as a CSV (very simple macro)
5) Create a new sheet with simple graph to display spending by department AND by month - multiple line graph etc. (some data moving to a new sheet, sorting then create the graph)
6) Ensure buttons are in place to navigate through the sheets without the tabs (very quick)
I need to get this example completed asap!
Password protected sheets: "a"
http://www.2shared.com/file/4791524/449e4ae8/Book2.html
If anyone can do this in the next hour or two, i'll paypal you £10 to say thanks!
Last edited:
