+ Reply to Thread
Results 1 to 8 of 8

Copy and Paste with matching function? Comment Box

  1. #1
    Registered User
    Join Date
    07-17-2013
    Location
    gtown
    MS-Off Ver
    Excel 2003
    Posts
    4

    Copy and Paste with matching function? Comment Box

    Hello all, I would really appreciate some help writing the VBA for the following:

    I currently have 2 worksheets (Dashboard and List). On the Dashboard worksheet the user can pull up different opportunity names and the sheet will give the user details about that opportunity. I am trying to allow a user to enter a comment into a cell in the dashboard tab, press a macro button and have that comment be transferred to a cell in the List worksheet within the appropriate row related to the opportunity the user selected on the dashboard sheet (for storage/tracking purposes). I can copy and paste the comment from the dashboard sheet to the list sheet, however, I don't know how to make the comment to go automatically to the specific cell next to the unique opportunity name.

    thank you so much!
    Last edited by mdeisen1; 07-18-2013 at 10:32 AM.

  2. #2
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Copy and Paste with matching function? Comment Box

    Will you have a matching name or something that you will be able to link this comment...

    Meaning...

    Sheet 1 column A Row 1 = 12345 so....
    Sheet 2 Column ... row... = 12345

    I need a matching from one sheet to the other...

    Do you have a Workbook you could post?

  3. #3
    Registered User
    Join Date
    07-17-2013
    Location
    gtown
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Copy and Paste with matching function? Comment Box

    DASHBOARD SHEET
    Column A: Column B
    Opportunity Name: TEST10
    Agent: Smith
    Reporting Status: Unqualified
    Type newest update: USER TYPES update here, clicks macro button

    LIST SHEET
    Column A: Column B: Column C: Column D
    Opportunity Name : Agent : Reporting STatus : Type Newest Update
    TEST 10 : Smith : Unqualified : Whatever has been typed on dashboard sheet matches Opportunity name and goes here
    Last edited by mdeisen1; 07-18-2013 at 11:04 AM.

  4. #4
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Copy and Paste with matching function? Comment Box

    I can't see your columns in your post...

    DASHBOARD SHEET
    Column A =
    Column B =
    Column C =

    LIST SHEET
    Column A =
    Column B =
    Column C =

    In what column your comment will be?

    What are you using to transfer this information: IE: command Button?

  5. #5
    Registered User
    Join Date
    07-17-2013
    Location
    gtown
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Copy and Paste with matching function? Comment Box

    I will simplfy it for you:

    Dashboard Sheet
    Row 1
    Column A: Opportunity Name
    Column B: Acutual Opportunity name lets call it ALPHA
    Row 2
    Column A: Latest Update
    Coloumn B: (User will type latest update here)


    List Sheet:
    Row 1
    Column A: Opportunity
    Column B: Latest Update

    Row 2
    Column A: ALPHA
    Column B: (What user typed in Dashboard Sheet)

    There are several opportunities in the List Sheet (all named differently). I need the comment to be routed to the approprate cell next to the correct opportunity name that was pulled up on the dashboard sheet

  6. #6
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Copy and Paste with matching function? Comment Box

    I have this but I think it need tweeking

    Example.xlsm

  7. #7
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Copy and Paste with matching function? Comment Box

    Updated:

    Only problem is that you have to select Column A and click transfer btn


    Example.xlsm

  8. #8
    Registered User
    Join Date
    07-17-2013
    Location
    gtown
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Copy and Paste with matching function? Comment Box

    Thanks ExcelNoub, i think i will be able to edit it from here!

+ 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. Macro: IF given range contains a comment box, then copy cell D1 and paste.
    By azhar.sayed in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2011, 07:22 AM
  2. Copy and paste matching data.
    By davidparkes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2011, 04:19 PM
  3. Replies: 0
    Last Post: 05-03-2006, 10:20 AM
  4. [SOLVED] copy and paste matching by using ID's
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2005, 06:05 AM
  5. [SOLVED] copy and paste graphics into comment boxes
    By steve in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2005, 11: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