+ Reply to Thread
Results 1 to 6 of 6

Want to copy text from one cell to another cell based on another cells text

  1. #1
    Registered User
    Join Date
    11-23-2017
    Location
    Sweden
    MS-Off Ver
    Google Sheets
    Posts
    3

    Want to copy text from one cell to another cell based on another cells text

    Hi!

    I have a problem that ive been trying to solve without success so im trying my luck here.

    Im using Google Sheets and im building a sales document where I have the following areas:

    Business name
    The sum of the offer
    Deal

    So I want to copy data automatically from the cells where business name and the sum is to other cells when I write yes in the deal cell.

    Hope someone could help me and all tips is appreciated.

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Want to copy text from one cell to another cell based on another cells text

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Registered User
    Join Date
    11-23-2017
    Location
    Sweden
    MS-Off Ver
    Google Sheets
    Posts
    3

    Re: Want to copy text from one cell to another cell based on another cells text

    I have now attached a sample workbook with before, after and also a preferd after sheet wich is what I really want to make the data copied to another sheet.
    Attached Files Attached Files

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Want to copy text from one cell to another cell based on another cells text

    Here's the code, you can open the attached workbook to see the results.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-23-2017
    Location
    Sweden
    MS-Off Ver
    Google Sheets
    Posts
    3

    Re: Want to copy text from one cell to another cell based on another cells text

    Thank you Skywriter for your help so far. It has almost solved my problem. Is it possible to copy the cells to a different area in the same sheet?

    And I saw that when I uploaded the file to Google Sheets the code didnt work for some reason. It only worked when I tried it in Office version so I think I wouled need some instructions in how I paste the code and set it up in my sheet if its possible.

    Cheers

    Eric
    Last edited by eri2017; 11-24-2017 at 04:56 AM.

  6. #6
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Want to copy text from one cell to another cell based on another cells text

    Is it possible to copy the cells to a different area in the same sheet?
    Yes.


    And I saw that when I uploaded the file to Google Sheets the code didnt work for some reason.
    Maybe VBA doesn't work on Google sheets.
    Last edited by skywriter; 11-24-2017 at 01:22 PM.

+ 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. [SOLVED] When a certain text is in cell, copy paste in cells left or right of the text
    By TAMMY32 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2016, 05:23 PM
  2. Replies: 11
    Last Post: 04-30-2015, 05:35 PM
  3. Making Text Appear in a cell based on text in 2 other cells
    By NSimp216 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2015, 04:53 PM
  4. Formula to copy text from a cell, if two other cells have the same text
    By busybee02 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-19-2014, 07:35 PM
  5. [SOLVED] Change text color of selected cells based on a text value of another cell
    By JNEWBURY2280 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-09-2014, 11:26 PM
  6. Replies: 11
    Last Post: 05-23-2014, 06:41 AM
  7. sorting text from one cell into 3 other cells based on text criteria
    By steik in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2014, 06:35 PM

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