Hi All,
First of all I am very thankful to all of the members of this site.
I learned a lot from this site and applying the same in daily routine work and appriciated by all of my team mates and Managers.
Thank you all.
Now I am learning about macros.
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.
I uploaded the files in below link.
https://www.dropbox.com/s/9cyltkyuoqlosa8/Automate.zip
Thanks in advance for your help.
Regards,
Rajender
First of all I am very thankful to all of the members of this site.
I learned a lot from this site and applying the same in daily routine work and appriciated by all of my team mates and Managers.
Thank you all.
Now I am learning about macros.
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.
I uploaded the files in below link.
https://www.dropbox.com/s/9cyltkyuoqlosa8/Automate.zip
Thanks in advance for your help.
Regards,
Rajender