+ Reply to Thread
Results 1 to 3 of 3

Double click to copy cells and paste elsewhere

  1. #1
    Registered User
    Join Date
    02-11-2015
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    11

    Double click to copy cells and paste elsewhere

    Hello, fairly new to VB and I've tried to do this with limited success. I have a worksheet with data in columns A, B, C, D.

    Basically I would like the user to be able to select two rows of data for use in calculations elsewhere in the sheet. I'd like them to be able to double click on the first desired cell in column A (e.g. A15) and the data in adjacent cells in columns B, C, and D (e.g. B15, C15 and D15) be copied to N1, O1 and P1 respectively. On double clicking a second cell in column A (e.g. A20) the same will happen except the data (B20, C20, D20) will be pasted into N2, O2 and P2 respectively.

    If the user clicks on a third cell in column A it will do the same but overwrite the data in N1, O1 and P1. So basically it will just keep cycling between pasting in N1:P1 and N2:P2.

    Is this possible? Hope I've been clear enough.

    Thank you for any help

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Double click to copy cells and paste elsewhere

    Try this
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-11-2015
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    11

    Re: Double click to copy cells and paste elsewhere

    Perfect. Thank you so much for your help

+ 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] VBA for Double Click Copy Paste
    By Kehoth01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2014, 02:34 PM
  2. [SOLVED] Double click VBA to copy & paste to new list
    By OTHERLARISSA in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-28-2013, 09:37 AM
  3. Double-Click Function And Copy-Paste Value In Cell B2
    By FLani in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-25-2013, 02:46 AM
  4. [SOLVED] Double click to copy and paste value to first available row.
    By JO505 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2013, 05:37 PM
  5. [SOLVED] How to copy fr AU:AY & paste to O:S after double click at B in same row
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-14-2012, 03:34 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