Hello,
I am trying to move the row and its contents to the "Completed" sheet after the status shows as "Completed". I would also like the rows on the "Project" sheet to move up. I am using Microsoft Excel 2011 for Mac. Can you please take a look and let me know what I am doing wrong. Thank you
Do you want the row to be moved as soon as the value is changed in that column or on the click of a button?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yes, I would like the row to move as soon as the value is changed. I am new to Excel Forum, and think I posted this in the wrong section. I opened a new thread in the Excel programing /VBA /Macros Forum
I too care of your new thread,so dont worry.
Try this code - Right click on the sheet, select view code and enter it in -
Please Login or Register to view this content.
Project worklist test.xlsmI was unable to get it to work. I entered the code saved it, went to test and it does not move. Also, will this code roll the existing projects up to fill the empty cells?
I changed the status of the 1st row from Completed to something else and back to Completed and then it worked. If you want to change the status of all the rows and then have them move, you can use a button. Once you click on it, the rows will move. For this you will need to change the code a little bit and i can help you if needed.
Change this rowtoPlease Login or Register to view this content.then, it will delete the row.Please Login or Register to view this content.
Must not have saved it properly the first time. It works great!
Thank you for all of your help.
RC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks