+ Reply to Thread
Results 1 to 6 of 6

Macro to copy selected cells contents to another cell

  1. #1
    Forum Contributor
    Join Date
    03-06-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    352

    Macro to copy selected cells contents to another cell

    Hi there and good morning,

    I'm after a macro that, when I select a cell, will copy the contents of that cell to another cell. It needs to run automatically after cell selection and it needs to change every time I change the cell selection. I will only ever be selecting one cell at a time.

    Can anyone help?

    Many thanks

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Macro to copy selected cells contents to another cell

    To where? any logic about the to another cell? Please give some more details.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    03-06-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    352

    Re: Macro to copy selected cells contents to another cell

    OK thanks. Basically I'm going to make it a parameter for a query, so that the contents of the cell I select will be copied to another cell and used from there for a parameter. It doesn't have to copy the contents, I'm just not sure if there's another way to do it.

    Can you understand or not?

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Macro to copy selected cells contents to another cell

    Please refer post #2 once again and provide some more valid inputs.....

  5. #5
    Forum Contributor
    Join Date
    03-06-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    352

    Re: Macro to copy selected cells contents to another cell

    Just by the off chance I have managed to do it myself. Miracle will never cease.

    Thanks very much anyway

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Macro to copy selected cells contents to another cell

    Glad you fixed it on your own and thanks for the feedback

    Also please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] Need MACRO to copy the text in the cell left of first selected cells (a column), paste all
    By joobeng in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-16-2013, 06:42 AM
  2. Replies: 1
    Last Post: 02-19-2013, 04:30 PM
  3. Conditionally copy selected cells in rows depending on cell contents.
    By danando in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2011, 08:50 PM
  4. [SOLVED] Copy Selected cells down a row with macro
    By DB33 in forum Excel General
    Replies: 1
    Last Post: 02-15-2006, 01:35 PM
  5. Macro to take selected cells times a selected cell
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-23-2005, 08:05 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