We help IT Professionals succeed at work.
Get Started

When I select a value in a cell I want it to update other information in side the spreadsheet

cybersi
cybersi asked
on
105 Views
Last Modified: 2015-02-27
HI All

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

Regards

Simon
Gas-Accnts.xlsx
Comment
Watch Question
Finance Analyst
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 2 Answers and 4 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE