My current problem with my workbook is that it is taking a long time to save. I believe that the issue may very well be related to how I have this set up but I didn't know another way.
Here is what I have: I created an excel spreadsheet that employees will use to log fingerprints that they take. I wanted to also be able to track the time that it takes to complete the fingerprinting process as well as simplify the data entry process and control some of the data that is logged. I created a userform that starts a timer when the user selects their name from the drop-down as the individual doing the fingerprinting. The timer stops when the user completes the fingerprinting and presses the "Log" button on the userform. The "Log" button validates the entries, writes the data to the spreadsheet and then saves the spreadsheet to avoid accidental loss of data. I think created a separate tab within the workbook for each month. On these monthly tabs, I am wanting to tally or count the number of prints that were taken each day and for each reason that prints are taken (reasons may include conceal/carry weapon permits, adoptions, bar exam, etc....). I used Countifs functions to count how many records we have for each fingerprint reason for each day.
When I save the workbook (regardless of if I save it using the Save & Clear button on the userform or if I click the save button within the workbook itself, the status bar at the bottom of the screen shows the following "Calculating: (4 Processor(s)): 15%" and the percentage amount increases gradually. It takes close to a minute to complete the save. I'm assuming that this is because it is going through each and every cell with a Countifs function and recalculating it.
Is there a better way to accomplish this? It doesn't really seem like my workbook is excessively large or contains an excessive amount of formulas/functions that would require a ton of time to calculate but what do I know. My workbook is attached.
Note: This issue may be better suited to a different forum as I don't think the issue is really related to the VBA code. Been working on this for three days now!![]()
Bookmarks