Auto correct/update values in two related columns

T

Tinman4

Sorry if this question has been answered

* MS – Office 2007

I have 3 cells in a worksheet
Column a: 500
Column b: 475
Column c: 25

Column (a) never changes.
The values in columns (b and c) will change weekly. I would like t
update (column c) and have (column b) adjust accordingly to not excee
column (a).

Would I do this through code or is there a simpler solution
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing two columns 0
Comparing 3 Columns and Returning a Result 2
Automatic Regressions based on Field Values 0
Counting unique values in multiple columns 4
Excel for comparing two columns exceeding 1,048,576 count 3
Using VLOOKUP to Sum values from multiple columns 1
VBA "Find" with multiple criterion 11
SORTING DATA IN TWO COLUMNS (salary and name ) - sorting as perdescending order of salary 0

Top