Automatically moving data

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

Guest

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.
 
=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 said:
I need to automatically move data based on a specific sort from one sheet
Click to expand...
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.
 
Back
Top