Closed Thread
Results 1 to 2 of 2

Macro To Link Data If Source Is Less Than 20 Characters

  1. #1
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    843

    Question Macro To Link Data If Source Is Less Than 20 Characters

    Hey there,

    How would I do this? I need to display the value of Cell A1 in Cell B1 as long as the value of Cell A1 isn't longer than 20 characters. And if the value of A1 is longer then 20 characters, 'SEE CELL C1' should be displayed in Cell B1 instead. And then Cell C1 would need to display the value of A1.

    Now, I know I could go about it this way:

    This formula in Cell B1:
    =IF(LEN(A1)<=20,A1,"SEE CELL C1")

    This formula in Cell C1:
    =IF(B1="SEE CELL C1",A1,"")

    I tried to do this here actually, but somehow I must not have been quite clear enough - Cell C1 must not and may not and can not have a formula in it, due to the fact that if Cell C1 doesn't get the value of Cell A1, then it needs to be available for manual data entry, and as far as I know, entering manual data into a cell that contains a formula replaces the formula, which will not do.

    So what's my best option here?
    There is so much good in the worst of us,
    And so much bad in the best of us,
    That it hardly behooves any of us
    To talk about the rest of us.

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Macro To Link Data If Source Is Less Than 20 Characters

    Swordswinger710,

    I am sorry but you cannot open duplicate threads for the same issue. You can bump the previous thread.

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

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