How to Create multiple files using Macro based on multiple conditions

Question

Hi All,

Few days back I saw 1 of post about Split an Excel File in to Many using VBA,

http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/

Now I want to automate the same in my work too. I tried to do myself first(recording macro & forum) now I am confused in between. I am also attaching the file also

I am uploading the files also which contains

1. My Master tracker from which I need to create multiple files
2. Customer template in which I need to paste the filter data and create multiple copies.

Master Tracker :

1. In sheet "Output file" I already created a macro on which we need to work.
2. In sheet "Do not Delete" I applied few functions and calculation on which basis we need to copy paste the data.
3. I created the duplicate sheets in my master tracker from which I need to copy data and paste in customer tracker "Equipment_Recovery_Form V22.xls"
4. No of file creation logic is depend on heads "FSL" & "Project code" as unique I mention the same in sheet "Do not Delete" column N & O
5. In customer tracker there are already two macros tab " which we need to run"Start again Clean" every time whenever we need to open that template and after filling the "Main sheet we need to run another macro " Create Equipment data sheet".
6. Every time the multiple sheet create tracking ID should be unique, I tried the same with function in " Do not Delete" sheet column M.
7. Also While multiple file saving then before saving Main,Address,Vlookup file needs to be hide and sheet name H&S, PROCESS and SURVEY needs to be deleted.

I uploaded the files in below link.

https://www.dropbox.com/s/9cyltkyuoqlosa8/Automate.zip

Thanks in advance for your help and assistance.

Regards,

Rajender

Answer 1

Hi All,

Awaiting for your expert assistance.

many thanks in advance.

Regards,

Rajender