Adding Sheets - New Sheets to be named a specific cell within Each Sheet

Good Morning -

I've gotten to about 90% of where I need to be thanks to help from this forum and JBeacaire and just need a little push to the end.

Currently the script I am using is is splitting out a worksheet into seperate worksheets based on unique values in column L, Adds subtotals to the bottom of column W and Z and changes my amounts to Accounting format.

Essentially the last thing I need is to have every new sheet being created to be named the value in AE2.
My problem with this is that as you can see from the attached example (confidential information is X'd out) Column AE contains values larger than 31 characters and also some characters that are not allowed in sheet names. (/ for example)

What I'm wondering is if someone can help me add something in to delete all non-allowed characters from column AE, Trim Column AE to 31 characters and then when the sheets are being added name them the value in column AE.

I've found a workaround just doing the format manually and using a name change Macro but I was just hoping to combine it into this macro to avoid having to run two. Any help with this will be greatly appreciated.

*Original Macro Script to split sheets is from JBeaucaire*

Please Login or Register  to view this content.

TEST.xls

I apologize as I left out a part of this request. Also, columns W through Z come out of the database I pull from as for example 10000 when in reality the value I need is 100.00 essentially missing the decimals. I wasn't sure if there was something we could add to divide all of those values by 100 and replace them either before or after making the new sheets. If this is a bit too much please let me know and I can find work arounds.

This is the lowest priority of the above requests but would be awesome to have built in as well.

My goal is to just be able to run my report, extract out of my database and run this macro to format without needing work arounds but if this isn't 100% possible, I get it completely.

Thanks again for any help in advance.

Bump. No Response.

Bump. No response.

Bump. No response.

Bump. No response.

Bump. No response.

Sorry, couldn't test until I got to work. Works awesome.

Marked As Solved.