+ Reply to Thread
Results 1 to 6 of 6

HELP! Macro to Copy specific cells from one sheet to another based on specific criteria

  1. #1
    Registered User
    Join Date
    12-10-2012
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2007
    Posts
    3

    HELP! Macro to Copy specific cells from one sheet to another based on specific criteria

    Hello,

    I am really in need of help formulating a Macro in excel 2007.

    The spreadsheet i am working with calculates the number of times employees within the company receives any sort of recognition. The company i work for has over 1000 employees, so the spreadsheet is long and tedious to maintain. Nevertheless, i am trying to write a macro that can copy cells A:C (name and supervisor) and paste it into another worksheet based on cell AF (which calculates if they have ever gotten any recognition).

    Attached is a sample spreadsheet.

    Thank you SOO much for your help!!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: HELP! Macro to Copy specific cells from one sheet to another based on specific criteri

    "Based on cell AF"
    You have two conditions(True and False), so which one is the criteria? Let say if it is true, you want to copy A-C in to the monthly total. Is this right?
    Monthly Totals you have name and monthly total

  3. #3
    Registered User
    Join Date
    12-10-2012
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: HELP! Macro to Copy specific cells from one sheet to another based on specific criteri

    Yes, that is correct. If cell AF says True, i would like it to paste Cells A:C of that row to the monthy totals tab next to Name, so begin pasting at cell B2. Does that make sense? Then for the feb tab, i want it to do the same but start pasting in E2.

    Thank you very very much!!

  4. #4
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: HELP! Macro to Copy specific cells from one sheet to another based on specific criteri

    The criteria on both sheets is not on the same column, so I am not sure how you want to do it, but try this code and let me know how the result should be.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    12-10-2012
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: HELP! Macro to Copy specific cells from one sheet to another based on specific criteri

    Thank you SOOO much! It works like a charm, you are a genious!!

    (Sorry i didnt reply yesterday, i was singing your praises around the office!)

  6. #6
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: HELP! Macro to Copy specific cells from one sheet to another based on specific criteri

    You are welcome!
    Thanks for your kind words!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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