Hi All,
Greetings for the day!
I need to do repetitive task for filtering dealer payment data zone wise. my workbook (Dummy file) is having unique value for filter in column D named "zone". on the basis of these zones I need to create files zone-wise with name "payment file Silchar(zone name) dd-mm-yyyy(current date)". file to be save having name of that zone and the date (current date). this is to be done for every unique zones.
I am sharing the macros for one zone as below. Header of this file is having first two rows merged. in this macros, header is not copied, don't know why. please see the code and suggest how to do it for other zones and files/workbook should be saved in any other destination on my system.
I can also upload the file, not getting any option for the same. Please
Please Login or Register to view this content.
Bookmarks