Chirag R Raval
Member
Dear All,
There are many code available for each unique data set save as new file from Data
via filter or advance filter but...till not found code for
After Filter ..Only Result ... (in this result may have 3 or 4 unique value with set of same criteria rows) this result's each Unique set save as new file...
in other word ...if you have database of 40 Salesman sales figures ...Each name's row about 40, 50 or 60 (Dynamic-Not fixed) you filter for only 4 salesman...after filter now...result shown for only that 4 salesman.. i required only this 4 filtered sales person's data separate Excel files ...
please be clear i don't want files for all unique value of that columns ..i just want filtered result's unique data set as new file...
i attached herewith sample file for filtered on 2 buyers that i want this result each filtered buyer's data as new excel file with headings remains in each file with auto save on fixed path..
hope-your co-operation...
Regards,
Chirag Raval
There are many code available for each unique data set save as new file from Data
via filter or advance filter but...till not found code for
After Filter ..Only Result ... (in this result may have 3 or 4 unique value with set of same criteria rows) this result's each Unique set save as new file...
in other word ...if you have database of 40 Salesman sales figures ...Each name's row about 40, 50 or 60 (Dynamic-Not fixed) you filter for only 4 salesman...after filter now...result shown for only that 4 salesman.. i required only this 4 filtered sales person's data separate Excel files ...
please be clear i don't want files for all unique value of that columns ..i just want filtered result's unique data set as new file...
i attached herewith sample file for filtered on 2 buyers that i want this result each filtered buyer's data as new excel file with headings remains in each file with auto save on fixed path..
hope-your co-operation...
Regards,
Chirag Raval