Stage 1 RED
I have a spread sheet that calculates gas usage and then creates a invoice. When I select the meter number which is controlled by data validation I want it to update the flat number B11 from "a4 Sub meters", Name B10 from b4 Sub Meters , Tenant Code e7 from c4 sub meters.
Stage 2 BLUE
When I enter the value for "period to" on the invoice I would like it to update "Meter Reading d17 from N4 Sub Meters", "Units Used from N22 Sub Meters" , "Kilowatts Used f17 from N40 Sub Meters" and "Cost G17 from R59 sub meters".
Hope that makes sense