1.I have this macro for splitting multiple worksheet , but if I freeze top 2 rows as header instead of 3 define in macro 1 blank row gets created I want to delete that row or can it be flexible
2.if I want to change the criteria column for splitting where should I change now it is column 1 can it be flexible
3.after spliting the file format of the file gets change I want the preserved the same format
Please Login or Register to view this content.
i have posted this on other forum
https://www.mrexcel.com/forum/excel-...worksheet.html
Bookmarks