How to Run Macro on specific sheet?

[Rookie79]

1st off, this is my first attempt at a macro. I copied someone posted here and tweaked it for hours till it did what I wanted it to do. I was so happy! Now, I am wanting to use the macro on one sheet and another macro in the 2nd sheet. Sheet one is named WTD, sheet 2 is named YTD. My code is rather long but I can post it if needed. I am sure I am overlooking something simple but each time I run the macros, they both run on WTD tab.

What I am doing is taking the info in 3 columns on each of my tabs and compiling it into one sheet. For WTD it is going to be coulmns G, H, I and for YTD it is going to be coulmns P, Q, R. I have one macro that pulls the WTD coulmns and one to pull the YTD columns. No matter what I try, both marcos will only run on the first tab, "WTD"

Any help would be greatly appreciated!

 

[Rookie79]

Thats not working. I guess the problem is that I am trying to run 2 seperate macros. One on the WTD tab that pulls from certain columns in the rest of the sheets, and another on the YTD tab that pulls numbers from different columns on the sheets. When I run the WTD macro, it goes perfect, when I run the seperate macro on the YTD tab, it pulsl the correct numbers, but puts it onthe WTD tab.

 

[MPW]

If I could see your code it would help.

Remember to use the # symbol on the tool bar to create a window to put your code into. Put your code after the 1st word "

".  Also it help sometimes to Preview your post before Submitting it.

 

[hiker95]

Rookie79,

Can we see all of your code?

At the beginning of your posted code, enter the following without the * character:
[*code]

Your code goes here.

At the end of your posted code, enter the following without the * character:
[*/code]