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...
Do you have two copies of the macro in the same workbook? If so, delete one of them.
If you use the command button:
Right-click it and select Assign Macro... from the context menu.
Select the macro in the active workbook, then click OK.
HansVogelaar Now it's disappeared all together. Can I send it back to you?
- 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.
Sure, go ahead.
