I have an action item spreadsheet I put together which contains a status in
column C. The status is Open, Closed, In-Progress, On-Hold, On-going (these
are part of my validation list). If the action item in the cell is "Closed"
I would like to move the entire row to row 9, without overriding what is
there. So whatever was in row 9 would be in row 10 to make room for the
closed action item. To make things more difficult, I have conditional
formatting to grey out ever other row for reading ease. Any help would be
appreciated.

Thanks!

What if you have more than 8 items with, say, Open status. You'll be moving
a closed item into the middle of your open stuff? Doesn't make sense to me
that you would want to do this. Why not move the closed items to a different
sheet?

"JFREE223" wrote:

I have an action item spreadsheet I put together which contains a status in
column C. The status is Open, Closed, In-Progress, On-Hold, On-going (these
are part of my validation list). If the action item in the cell is "Closed"
I would like to move the entire row to row 9, without overriding what is
there. So whatever was in row 9 would be in row 10 to make room for the
closed action item. To make things more difficult, I have conditional
formatting to grey out ever other row for reading ease. Any help would be
appreciated.

Thanks!

Great Idea and I have that established. Before it is moved, some individuals
would like to see it on the one sheet we print out...which is the open action
items list. For ease of review, they would like to see them at the top and
then move them to the closed list after it is reviewed. I have filters
established, but again they need to see all action items on the printout.

Thanks,
jf223

"Mike H." wrote:

What if you have more than 8 items with, say, Open status. You'll be moving
a closed item into the middle of your open stuff? Doesn't make sense to me
that you would want to do this. Why not move the closed items to a different
sheet?

"JFREE223" wrote:

I have an action item spreadsheet I put together which contains a status in
column C. The status is Open, Closed, In-Progress, On-Hold, On-going (these
are part of my validation list). If the action item in the cell is "Closed"
I would like to move the entire row to row 9, without overriding what is
there. So whatever was in row 9 would be in row 10 to make room for the
closed action item. To make things more difficult, I have conditional
formatting to grey out ever other row for reading ease. Any help would be
appreciated.

Thanks!

Now I am even more confused. You have an Open Action Items List. And you
want to put closed items on this "Open" list? Your terms either don't match
what is actually on the list or I am not getting what is going on. Can you
try to explain your scenario one more time perhaps.

"JFREE223" wrote:

Great Idea and I have that established. Before it is moved, some individuals
would like to see it on the one sheet we print out...which is the open action
items list. For ease of review, they would like to see them at the top and
then move them to the closed list after it is reviewed. I have filters
established, but again they need to see all action items on the printout.

Thanks,
jf223

"Mike H." wrote:

What if you have more than 8 items with, say, Open status. You'll be moving
a closed item into the middle of your open stuff? Doesn't make sense to me
that you would want to do this. Why not move the closed items to a different
sheet?

"JFREE223" wrote:

I have an action item spreadsheet I put together which contains a status in
column C. The status is Open, Closed, In-Progress, On-Hold, On-going (these
are part of my validation list). If the action item in the cell is "Closed"
I would like to move the entire row to row 9, without overriding what is
there. So whatever was in row 9 would be in row 10 to make room for the
closed action item. To make things more difficult, I have conditional
formatting to grey out ever other row for reading ease. Any help would be
appreciated.

Thanks!

I'm certainly not explaining it in the best manner. Let me provide a
scenario. We have a meeting every morning which includes a discussion about
open action items, as well as closed action items. The spreadsheet has two
worksheets on it...one labeled 'open action items' and the second labeled
'Closed action items.' The spreadsheet contains calendars, conditional
formatting, etc... There is a status column on the open items worksheet that
has a validation list of "open, closed, in-progress, on-hold." The user
selects the status. I've included a button at the top of the sheet that has
code behind it to move the selected row to the "closed action item"
worksheet, but the user must press this to move any closed items off this
sheet. Before this is moved to the closed worksheet, the project leader would
like to review the closed item(s) on the open action item spreadsheet...for
meeting review/status purposes. Because the closed items vary in location
throughout the list, he would like them all grouped in one spot at the top of
the page. So what I need to do is have a row move to a designated row (row 8)
each time the user selects "closed" in the dropdown box on the "open action
item" worksheet under the 'status' column. If it is filtered, then he won't
see open, in-progress, etc.. on the hard copy he hands out, without multiple
printouts. The whole process enables the PL to quickly review what closed
the previous day and then move on to all other items. After our meeting he
will select the 'Move Closed Action Items' to move it to the "Closed action
items" worksheet.

