Updating Next Consecutive Cell in Range
in [Functions]
|
From: Don Guillett on 3 Apr 2010 08:57 If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Stilltrader47" <Stilltrader47(a)discussions.microsoft.com> wrote in message news:B57FD199-FB48-483B-BD57-7FA7E8E7C747(a)microsoft.com... > > 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 >> > >> >> . >>
From: Stilltrader47 on 4 Apr 2010 00:35 Thanks Don I will put together this coming weekend and forward. I appreciate your review "Don Guillett" wrote: > If desired, send your file to my address below. I will only look if: > 1. You send a copy of this message on an inserted sheet > 2. You give me the newsgroup and the subject line > 3. You send a clear explanation of what you want > 4. You send before/after examples and expected results. > > > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguillett(a)gmail.com > "Stilltrader47" <Stilltrader47(a)discussions.microsoft.com> wrote in message > news:B57FD199-FB48-483B-BD57-7FA7E8E7C747(a)microsoft.com... > > > > 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 > >> > > >> > >> . > >> > > . >
From: Don Guillett on 9 Apr 2010 10:02 Private Sub Worksheet_Change(ByVal Target As Range) 'Assumes destination range is clear If Target.Address = Range("g3").Address Then Cells(Rows.Count, "d").End(xlUp).Offset(1) = Target End If If Target.Address = Range("g4").Address Then Cells(Rows.Count, "e").End(xlUp).Offset(1) = Target / 100 End If End Sub Sub clearcolD() Columns("d").ClearContents Cells(12, "d").Value = "PE Ratio" Cells(12, "e").Value = "Div Yield" End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Don Guillett" <dguillett1(a)gmail.com> wrote in message news:%23o3%2330y0KHA.6104(a)TK2MSFTNGP06.phx.gbl... > If desired, send your file to my address below. I will only look if: > 1. You send a copy of this message on an inserted sheet > 2. You give me the newsgroup and the subject line > 3. You send a clear explanation of what you want > 4. You send before/after examples and expected results. > > > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguillett(a)gmail.com > "Stilltrader47" <Stilltrader47(a)discussions.microsoft.com> wrote in message > news:B57FD199-FB48-483B-BD57-7FA7E8E7C747(a)microsoft.com... >> >> 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 >>> > >>> >>> . >>> >
From: Stilltrader47 on 10 Apr 2010 01:00
DOn, This is great, thank-you. I will certainly keep your info. "Don Guillett" wrote: > > Private Sub Worksheet_Change(ByVal Target As Range) > 'Assumes destination range is clear > If Target.Address = Range("g3").Address Then > Cells(Rows.Count, "d").End(xlUp).Offset(1) = Target > End If > If Target.Address = Range("g4").Address Then > Cells(Rows.Count, "e").End(xlUp).Offset(1) = Target / 100 > End If > End Sub > > Sub clearcolD() > Columns("d").ClearContents > Cells(12, "d").Value = "PE Ratio" > Cells(12, "e").Value = "Div Yield" > End Sub > > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguillett(a)gmail.com > "Don Guillett" <dguillett1(a)gmail.com> wrote in message > news:%23o3%2330y0KHA.6104(a)TK2MSFTNGP06.phx.gbl... > > If desired, send your file to my address below. I will only look if: > > 1. You send a copy of this message on an inserted sheet > > 2. You give me the newsgroup and the subject line > > 3. You send a clear explanation of what you want > > 4. You send before/after examples and expected results. > > > > > > -- > > Don Guillett > > Microsoft MVP Excel > > SalesAid Software > > dguillett(a)gmail.com > > "Stilltrader47" <Stilltrader47(a)discussions.microsoft.com> wrote in message > > news:B57FD199-FB48-483B-BD57-7FA7E8E7C747(a)microsoft.com... > >> > >> 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 > >>> > > >>> > >>> . > >>> > > > > . > |