Hello
could you please help me to write a macro to move rows from sheet Planning 2016 to the sheet Complete based on status column I; sheet Planning 2016.
The one I used does not work..see enclosed excel file.
Many thanks in advance
Ivana
Hello
could you please help me to write a macro to move rows from sheet Planning 2016 to the sheet Complete based on status column I; sheet Planning 2016.
The one I used does not work..see enclosed excel file.
Many thanks in advance
Ivana
Does this help?
Please Login or Register to view this content.
Try this macro-
Please Login or Register to view this content.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
no I get this error message see enclosed screen shot
Can't read your screen shot. What is the message and what is the associated number?
sorry, I found a small spelling mistake, it works perfect ! thanks!!
now I still would like to add a "move" button to execute the macro, do you know how?
This will help.
https://support.office.com/en-us/art...d-9c72c843a283
Hello John, how can I change the macro that it starts copying on the 5th row (not the 1st one) on the sheet complete?
Hello John, this macro after moving all completed rows and running it again it removes every row one after the other (not taking care about the status). Do you know why this could be?
Sub CommandButton21_Click()
Range("I4:I" & Range("I" & Rows.Count).End(3).Row).AutoFilter 1, "*Complete*"
With Range("I5:I" & Range("I" & Rows.Count).End(3).Row).SpecialCells(12).EntireRow
.Copy Sheets("Complete").Range("A" & Rows.Count).End(3)(2)
.Delete
End With
ActiveSheet.AutoFilterMode = False
End Sub
Not sure. I can't duplicate that. It works for me when I tested it. Can post a workbook where it does that?
sure, here it is
Hello John
Did you have chance to test it in the file I have sent you?
Kind Regards
Ivana
it moves all rows to the sheet Complete regardless the status "completed". So if I do not set any row to complete, and push the "move" button, it moves the rows line by line anyway.
Hello, is it possible to add to copy also formatting e.g. colour of the filled cells from the entire row (incl.schedules in calendar)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks