Excel - Formula/Programming
 

Hi,
I have a list that is sorted by a date and a true/false cell. I would like
to have these columns moved to a new sheet (which would be labeled "old")
based on the date and the value of the true/false cell being "true". For
example, if a column's row cell date is 1/8/05 and another cell in that row
is "true" than it would be moved to the "old" sheet.

Excel - Formula/Programming
 

You say "based on the date" but you don't state the date criteria.
You state "another cell in that row is "true" ". Any cell in that row? Or
some specific column in that row? HTH Otto
"Ezra" wrote in message
...
Hi,
I have a list that is sorted by a date and a true/false cell. I would like
to have these columns moved to a new sheet (which would be labeled "old")
based on the date and the value of the true/false cell being "true". For
example, if a column's row cell date is 1/8/05 and another cell in that
row
is "true" than it would be moved to the "old" sheet.