Formula for moving a row into another section of the Worksheet

[Scottm]

I have a worksheet with 2 Sections - Open Tasks and Completed tasks.

I want to create a forumula that checks a cell for the text "Completed" -
once completed I want the whole ROW cut and pasted into the Lower section of
the same Worksheet.

I can not figure out how to do the Cut/past and intsert part. I know how to
check the data in the cell.

Is this possible?

 

[Don Guillett]

You can't do anything with a formula except return a value. You will need a
macro. A worksheet_change event could make this fully automatic.

 

[Gord Dibben]

Formulas caqn't cut and paste anything, only return values to the cell(s) in
which they are written.

Perhaps you could write a formula that looked at a cell and if "completed" rturn
the values for the row.

i.e. In lower section in A54 enter =IF($A1="completed",A$1,"")

Drag/copy across row 54 and down as far as you wish.

Or use VBA to cut and paste.


Gord Dibben MS Excel MVP