Automated copy paste using macro

[Qppg]

Hello all,
What I am trying to do is automate a series of select copy and select paste satements based off a cell value. The cell value that I am refrencing is months(Jan, Feb, Mar,etc...) I would like to have a button that when pressed looks at the cell B2's value then looks at the case for the appropriate value and performs the corresponding select, paste routines. I am not sure if the procedure I am using to perform this routine is the best method. Any help that any one could provide would be greatly apprciated. Thanks in advance

Bob

I won't post all the code because it is repeated for each month I will just include Jan through Mar. That way I won't exceed the character limit.

Please Login or Register  to view this content.

[yawnzzzz]

Change this part of the code:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Just a note, if you want to use LCase because they might type in the month in all uppercase or all lowercase, then you'll need to change all of the Cases as well.

Example:

Please Login or Register  to view this content.

[Qppg]

Thanks for the help...although I am sorry to say that I am still getting an error. Not sure if I missed something but here is what it is saying.

Complie error Type mismatch and it highlights target

Please Login or Register  to view this content.

Thanks again
Bob

[yawnzzzz]

Try just getting rid of this line.

Please Login or Register  to view this content.

[Qppg]

No Dice,
Error message compile error variable not defined.
Thanks again!

[yawnzzzz]

Please Login or Register  to view this content.

Make sure you don't have this line as target.value.

[Qppg]

yawnzzzz,
I figured it out....the reason it was not working is because I needed to activate the sheet that had the case values that I was looking for.

Please Login or Register  to view this content.

Thanks again for your help

bob

[yawnzzzz]

Good to hear. It's always the simple things that get you.