Closed Thread
Results 1 to 3 of 3

Macro VBA - Merge Text Strings into One Cell with data validation

  1. #1
    Registered User
    Join Date
    07-04-2011
    Location
    Colombo
    MS-Off Ver
    Excel 2003
    Posts
    8

    Smile Macro VBA - Merge Text Strings into One Cell with data validation

    I need to merge 2 or more text strings in separate cells to one cell with if commands true part.

    Case :

    Sheet1 (TV) (RADIO) (OVEN) (FAN)
    (Purchased) B1 = 1 , C1 = 1 , D1 = 0 , E1 = 1
    B2 = 0, C2 = 0 , D2 =1 , E1 = 1

    Sheet2
    (Items)
    A2 = "21 Inch TV "
    A3 = "Sony Radio"
    A4 = "Microwave Oven"
    A5 = "Table Fan"


    OUTPUT
    Sheet3
    (Purchase Record) - new file for every record
    C2 = "21 Inch TV - Sony Radio - Table Fan"
    etc..

    I need to check that Sheet1 for true values and then get relevant text strings from Sheet 2 and then Merge all text strings in to one cell in Sheet3 and save as new file


    And I need to method to add text to existing text cell by VBA
    Ex:
    After processing Sheet3 C2: = "21 Inch TV - Sony Radio - Table Fan"
    then modify it by adding "PURCHASED" to the end

    Sheet3 C2: = "21 Inch TV - Sony Radio - Table Fan PURCHASED"

    How can i do that??
    Attached Files Attached Files

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Macro VBA - Merge Text Strings into One Cell with data validation

    Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Macro VBA - Merge Text Strings into One Cell with data validation

    please continue your discussion in your original thread http://www.excelforum.com/excel-prog...macro-vba.html

    Do NOT start a new thread just to dodge a mod request.

Closed Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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