Any suggestions on my revenue workbook?

[notnutts]

I've asked for and received great advice from you guys in the past, so I thought maybe you could take a look at the spreadsheet I created for my daily use, and give me some suggestions to make it better.

For background, I run parking garages. When I started, the company used spreadsheets like a pencil-in form. I made them so they automatically fill end of month reports from the daily revenue reports I fill out. I also added some basic error checking, links, and macros to make things easier. The company thinks I'm a computer whiz, but honestly I'm a duffer with mediocre excel skills. If you have time, take a look and critique me.

Tabs 1 thru 31 are each day of the month's daily revenue. Tax, credit and spreadsheet are my monthly reports. Valet 1 & 2 are bi-monthly reports.

Thanks

[6StringJazzer]

You need to immediately modify your file to remove passwords on sheet SOP and re-post.

[notnutts]

Good lord that was stupid of me. Those are old, but still--totally forgot I had them in there. Here is a copy with those removed.

[6StringJazzer]

You have this code in Module2. Is this being used, or is it deadwood? It's got a lot of moving around the screen that doesn't accomplish anything.

Please Login or Register  to view this content.

[6StringJazzer]

This code in Module1 doesn't seem to do anything useful either.

Please Login or Register  to view this content.

[notnutts]

I think the first one is a macro to clear the form contents. The second one just pops up a reminder when I detach and send off the three sheets. The second one is mostly just me playing with something new I'd learned--not overly useful but more of a bell/whistle