+ Reply to Thread
Results 1 to 6 of 6

adding to end of string based on another cell getting changed

  1. #1
    Registered User
    Join Date
    10-25-2013
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    79

    adding to end of string based on another cell getting changed

    ok so this one might be a little bit hard to explain but i will try my best

    i have numeric values in columns D, H, K, N, and text in column AI.

    when i increase the value of column D by 1 i would like a "W" to be added to the end of the text string in column AI.
    when i increase the value of column H by 1 i would like a "L" to be added to the end of the text string in column AI.
    when i increase the value of column K by 1 i would like a "T" to be added to the end of the text string in column AI.
    when i increase the value of column N by 1 i would like a "O" to be added to the end of the text string in column AI.

    and if possible i would like column AI to always only show the last 10 characters in the string (they can be deleted or just hidden, either way)

    the numeric values in columns D, H, K, N are changed manually by me and always increase by 1 at a time and start at "0" and can increase up to a value of "80"

    maybe a code that "adds 1" to selected cell, and then IF that cell is in column D adds a "W", in column H adds an "L", in column K adds a "T", and in column N adds an "O" (if that makes sense!?!)

    if a sample workbook is need i can whip one up

    thanks for the help

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: adding to end of string based on another cell getting changed

    Hi, hopefulhart,

    will there be any other events being triggered if you input the new values? Maybe you should attach a workbook although I guess that you will use the Worksheet_Change-Event and a Select Case for finding the columns being triggered and chgaracters added and using Left to restrict the length to 10 characters. What I´m not so sure about: should the upper limit be restricted by code or by Data/Validation?

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    10-25-2013
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    79

    Re: adding to end of string based on another cell getting changed

    Hi Holger, thanks for the reply

    ive attached a workbook for you to look at

    when you ask about the upper limit do you mean the numeric values in D, H, K, N? because those dont need to be restricted, they are controlled by me.

    i have a few other formatting events that happen when i update/change the values in DHKN, but other than that i think thats it

    thanks
    Attached Files Attached Files

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: adding to end of string based on another cell getting changed

    Hi, hopefulhart,

    maybe you can have a look at this (there may only be one event of the name behind the sheet):
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-25-2013
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    79

    Re: adding to end of string based on another cell getting changed

    simply amazing!!!!

    thanks so much Holger

  6. #6
    Registered User
    Join Date
    06-05-2014
    Posts
    8

    Hope it would be useful for you

    Sorry it was not The solution just trying it in excel way; I could not find the way to delete this post anyway
    Attached Files Attached Files
    Last edited by Yovan Wisnu; 06-07-2014 at 04:50 AM. Reason: miss leading

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Changed cell value based on value in another cell (drop down menu)
    By DannyB94 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-28-2014, 04:55 AM
  2. How to handle Dates based on the value of a cell being changed ?
    By Shishir Jain in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-21-2013, 07:08 AM
  3. Can I prevent a cell or range from being changed based on a date?
    By lenstwo2 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-09-2013, 11:48 PM
  4. [SOLVED] Cell color will be changed based on its value compare with previous cell value
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-02-2013, 02:09 PM
  5. adding values as 1 string, based on adjacent column
    By TCountryman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2010, 10:51 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1