I have been using the contextures guide to creating dependent drop lists based on dynamic data ranges

(scroll to the bottom of: http://www.contextures.com/xlDataVal02.html)

However I am having trouble being making it work with headings at the top of the dynamic data columns- OFFSET always returns a blank row at he end of the range or the drop down list fails.

Anybody got any idea how to change the contextures guide formulas so as to be able to put headings above the dynamic data??

Thanks in advance..

Strud