Hello there,

In the Excel worksheet, I have data from Column C10 to AC114.
Column C has Country, D has State, E has City , F to AC has mmm-yyyy (data in column F to AC is in row 7 of that column)
I have 2 combo boxes (independent):
1st Combo Box lists “Country, State, City, ALL” – I have written a macro which hides or unhides rows based on the selection from list. If the selection is “Country” Cells C10 to AC 17 are unhidden rest are hidden, if it’s “State”, Cells C19 to C51 are unhidden rest are hidden , if its “City” Cells C53 to AC114 are unhidden rest are hidden. If it’s “ALL”, rows from C10 to AC114 are unhidden. The code is executing perfectly. I have linked Cell B2 as cell link for the combo box
2nd Combo Box lists “Population, Vehicle, % Gender” – I have 12 macros for this execution. i.e I have 4 macros for “Population” (1 for Country, 1 for State, 1 for City and 1 for ALL) and similarly for other 2 list items in this combo box. The individual codes are executing perfectly. I have linked Cell B3 as cell link for the combo box

Now I want to combine codes. i.e. if the user selects “State” from 1st combo box and “Vehicle” from the 2nd combo box, I want to run “State Code” and “State Vehicle” Code and similarly, if the user selects “City” and “% Gender”, I want to run “City Code and City % Gender code.
Any suggestions on how this can be done. I thought of using IF condition and not sure how many combinations, I need to write.
I can share the individual codes that has been written.

Thanks!
Srikanth