Updating Next Consecutive Cell in Range
in [Functions]
|
From: Stilltrader47 on 27 Mar 2010 00:58 I am trending a bank account balance. Every time I enter the current value in cell c3, I would like it to update the value in the next empty cell in range c5:c200. Thanks Sony
From: Fred Smith on 27 Mar 2010 01:17 How do you want it updated? If the last used cell is C100, and you enter $1000 into C3, what do you want in C101? Regardless, I would recommend a more traditional setup. Enter each transaction as a separate row. Keep a running balance in the last column. You have an automatic audit trail, the current balance is always the last row, and you have a history of your balance at every transaction. Regards, Fred "Stilltrader47" <Stilltrader47(a)discussions.microsoft.com> wrote in message news:DC024258-6FE2-4AA1-B12E-EB9AE939F8EA(a)microsoft.com... >I am trending a bank account balance. Every time I enter the current value > in cell c3, I would like it to update the value in the next empty cell in > range c5:c200. Thanks > > Sony
From: Don Guillett on 27 Mar 2010 08:55 ?? cells(rows.count,"c").end(xlup).row+1,"c").value=cells(3,"c") -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Stilltrader47" <Stilltrader47(a)discussions.microsoft.com> wrote in message news:DC024258-6FE2-4AA1-B12E-EB9AE939F8EA(a)microsoft.com... >I am trending a bank account balance. Every time I enter the current value > in cell c3, I would like it to update the value in the next empty cell in > range c5:c200. Thanks > > Sony
From: Don Guillett on 27 Mar 2010 08:59 Please post in ONLY ONE group. -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Don Guillett" <dguillett1(a)gmail.com> wrote in message news:ODw68yazKHA.2552(a)TK2MSFTNGP04.phx.gbl... > ?? > cells(rows.count,"c").end(xlup).row+1,"c").value=cells(3,"c") > > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguillett(a)gmail.com > "Stilltrader47" <Stilltrader47(a)discussions.microsoft.com> wrote in message > news:DC024258-6FE2-4AA1-B12E-EB9AE939F8EA(a)microsoft.com... >>I am trending a bank account balance. Every time I enter the current >>value >> in cell c3, I would like it to update the value in the next empty cell in >> range c5:c200. Thanks >> >> Sony >
From: Stilltrader47 on 3 Apr 2010 00:04
Thanks Don, I will stay in one group. Thanks for the macro below I'll try. Let me clarify my objective, to help you better understand the code I need. For example, I want to always enter the new value in cell j29. Each entry will update the value to the next consecutive empty cell in range c49:c60. Your help is appreciated. Tom "Don Guillett" wrote: > Please post in ONLY ONE group. > > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguillett(a)gmail.com > "Don Guillett" <dguillett1(a)gmail.com> wrote in message > news:ODw68yazKHA.2552(a)TK2MSFTNGP04.phx.gbl... > > ?? > > cells(rows.count,"c").end(xlup).row+1,"c").value=cells(3,"c") > > > > -- > > Don Guillett > > Microsoft MVP Excel > > SalesAid Software > > dguillett(a)gmail.com > > "Stilltrader47" <Stilltrader47(a)discussions.microsoft.com> wrote in message > > news:DC024258-6FE2-4AA1-B12E-EB9AE939F8EA(a)microsoft.com... > >>I am trending a bank account balance. Every time I enter the current > >>value > >> in cell c3, I would like it to update the value in the next empty cell in > >> range c5:c200. Thanks > >> > >> Sony > > > > . > |