Vba cmd1 create workbook cmd2 create worksheet depend upon combobox values

**breadwinner** · 07-04-2013, 01:49 AM

Dear Expert

Here I have excel sheet with formatted userform of 3 combobox,2 command button

command button 1 assisgn to open new workbook in current location where master file is active.
command button 2 assign to open new worksheet in next to master sheet.

COMBOBOX values from unique values of column B:B REGION C:C PARTNER L:L OPERATOR

where depends upon combobox select values commandbutton1 and commandbutton2 should assign the value to newworkbook and new worksheet
COPY & PASTE RANGE OF SELECTION AREA IS (A:N)
please find the attachment 3 sheet

IST ATTACHMENT IS MASTER

RESULT FOR NEW WORKBOOK AND NEW WORKSHEET

2ND ATTACHMENT IS OUTPUT FOR WORKBOOK-SOUTHJOHN
3RD ATTACHMENT IS OUTPUT FOR WORKSHEET-MASTER_WS

THANKS ALOT

**breadwinner** · 07-05-2013, 12:59 PM

any experts help my threat

**Naveed Raza** · 08-17-2013, 03:20 AM

need some clarification

u have only 4 operator , and each operator has its own region right, means john has only south region or else any chances there for other region to john.

u want to filter region wise and as well as partner name and whatever the data relates to that region & partner name should copy and paste in new workbook right and same data should paste in master file itself in new sheets right.