I have a worksheet "rates"

a2 is a data validation drop-down box- with list from e1:e20
and a3 has an entry,
if an option is chosen in a2
then a line is inserted with a3 having the same data validation drop-down
box
etc.etc.

I have this as a private sub workbook_open ()
as this has to initialise when the workbook is open.

Help is much appreciated