How can i Copy Paste a dropdown list of any kind without overwriting whatever is already inside some of the cell?
scenario: I'm setting up a command button that when clicked will fix all the formula in the sheet. (this is for those who will insert rows in the future and need to adjust the formula to follow the sequence)
here is a sample:
for this 3 column - col A is fixed range/ named. Column B has a formula with each row depending on another row .
I want to Copy the top row and ctrl+shift down then pasting but that will overwrite any previously filled up data, is there anyway or code that will copy-paste the dropdown without overwriting existing data?
scenario: I'm setting up a command button that when clicked will fix all the formula in the sheet. (this is for those who will insert rows in the future and need to adjust the formula to follow the sequence)
here is a sample:
for this 3 column - col A is fixed range/ named. Column B has a formula with each row depending on another row .
I want to Copy the top row and ctrl+shift down then pasting but that will overwrite any previously filled up data, is there anyway or code that will copy-paste the dropdown without overwriting existing data?