Accumulate then Redeem (?)

Originally Posted by Tr1gg0R

Sorry I've just realised that macros just repeat a process you've taught them - so it wouldn't work as I mentioned above...

I'm sure there must be a way around this - perhaps I could use a forumla that would only take into account values entered after a certain date (i.e. date of last fill up)?

Hi,

No you are incorrect. Whilst at their very simplest macros may simply play a recorded series of key strokes, most of the time macros perform much more powerful functionality than that. They can interact with the user, prompt for more information, perform logic tests and take different directions depending on the state of various conditions.

The macro I gave you will do exactly as you have described. It will work out the next blank row and change the formula accordingly every time you click the button. You will of course need to choose to Enable Macros when prompted on opening the workbook.

As I suggested you could use a formula but there needs to be some condition the formula can detect. You mention the date of the last fill up but your current example doesn't record any dates - or indeed any other factor which would indicate a fill up has taken place. That was exactly the point I was making in my previous post. If you want to change your workbook to record such a fact then upload another one. However since the macro version is straightforward and avoids the need to log a 'fill up' personally I'd stick with that.