Damodaram
10-08-2014, 12:16 AM
Hi anyone,
Can some one help me to save multiple excel files from one excel database.
I have three tabs in one excel file.
I have around 500 rows in 3rd tab with 35 columns data..
in 20 column, i have persons names. if i see the names it comes around 26 unique names out of 500.
So is there any way i need to separate 26 files for 26 unique persons with their related data in 3rd tab. but i also need to retain tab 1 & 2. and same format to be retained. please help me out with the issue.
Thanks,
Damodaram Eddala
Can some one help me to save multiple excel files from one excel database.
I have three tabs in one excel file.
I have around 500 rows in 3rd tab with 35 columns data..
in 20 column, i have persons names. if i see the names it comes around 26 unique names out of 500.
So is there any way i need to separate 26 files for 26 unique persons with their related data in 3rd tab. but i also need to retain tab 1 & 2. and same format to be retained. please help me out with the issue.
Thanks,
Damodaram Eddala