Tricky!
I want to update E33 every day. I've stuck an extra sheet into the workbook to do the daily update but it is hardly any improvement as I then have to start with that sheet, enter the value for the current day, the calculation of the new total then happens in the sheet but now I have to copy that value, return to the main sheet and paste special. This seems to work, but an elegant improvement it certainly is not. Also I am unfamiliar with SUMIF and from what I've discovered, I see no relevance.
It is starting to look as if there is no improvement available to the position I am currently in.
Thanks for your time,
Tony
|