Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 3rd 12, 06:45 PM
Junior Member
 
First recorded activity by ExcelBanter: Jan 2012
Posts: 2
Default Auto correct/update values in two related columns

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 to update (column c) and have (column b) adjust accordingly to not exceed column (a).

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
matching values in columns to update prices jonno Excel Discussion (Misc queries) 3 May 16th 08 10:04 AM
how do i auto update cell values after pasting linked references kev Excel Worksheet Functions 0 December 6th 07 06:09 PM
auto update formula when inserting additional columns dlisman Excel Worksheet Functions 1 August 9th 07 04:28 PM
Auto Update the formula values without opening the link worksheets Siva Excel Worksheet Functions 1 August 13th 06 12:31 PM
Auto update entire columns / rows??? Kcurtis Excel Worksheet Functions 3 February 3rd 05 11:45 PM


All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017