Write macro to move data to new sheets, depending on month
I am trying to write a macro so that if the value in Column A is in the month of November, the whole row goes to the sheet "Nov". If the value in Column A is in the month of December it goes to the sheet "Dec"...and so forth. The dates are in the format 11/28/09, etc. All of the data that I want to sort is in the worksheet "Today's Hedge Report". Please see attached file. Thank you!
Try this out:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you for your help! The code worked for the most part, however it didn't work for June or September. Do you know why that would be? Or how to fix it?
Also, is it possible to also separate them by year, so I can keep track of more than one year at a time?
I'm sure you've got an error in the sheet names or in the data itself. Did you name the sheet "Jun" or "June" ? The macro assumes the sheets are named the same way, 3 letter abbreviations.
Feel free to upload a fuller sample sheet showing data/sheets that fail.
If you change your sheet names to:
Nov09
Dec09
Jan10
Feb10
...etc.
Then this version of the macro will work for that:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks