SoftMaker.com

Thanks, Petroben,
Worked a treat, not sure why I missed it! Age me thinks.
Regards

Thanks Jossi,

Worked a treat, I'd totally missed that one.

Hi
I think the subject says it all.

How do I copy the settings to a different computer?

Does it make a difference if it goes from a W10 to a W11 machine?

Thanks, Woody44
That's basically what I am doing at the moment.

I was thinking along the lines of multiple-page templates to choose from.

But the way I'm doing it and your suggestion work OK.
Regards

Hi, Brain freeze is in full swing. :o :o The bottom line has the + sign to give you a new worksheet. But, Is there a way to have a worksheet template so that you can add a fixed format form to it? I have a sheet which I want to use as if it were a template itself, currently, I have just got a single...

I have a graph which is supposed to show the X (date) and Y (£). Column A carries a date and starts from A15 and ends at A52 (date) column E carries a £ amount starts from E15 and ends at E52 Attached: shows Snap 1 using a different column with another numeric value and show what I was expecting. an...

This seems to work

Please see the attached snap.
How do I reference the red and blue cells, the values in B will be added to at no fixed date and time so I can't predict B12 or B15.
In other words, I need to replace B12 or B15 with a formula.

Great news. looking forward to its implementation.
Regards

Any chance this is ever going to be addressed?

HI,
Was there supposed to be an attachment?

Hi SuperTech, I think I've noticed a problem. When the formulae are used the next time, the tariff has changed, all the values above change to the newest tariff Tariff 01/07/2020 £0.1826 £0.0550 £0.2376 04/10/2021 £0.1848 £0.0557 £0.2405 added tariff 18/01/2022 £0.1878 £0.0559 Graph should be: 16/01...

Hi SuperTech
Thank you so much, I'll spend some time this afternoon and see if I can learn how you've done it.
But it certainly looks good.

Hi SuperTech, Thanks for taking the time. I've just ditched about fifty worksheets which were all messing around by me NOT getting anywhere. So we are left with 'Graph' where the formulae are and 'Tariff' where the incremental data is updated. Maybe this is a clearer way of showing what I'm trying t...

Sorry, Snap_Saturday, 8 January 2022_16h29m47s_002_FIT calculations.pmd - PlanMaker.jpg The amount due is calculate with E47 =(D47*( 17.87 /100))+((D47/2)*( 5.38 /100)) Values are taken from tariff worksheet and hand-entered 26/07/2019 £0.1787 £0.0538 £0.2325 15/01/2020 £0.1787 £0.0538 £0.2325 <- th...