PDA

View Full Version : 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
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
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??
Conan
09-18-2013, 03:47 PM
Guess all the guys that helped have gone on this site....
patel
09-18-2013, 07:21 PM
do you need help ? help us by providing what we asked