dijohnguitar
New Member
- Joined
- Jan 13, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet that has Columns A-L. Dropdown lists are located in Columns F-K. All of my DropDowns have a default value of "(Select Value)" which obviously instructs users to pick a value from the dropdown. I'm trying to see if it's possible to do the following:
- In Column K, this dropdown selection will insert a new blank row under the current row, and remove all contents and validation EXCEPT in Column K. However, if they select "None" or if the Dropdown stays with "(Select Value)" no new row will be created.
- The Dropdown from Column K needs to copy down to the new row into Column K and be set with the "(Select Value)" title
- I need this to repeat for every row of data on the sheet
The information for the data validation in Column K comes from a separate sheet entitled "SOFTWARE" which has a substantial amount of choices (A1:A182). I'd certainly appreciate any assistance on this. I've set up a Macro to run exactly what I'm asking above, but it's only doing it for 1 row and not copying down for all the rows. I'd really appreciate the Excel Gurus with helping me tackle this one. Thank you!!
- In Column K, this dropdown selection will insert a new blank row under the current row, and remove all contents and validation EXCEPT in Column K. However, if they select "None" or if the Dropdown stays with "(Select Value)" no new row will be created.
- The Dropdown from Column K needs to copy down to the new row into Column K and be set with the "(Select Value)" title
- I need this to repeat for every row of data on the sheet
The information for the data validation in Column K comes from a separate sheet entitled "SOFTWARE" which has a substantial amount of choices (A1:A182). I'd certainly appreciate any assistance on this. I've set up a Macro to run exactly what I'm asking above, but it's only doing it for 1 row and not copying down for all the rows. I'd really appreciate the Excel Gurus with helping me tackle this one. Thank you!!