VBA to identify the current month and previous month based on system date

Hi all,

I have a 12 sheets belongs to 12 months in a workbook.

How to identify the current month and previous month sheet in that workbook based on the system date and copy those data in a separate new sheet.

eg:
Current Month:July
Prev Month=June

Newsheet:

Month Year
July 2012
June 2012

Please look at the sample attachment.

Thanks in advance.

Regards
Kumar

Something like

Please Login or Register  to view this content.

Hi Jindon,

Thanks for your reply,

I didn't understand what you are trying to tell,

I don't have the column like "Date"

In the workbook sheet names like "Jan '12"....."Jun '12","Jul '12"..etc

Now from this workbook i just want to find out the current and previous month worksheet only from the available based on the system date and separate out the month and year from those work sheets in a new work sheet using vba code.

Hope you understand what i am looking for.

Regards
Kumar

Please Login or Register  to view this content.

Hi Jindon,

Thanks a lot.

It really helpful to me.
Regards
Kumar

Hi Jindon,

In the workbook sheet names are like this "Jan '12","Feb '12","Mar '12","April '12","May '12","June '12","Jul '12","Aug '12","Sept '12","Oct '12","Nov '12",
"Dec '12"

see these are not in the same format.

Now how to find the current month and previous month sheets from this kind of workbook.

Please provide a solution to me.

Regards
Kumar

Why do you make it so complex?

You will get trouble specifying sheet name if you have no rule to name the sheet and if you can not do it for yourself, you should maintain the rule.

Here's a simple sample (no error trap)

Please Login or Register  to view this content.

Jindon,

Thanks a lot. This is what i want
You are excellent.

Regards
Kumar

@ ravikumar00008

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Hi,

I am trying to mark it as solved.But i don't know how to mark it.

Can you please tell me how to do it?

Regards
Kumar

---------- Post added at 07:34 PM ---------- Previous post was at 07:00 PM ----------

Jindon,

one last thing i want in this discussion.

Right now we are able to identify the current month and previous month sheets.It is fine.
I want another way also,Like
I need to find all the previous months sheets from the current month along with the current month.

ex:
CurrMonth=July
PrevMonths=June,May,April,March,Feb,Jan.

Regards
Kumar