Create folder and copy 2 sheets

**Conan** · 09-13-2013, 02:28 AM

Hello,

I would like to help me with the following problem:
In an excel file I have two spreadsheets, "Main" and "BC". In sheet 1 (called Main) in cell C2 = Month and year in D2. I want to create a folder with the name of the D2, and a file with the name of the C2 here to copy Sheet "Main" and change its name to "Month Year" (C2 & D2), and then copy sheet BC with Name "BC Month Year". The same sheets that were created I want to be copied and the file where the code is released.

Ex. In sheet "Main" in C2 is May and in D2 = 2012. I want to create a folder named 2012 and here a file named May. This will create sheets "May2012" (which will be copied sheet Main) and "BC May2012" (which will copy the sheet BC).
The same sheets that were created I want to be copied and the file where the code is released.

Anticipated thanks to everyone who will help me.

**patel** · 09-13-2013, 02:49 PM

attach please a sample file for testing

**Conan** · 09-13-2013, 04:15 PM

Patel, thanks for reply.

I attached a file with no data. Are confidential.

**patel** · 09-13-2013, 05:59 PM

sample file means a file with dummy data, not empty file

**Conan** · 09-13-2013, 08:12 PM

Patel,

Why is it necessary layout of data in the spreadsheet? If I want to copy ALL sheet
If you need more details, just ask.

**patel** · 09-13-2013, 08:31 PM

It's necessary for me, but you can wait for others answers

**Conan** · 09-13-2013, 08:34 PM

Originally Posted by patel

It's necessary for me, but you can wait for others answers

Patel,
If you can help me, fine, if not, let others who will ...

**alansidman** · 09-13-2013, 10:54 PM

With sample data in your spreadsheet, it makes it easier to test the solution to make sure it works before it is posted for your use. It also saves those willing to help from having to re-create your issue using their assumptions of how you set up, formatted and have data.

**Conan** · 09-14-2013, 12:22 AM

Originally Posted by alansidman

With sample data in your spreadsheet, it makes it easier to test the solution to make sure it works before it is posted for your use. It also saves those willing to help from having to re-create your issue using their assumptions of how you set up, formatted and have data.

It looks like you did not read carefully what I wrote in my post and attached file. Because I want to copy ALL the spreadsheet, why do you need to see the formatting, because it will automatically copy. Then why should be seen spreadsheet format??