Code or formula

noelmus

Board Regular
Joined
Dec 30, 2018
Messages
105
(Image)https://www.dropbox.com/s/2sz7hspvq6n4edk/Image.jpg?dl=0

Image.jpg
Hi,

In the image cell C14 is a drop down to determine which filling point (Meter) I need to use. In the Image 3 & 4 was selected, so Meter 3 appears in cell E19 and Meter 4 appears in cell H19.
I'm going to focus on Meter 3, since all filling points do the same thing. First thing that I need is that after saving the Finish Totaliser which in this example is 30000 (cell E20) will be recorded to Start Totaliser (cell E21).
Second thing which in my opinion is more complex is that Meters 1 to 6 have different Start Totaliser. So when for example I select from drop down 5 & 6 and cell E19 appears as Meter 5 and H19 appears as Meter 6, I need that the Start Totaliser appears different from those 1 & 2 and 3 & 4.
Don't know if it is possible but I'm asking.


Any help is appreciated.
 
Last edited:

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,215,594
Messages
6,125,723
Members
449,255
Latest member
whatdoido

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top