Create folder and copy 2 sheets

Printable View

09-13-2013, 02:28 AM
Conan

Create folder and copy 2 sheets

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.
09-13-2013, 02:49 PM
patel

attach please a sample file for testing
09-13-2013, 04:15 PM
Conan

1 Attachment(s)

Patel, thanks for reply.

I attached a file with no data. Are confidential.
09-13-2013, 05:59 PM
patel

sample file means a file with dummy data, not empty file
09-13-2013, 08:12 PM
Conan

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.
09-13-2013, 08:31 PM
patel

It's necessary for me, but you can wait for others answers
09-13-2013, 08:34 PM
Conan

Quote:

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 ...
09-13-2013, 10:54 PM
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.
09-14-2013, 12:22 AM
Conan

Quote:

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??
09-18-2013, 03:47 PM
Conan

Guess all the guys that helped have gone on this site....
09-18-2013, 07:21 PM
patel

do you need help ? help us by providing what we asked