+ Reply to Thread
Results 1 to 2 of 2

Macro to Copy a Cell from a Range When Adjacent Cell = TRUE and Paste to Different Sheet

  1. #1
    Registered User
    Join Date
    11-19-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    1

    Red face Macro to Copy a Cell from a Range When Adjacent Cell = TRUE and Paste to Different Sheet

    Hi All,

    I hope someone can help. Here is the situation: I have a worksheet which includes multiple tabs of summary reports (all identical format). Each tab has a list of names in column D and a set of check boxes linked to the adjacent cell in column C. Additionally, I have a "Detail Report" tab which allows the user to select from the list of names throughout the workbook, which will populate activity details about that particular person. What I want to do is allow the user to click on a check box next to a person in the name list from any one of the sheets and have a macro that will copy the adjacent name and paste to the reference cell on the detail report tab, uncheck the checkbox, and jump to the detail report. I am completely lost. (I posted an image below including shots of the basic sheet layouts I am dealing with)

    I would greatly appreciate anyone's help. I am extremely strong when it comes to formulas and complex workbook functions, but when it comes to macros, I am a complete novice.

    Regards,
    Kate

    Macro Actions.jpg

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Macro to Copy a Cell from a Range When Adjacent Cell = TRUE and Paste to Different She

    It would be great if u attached sample workbook
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

+ 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. Copy Cell Range From Previous Sheet and Paste to Active Sheet
    By jtal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2013, 03:26 PM
  2. [SOLVED] Macro to copy a cell range and paste to a new sheet 'n' times where 'n' defined by formula
    By staminaboy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-26-2013, 11:39 AM
  3. [SOLVED] Range Selection up to last visible adjacent cell,filter,copy paste to next sheet
    By kcube17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2013, 07:08 AM
  4. [SOLVED] find value, copy value of adjacent cell and paste it on another sheet
    By Ajgor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2012, 04:21 PM
  5. Replies: 4
    Last Post: 03-14-2012, 05:32 PM

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