(this version is 1-14. For network use see 1-14N below)
Many of my customers have requested additional features of our popular Customer Database for Service Businesses including Point of Sale functions
continue reading…Archive
Category: Access & ExcelA concrete calculator in Microsoft Excel can be found in many locations, but many won’t tell you the number of bags for self mixing nor give a total cost. What makes this one of my favorite Excel applications is that it uses no VB its formulas include Herons triangle so all triangles can calculate. It ends with bag needs and then comes up with a total cost. A must for all contractors and any handyman.
Customer Database with Email, Invoicing,
There are many corporate Microsoft Access relational databases but very few for Service Businesses. continue reading…
A very useful macro is to make a new book from a page in your current book. The scenerio is this you take some information using formulas and look ups and now you need to save it specifying a new name, clear the old sheet, then increment the save name to be unique next save. continue reading…
Combining data from different sheets you need to keep it from overlapping or simply overwriting. To do this you need to find the end row of the data and then paste just below it.
continue reading…
Excel Name List Correction
So recently I responded to a forum question on how to search a name field. The problem is you can’t search a mixed one column name field, but how do you get the messed up entries into individual cells without retyping your data. I was amazed that so many people used long formulas instead of the built in Text to columns method so I created this toutorial. The video above best illustrates my method. continue reading…
The need for an Excel passord generator Is often talked about in security Lockdown.co.uk reports that 8 digits of a 26 character code (typical leter based no caps or all caps) can be busted in 3 1/2 minutes. continue reading…