Create new sheets copying All the data of a specific sheet and gining names to all sheets

Hi

My goal is this.

I have a master sheet and in column A exist the working days of the month. This sheet using formulae receive data from all the others sheets.
I have sheet1 and sheet2 completed with DIFFERENT datas.

Rename sheet1 with the first date of the month that ALWAYS exist in MASTERA2! A2 of this new named sheet must have the date of MASTERA2!, formatting as Date.

Rename the sheet2 with 2nd date of the month tHAt will be always in MASTER!A3. iN A1 of this sheet must appears the date.

Create so many sheets as the list in MASTER sheet column A, give them as name the dates and in A1 of eatch this sheet appears the date AND copy in eatch of these sheets ALL the data from sheet2!

Thank you in advance!

Correct. Yes i know, but...Ok. No problem. i'll do it. Any idea?

And AB33: You must have fat fingers.. Fotis. Not Fortis..

This code create as many sheets as exist in the list of column A(starting in A2) in the Master sheet and give the names

Please Login or Register  to view this content.

Then i record a macro for the Copy & paste in the sheets. Then using same way i can record a macro for the dates in A1

So 3 different codes-macros. In this case only left the auto rename of the 2 first sheets.

So i almost have my solution, BUT I AM SURE that must be an "easier" solution.

Give this a shot

Please Login or Register  to view this content.

Hi my friend. Thanks for one more time.

Please Login or Register  to view this content.

The red part of the code, gives me this error

Compile error
Variable no defined

Any idea?

Thats the sheets Code Name. Did you try in on the example workbook you uploaded?

So sheet1 must rename by the first working date of the month that ALWAYS will be in A2. Same for Sheet2

Being that the sheet names will be changing I used the sheets Code Name. I guess you could also use the sheets index, as long as they will always remain in the same postion.

With Sheet2 will always work as long as the that sheets code name is Sheet2. Using the Code Name of the sheet in this case I think is better being that sheet1 and sheet2 names will always be changing but the Code names will ramain the same.

Mike apologize for the dalay. An unexpected visitor...

YES. i try to use the code in my example sheet that i uploaded here.

I know your using a Greek Version. The workbook you uploaded I see

Code Name=Sheet1 Tab Name= Master
Code Name=Sheet2 Tab Name= Sheet1
Code Name=Sheet3 Tab Name= Sheet2

Is this not the case for you?

Exactly as you say.

Do you think that maybe a reason could be the greek translate of sheet? What i mean is this.

In the sheet that i uploaded, i see this.

Code Name=Φύλλο1 Tab Name= Master
Code Name=Φύλλο2 Tab Name= Sheet1
Code Name=Φύλλο3 Tab Name= Sheet2

"Φύλλο"= Sheet

Can you pls upload the my workbook with your code to test it again?

Try

Please Login or Register  to view this content.

Mike this works but we have some issues...

1)the named sheet 310113 is sorting after my first sheet. Not at the end!

2) From sheet 030113 unti 110113 the format in A1 is "mm/dd/yyyy" All the others sheets have the format that i want "dd/mm/yyyy"

hey my friend,

I'll be stepping out from now till Sunday. If you don't receive a solution by then I'll keep an eye on this thread and respond back Sunday.

Ok Mike. I'll upload the example that i get and i'll wait..because VBA, as anyone knows, is not my strong card..

Thank you!

..And here it is!