In the attached there's a button to click which calls macro blah.
Not 100% sure I have this right as it gives different results for Feb 3rd; could you check?
I've left your manual results at row 14 of Sheet1 for comparison.
Comments in code about which sheets to process; is there a sheet naming convention you have so that we can decide which sheets to process? If not perhaps we could use the fact that there's always 'Start date' in cell A1 in all the sheets that need to be processed?
(Saved you $20!)
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