ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Inserting row when option is chosen (https://www.excelbanter.com/excel-programming/321409-inserting-row-when-option-chosen.html)

Teresa

Inserting row when option is chosen
 
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



All times are GMT +1. The time now is 10:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com