Hi, I use Excel 2010 to keep track of a RAID Log. I have a column called "Status", where I put the status of the task...either Not Started, In Progress, or Done. When a task is done, I'd like that task (the whole row) to move to the bottom of the sheet. I don't want it to move to a different sheet. is this possible? Please advise and thank you very much in advance
Hi, welcome to the forum
You cannot do this - the way you want - with formulas.
Have you considered using SORT? Alternatively, you would need a macro
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi, welcome to the forum
You cannot do this - the way you want - with formulas.
Have you considered using SORT? Alternatively, you would need a macro
I was hopping for an automatic solution instead of using sort. Please advice as to how to use the Macro. Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks