thanks a lot for your help i have attached the out put required and the same has been resolved as per below macro
Sub SplitData()
Dim wbk As Workbook
Dim wsh As Worksheet
Dim r...
Type: Posts; User: sachin482
thanks a lot for your help i have attached the out put required and the same has been resolved as per below macro
Sub SplitData()
Dim wbk As Workbook
Dim wsh As Worksheet
Dim r...
i have a macro as below of splitting multiple sheets but after splitting the formatting gets changed and freeze column also not reflecting i want to keep formatting ,header,aliment and freezing as...
i have 60 workbook in a folder, then i want to select 2 workbook for merging one after another ie:- 2 sheets one after another not in one worksheet, hence finally 30 workbook with 2 sheets each and...