=if(something, then onething, another thing)

or possibly

=Offset(Base,Small(data,row())-1,0)
Array entered

including sheet

then drag fill

or a macro solution

Sub AutoMateDate()
' code that automatically moves data based on
' a specific sort from one sheet to another in excel
End Sub

--
Regards,
Tom Ogilvy


Paulla wrote in message
...
I need to automatically move data based on a specific sort from one sheet
to another in excel. I need help in setting it up. What I am actually
after if an "if, then" type of statement? Any help out there? Or do I need
to write a macro or something in visual basic? I don't know how to do
either.