Sorry, correction to this line
Refers to: =OFFSET('DV-Source'!$A$1,,,COUNTA('DV-Source'!$A:$A))

It should read as:
Refers to: =OFFSET(DV!$A$1,,,COUNTA(DV!$A:$A))

(Forgot to update change made to the sheetname from 'DV-Source' to 'DV')

Here's a new link to the sample construct:
http://www.savefile.com/files/6529637
AutoFill_multiple_cells_depending_on_single_cell_v alue_henrat_wks.xls

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--