Forum Discussion
Using VBA to move a range of data to a different sheet when complete (need the for dummies version)
I'm trying to setup a macro so that when a task is completed (indicated with X), it automatically gets moved to a separate tab and deleted from original location. I was able to accomplish this but i...
HansVogelaar Now it's disappeared all together. Can I send it back to you?
Sure, go ahead.
- Thank you!!!
Don't you mean "It starts at row 6 instead of 7 (first row)"?
If so, change the line
For s = m To 7 Step -1to
For s = m To 6 Step -1- Thank you! It starts at row 7 instead of 6 (first row). What's the edit to change that?
Here is the workbook with the original macro, I haven't check whether it needs to be updated.
To view the macro, press Alt+F11 to activate the Visual Basic Editor.
