Hi,
I need to split a large worksheet up into multiple worksheets. What I need done:
1) A macro to split all spreadsheets and save them as .xls files with the name of their corresponding tab.
2) For formatting not to be lost e.g. merged cells. Cell functions etc can be lost.
Any help would be greatly appreciated.
I tried using this code below but it had a large amount of debug issues and lost the formatting of the cells.
Please Login or Register to view this content.
Bookmarks