Forum Discussion
Move rows to sheet with drop down selection
Hello, I just discovered VBAs, I know where to place them, but I need assistance putting them into effect. I also need assistance creating a code that would allow me to move entire rows to another s...
That effort will be similar to the effort discussed in the posting Auto move row to different sheet after entering completion date. Of course, your code will have differences:
- Rather than examining column D, your code will examine column C.
- Your code will need to ignore rows where column C was changed to an empty string (in case that could happen), but will not include code to do date validation.
- Rather than moving the row to a worksheet named "Completed", your code will move it to the worksheet whose name is stored in column C (and copied into the variable vntStoredValue).