VBA code to display values based on selection in combo box

[anbarasi_r]

Hi,

I'm looking for a code that will display contents based on selection in combo box.

For example:

My sheet upload.xlsm . Sheet 1 is the main sheet. Combo box will be placed in sheet 2. Combo box should display months from Sheet 1 like May-15, Jun-15, Jul-15 etc. When a month is selected then filtered contents from sheet 1 should be displayed for that particular month. Like for example if Jun-15 is selected then, code has to display from Column B to D then for that month Column K to O. Not all contents for that month needs to be displayed. For column L only IFD and NCS need to be displayed. For column N if number is less than 1 then should be displayed. Any onsite/offshore movements or resign should also be captured. code has also to mention like Attrition or Billing or Status

SAmple Output:

Month selected - Jun-15

Column B	Column C	Column D	Column E
Attrition	001	Arun	Offshore
Resign	003	Vijay	Offshore
Billing	001	Arun	0.5
Billing	002	John	0.25
Billed	001	Arun	IFD
Billed	004	Ivan	NCS

<tbody>
</tbody>

Any help is appreciated. Thanks in advance.

Let me know if anything else is essential.

 

[anbarasi_r]

Sorry guys. This will be my current requirement. Output should be like below:

Status	Name	Billing %	Project	Onsite/Offshore	Team
Onsite/Offshore movements					GS or GO
NCS
AFD
IFD
Billing (if % less than 1)

<tbody>
</tbody>

​