+ Reply to Thread
Results 1 to 9 of 9

help copying data from 1 cell and paste them to another cell with data already in it

  1. #1
    Registered User
    Join Date
    01-18-2016
    Location
    California, USA
    MS-Off Ver
    WINDOWS 2016
    Posts
    36

    Angry help copying data from 1 cell and paste them to another cell with data already in it

    Hello All,

    I'm trying to consolidate user notes and need help to copy notes from 1 user/cell and paste them to a different cell which has notes already in it. I've tried pasting them to the beginning of the cells...to the end of the cell, but it wont paste. I'm sure there's a way, but for some reason my brain isn't working today >.< Any one know?
    thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: help copying data from 1 cell and paste them to another cell with data already in it

    Check to see if it is in a filtered list or table (if you see Funnels like on the filter button in Data menu)you may need to unfilter the data. An example file would really be more helpful than IMAGINATION of the situation, please try to insert file.

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: help copying data from 1 cell and paste them to another cell with data already in it

    the only way I know of to do it is to click inside the cell (in the function bar) with the notes in it and copying all the notes, then click in the destination cell (again in the function bar) where you want the notes pasted then paste. is that what you mean?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: help copying data from 1 cell and paste them to another cell with data already in it

    Typically, you should be able to Cut and Paste....I prefer the shortcut keys, like Ctrl + C to Copy and Ctrl + V to paste OR you may need Paste Special as Values. Once you have copied what you want, you could also Right Click in the cell that you want to Paste to....from there a menu pops up with Paste Options: ....again if you can attach the file, it would be easier to assist you

  5. #5
    Registered User
    Join Date
    01-18-2016
    Location
    California, USA
    MS-Off Ver
    WINDOWS 2016
    Posts
    36

    Re: help copying data from 1 cell and paste them to another cell with data already in it

    Quote Originally Posted by Sambo kid View Post
    the only way I know of to do it is to click inside the cell (in the function bar) with the notes in it and copying all the notes, then click in the destination cell (again in the function bar) where you want the notes pasted then paste. is that what you mean?
    That did it!! You're the best! thanks so much
    ps. not sure how to mark as SOLVED >.<

  6. #6
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: help copying data from 1 cell and paste them to another cell with data already in it

    kudos / Congratulations! Keep at it and you will find solutions!

  7. #7
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: help copying data from 1 cell and paste them to another cell with data already in it

    Glad you got the help you needed and thank you for the rep! To mark it as solved use the thread tools dropdown at the top of the post in the gray bar toward the right just above your first post.

  8. #8
    Registered User
    Join Date
    01-18-2016
    Location
    California, USA
    MS-Off Ver
    WINDOWS 2016
    Posts
    36

    Re: help copying data from 1 cell and paste them to another cell with data already in it

    thanks so much for your help also!!

  9. #9
    Registered User
    Join Date
    01-18-2016
    Location
    California, USA
    MS-Off Ver
    WINDOWS 2016
    Posts
    36

    Re: help copying data from 1 cell and paste them to another cell with data already in it

    Quote Originally Posted by marcella needs help View Post
    thanks so much for your help also!!
    oopsie...this was for queuesf ;P

+ 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] Cut parts of data in cell with var delimiters to separate cells and copying adjacent data
    By Noah14 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-26-2015, 11:28 AM
  2. Replies: 5
    Last Post: 08-22-2015, 09:43 AM
  3. Replies: 3
    Last Post: 10-30-2013, 02:05 PM
  4. [SOLVED] Copying today's date into cell when multiple data is entered into adjacent cell
    By SChapman in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-16-2013, 04:12 PM
  5. Macro for checking data in a cell against another cell and copying/pasting data
    By JLP1996 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-12-2012, 03:41 PM
  6. UserForm data paste to cell, cell character limit cutting off data
    By mpkavanagh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2011, 01:31 PM
  7. Replies: 3
    Last Post: 07-15-2010, 08:49 AM

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