satnair
11-26-2011, 11:07 AM
Hi,
I have a spreadsheet, and in one of the columns is a status of the request, once the status changes to closed the entire cell needs to be copied and moved to the last row which has the closed status. This would ideally mean that only open tickets with all other status except closed would be listed below.
Two things that need to be accomplised:
1) The entire Row colous should change
2) It should cut the rows and paste it to the last row which has closed.
Can this be done.
I have attached a sample file for reference.
Thanks
I have a spreadsheet, and in one of the columns is a status of the request, once the status changes to closed the entire cell needs to be copied and moved to the last row which has the closed status. This would ideally mean that only open tickets with all other status except closed would be listed below.
Two things that need to be accomplised:
1) The entire Row colous should change
2) It should cut the rows and paste it to the last row which has closed.
Can this be done.
I have attached a sample file for reference.
Thanks