manilara
New member
DEAR EXPERTS
EXTREME MACRO FUNCTION
I WANT CREATE WORKBOOK DEPENDS UPON VALUE OF COMBOBOX.
I HAVE SET OF DATA RANGE FROM (A:BT) THROUGH COMBOBOX VALUES IN USERFORM I WANT CREATE SEPARATE WORKBOOK WITH THE WORKBOOK NAME OF SELECTION TWO VALUES(COBOBOX BOX 4 AND 6 SELECTION VALUE).XLS
SEE EXAMPLE
COMBOX1 IF REGION IS WEST THEN COMBOX 2IF PARTNERNAME IS Emall(ecs) COMBOX3 IF PARTS IS ZLAB COMBOX4 IF PROD TYPE IS IDEA COMBOX5 IF PARTS DELIVERED IS "N" COMBOX6 IF RESPONSIBILITY IS "SHALINI"
( RESULT SET OF 10 DATA ) WITH WORKBOOK NAME OF (IDEA_SHALINI.XLS) COMBOVALUE(4&6) WILL BE SHEET NAME
EXTREME MACRO FUNCTION
I WANT CREATE WORKBOOK DEPENDS UPON VALUE OF COMBOBOX.
I HAVE SET OF DATA RANGE FROM (A:BT) THROUGH COMBOBOX VALUES IN USERFORM I WANT CREATE SEPARATE WORKBOOK WITH THE WORKBOOK NAME OF SELECTION TWO VALUES(COBOBOX BOX 4 AND 6 SELECTION VALUE).XLS
SEE EXAMPLE
COMBOX1 IF REGION IS WEST THEN COMBOX 2IF PARTNERNAME IS Emall(ecs) COMBOX3 IF PARTS IS ZLAB COMBOX4 IF PROD TYPE IS IDEA COMBOX5 IF PARTS DELIVERED IS "N" COMBOX6 IF RESPONSIBILITY IS "SHALINI"
( RESULT SET OF 10 DATA ) WITH WORKBOOK NAME OF (IDEA_SHALINI.XLS) COMBOVALUE(4&6) WILL BE SHEET NAME