Shaved off a little more time; the attached now has a third button which calls code in a new code module (module1) where the countif formula (control days column) calculations are incorporated into the sub which calculates the main range. This code also clears old data before writing to the sheet in case the pre-existing data was bigger (number of rows) than the current data, but this may not be necesary as the code which loads the data should do this.
I've left the other code module in there for speed test comparisons.
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote