Automatically Create & Name New Worksheet Based On Cell Value (date)

**clemsoncooz** · 12-29-2011, 05:33 PM

I have this figuered out, KIND OF, and need some help.

I am trying to create a new worksheet for every cell value.

Please Login or Register  to view this content.

But this code - kind of works.

If you look at my attached file NewWorksheetTEST.xlsm , it works when the data is in 'January' format. But I need my data to be in 'mmm-yyyy' format (Jan-2012). Once I chnage the format, it doesnt work.

I think its because January is text format and Jan-2012 is a date format, but I dont know how to update my code to accommodate the date format.

Any suggestions would be greatly appreciated.

Thanks in advance.

**JieJenn** · 12-29-2011, 05:42 PM

I revised your code a little bit

Please Login or Register  to view this content.

**clemsoncooz** · 12-30-2011, 09:14 AM

Hello JieJenn. Thank you very much for taking the time to look at this and offer a solution. I appreciate that.

But yours also "kind of" works - not quite what I am looking for.

I'm looking for whatever the name is (and format) to show on the worksheet name. So if I type "1/1/12" into A1, but have the cell format to be "mmm-yyyy" (meaning Jan-2012 shows in A1), then the worksheet name would be Jan-2012. More so, if I typed 5/6/15, and the cell format shows to be May-2015, I want the worksheet name to be "May-2015."

Does this make more sense?

Thanks!

**clemsoncooz** · 12-30-2011, 12:47 PM

Maybe found the solution, If any one cares, I think this might be what I was after in the first place.

Please Login or Register  to view this content.

**JieJenn** · 12-30-2011, 01:55 PM

The values in your workbook in Column A are "text" despite that the formatting was custom. Date formatting does not work with text, and that was where my assumption coming from.