View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Andrew@RESPA Andrew@RESPA is offline
external usenet poster
 
Posts: 1
Default How do I automate moving data when....

How can I automate a row of data moving to another part of a spreadsheet when
a condition is met?
Specifically, I have a spreadsheet of open and closed cases and I want to
move rows of data to the bottom of the worksheet, below a fixed line that
says "Closed Cases" when the column titled "Date Closed" is filled in.
Thanks!