Hi All,
I am fairly new to VBA and Excel macros and I have to prepare a macro wherein I am required to insert a row one after the other and a drop down list options present in the row above should be copied in the inserted row
the scenario is as follows
1. Range(c5:E5) has dropdowns where in C5 has geographies (drop down) and D5 : E5 is merged with locations / addresses
2. If a user wants to add more locations, they can press a button and a row shall be inserted below (C6:E6) with the list options present in D5:E5 pasted in the inserted row.
3. This macro should run for as many locations as the user wants to add
Other considerations
1. There is more data below in the sheet, hence D5:E5 is not the last row
Will appreciate any help on this
Bookmarks