Dear All
I need your help as I want to split an excel workbook having multiple sheet into multiple excel file based on condition
I want to create a button in sheet1 to perform a macro to split all sheets into workbook based on column in sheet1
Sheet1
Name
A
B
C
D
Sheet2
NAME Commission
A 10
B 20
C 30
D 40
Sheet3
NAME Salary
A 10
B 20
C 30
D 40
Sheet4
NAME Sales
A 10
B 20
C 30
D 40
Bookmarks