Formula for moving a row into another section of the Worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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
 
Back
Top