It is long, but I hope this helps.
Thanks!
jfree223

"Mike H." wrote:

Now I am even more confused. You have an Open Action Items List. And you
want to put closed items on this "Open" list? Your terms either don't match
what is actually on the list or I am not getting what is going on. Can you
try to explain your scenario one more time perhaps.

"JFREE223" wrote:

Great Idea and I have that established. Before it is moved, some individuals
would like to see it on the one sheet we print out...which is the open action
items list. For ease of review, they would like to see them at the top and
then move them to the closed list after it is reviewed. I have filters
established, but again they need to see all action items on the printout.

Thanks,
jf223

"Mike H." wrote:

What if you have more than 8 items with, say, Open status. You'll be moving
a closed item into the middle of your open stuff? Doesn't make sense to me
that you would want to do this. Why not move the closed items to a different
sheet?

"JFREE223" wrote:

I have an action item spreadsheet I put together which contains a status in
column C. The status is Open, Closed, In-Progress, On-Hold, On-going (these
are part of my validation list). If the action item in the cell is "Closed"
I would like to move the entire row to row 9, without overriding what is
there. So whatever was in row 9 would be in row 10 to make room for the
closed action item. To make things more difficult, I have conditional
formatting to grey out ever other row for reading ease. Any help would be
appreciated.

Thanks!

That helps a whole bunch. I will work up some code for you later this
afternoon but a few tidbits would help. What column is the status in. When
the PL goes to print his report, before printing, he should click the button
to move the stuff right? How about having a second button for the printing
that would also do moving for any closed items that didn't "float" to the
top. Would that be all right? We could move the stuff right after the
status is changed but I think that might confuse the users who do the status
changing so I like the approach of the button. How many columns is there
data on?

"JFREE223" wrote:

I'm certainly not explaining it in the best manner. Let me provide a
scenario. We have a meeting every morning which includes a discussion about
open action items, as well as closed action items. The spreadsheet has two
worksheets on it...one labeled 'open action items' and the second labeled
'Closed action items.' The spreadsheet contains calendars, conditional
formatting, etc... There is a status column on the open items worksheet that
has a validation list of "open, closed, in-progress, on-hold." The user
selects the status. I've included a button at the top of the sheet that has
code behind it to move the selected row to the "closed action item"
worksheet, but the user must press this to move any closed items off this
sheet. Before this is moved to the closed worksheet, the project leader would
like to review the closed item(s) on the open action item spreadsheet...for
meeting review/status purposes. Because the closed items vary in location
throughout the list, he would like them all grouped in one spot at the top of
the page. So what I need to do is have a row move to a designated row (row 8)
each time the user selects "closed" in the dropdown box on the "open action
item" worksheet under the 'status' column. If it is filtered, then he won't
see open, in-progress, etc.. on the hard copy he hands out, without multiple
printouts. The whole process enables the PL to quickly review what closed
the previous day and then move on to all other items. After our meeting he
will select the 'Move Closed Action Items' to move it to the "Closed action
items" worksheet.

It is long, but I hope this helps.
Thanks!
jfree223

"Mike H." wrote:

Now I am even more confused. You have an Open Action Items List. And you
want to put closed items on this "Open" list? Your terms either don't match
what is actually on the list or I am not getting what is going on. Can you
try to explain your scenario one more time perhaps.

"JFREE223" wrote:

Great Idea and I have that established. Before it is moved, some individuals
would like to see it on the one sheet we print out...which is the open action
items list. For ease of review, they would like to see them at the top and
then move them to the closed list after it is reviewed. I have filters
established, but again they need to see all action items on the printout.

Thanks,
jf223

"Mike H." wrote:

What if you have more than 8 items with, say, Open status. You'll be moving
a closed item into the middle of your open stuff? Doesn't make sense to me
that you would want to do this. Why not move the closed items to a different
sheet?

"JFREE223" wrote:

I have an action item spreadsheet I put together which contains a status in
column C. The status is Open, Closed, In-Progress, On-Hold, On-going (these
are part of my validation list). If the action item in the cell is "Closed"
I would like to move the entire row to row 9, without overriding what is
there. So whatever was in row 9 would be in row 10 to make room for the
closed action item. To make things more difficult, I have conditional
formatting to grey out ever other row for reading ease. Any help would be
appreciated.

Thanks!