July 15th, 2008, 11:22 AM #1
- Join Date
- Jul 2008
excel spreadsheet, moving rows when done working on them. Please help
Thank you for taking the time to read this and help me. I am teaching myself how to use excel and I have a problem which is probably very simple, but I cant figure it out. Here is what I am trying to do.
I have a spreadsheet that my employees use to log their work and the status of that work. Usally they will enter about 20 rows per day, one row for every "new request" they reiceve. I would like them to use the same spreadsheet for a whole month. They dont always finish work in the order it is recieved, so I would like to find a way to sort the spreadsheet in this manner: When they complete all columns of a row, i would like that row to gray out, and move itself (the whole row) to the bottom of the list. This would leave the unfished work (or rows) at the top of the list and they would easily be able to see what they have left to complete.
Is this possible, and if so how do I do it? I have used formulas, and feel very comfortable with them. I have never used a macro, but if I need to, I will certainly try. Thanks so much in advance, I hope this makes sense.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By CNU182 in forum Technical SupportReplies: 5Last Post: December 13th, 2011, 10:36 AM
By sixf00t4 in forum Applications and Operating SystemsReplies: 3Last Post: July 19th, 2007, 03:59 PM
By grady088 in forum General Tech DiscussionReplies: 13Last Post: October 17th, 2005, 07:50 PM
By Marvinator in forum Applications and Operating SystemsReplies: 3Last Post: April 9th, 2004, 01:05 PM
By ATeixeira in forum Applications and Operating SystemsReplies: 3Last Post: November 11th, 2003, 11:01 PM