How to create a dynamic data validation from a table based on criteria

[GlobalTraveler]

I have the following table.

	United States	Hong Kong	India
Job Grade	Per Hour	Per Day	Per Hour	Per Day	Per Hour	Per Day
USD	USD	HKD	USD	INR	USD
P	1,600	12,800		-	24,150	3,145
D1	1,000	8,000	6,950	7,158		-
D2	900	7,200	6,250	6,437	17,850	2,325
SM1		-		-		-
SM2		-		-		-
M	700	5,600	5,200	5,356		-
AM1	500	4,000	3,350	3,450	9,450	1,231
AM2		-		-		-
S1		-		-		-
S2		-		-		-
S3	350	2,800	3,000	3,090		-
S4	280	2,240	2,750	2,832		-
A1	175	1,400	1,000	1,030	6,300	821
A2	135	1,080	1,000	1,030		-

<tbody>
</tbody><colgroup><col span="7"></colgroup>

I have a combo box (CB1) that uses a Dynamic Named Range of the Country Names as a Data Validation so the list would be and would expand dynamically as I added countries to the right

CB1
----------------------
United States
Hong Kong
India

In another combo box (CB2) where I want to have a dynamic data validation that lists on the Job Grades that have a USD Per Day amount for the selected Country.

So for example if in CB1 the user selects India then the Data Validation in CB2 would be:

CB2
----------------------
P
D2
AM1
A1

Notice the list contains only those job grades where the USD Per Day is blank (or could also use 0, I don't care what we compare againt blank or 0 as I can set the USD amount to either).

Just as the Named Range I use for CB1's data validation is dynamic and expands as colums are added to the right I would like this combo box data validation to also be dynamic and expand right as columns (countries) or down as rows (Job Grades) are added.

FYI: I usually use OFFSET in my dynamic named ranges instead of INDEX so that I don't have to worry about sorting, etc.

Thanks