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

1. ## 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).

Thank you SOO much for your help!!

2. ## 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. ## 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. ## 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. ## 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. ## Re: HELP! Macro to Copy specific cells from one sheet to another based on specific criteri

You are welcome!

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

#### 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