Well, this is a simple operation. If you want to figure which direction a sprite should be from one position to another, you just need to compare the coordinates.
Position2.X > Position1.X => Right
Position2.X < Position1.X => Left
Position2.Y < Position1.Y => Up
Position2.Y > Position1.Y => Down
And a combination of those for diagonals if you allow them.