![]() |
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