need VBA to arrange the data from left to right smallest to largest, please!

[estatefinds]

I have NUMERICAL data in columns ABCDE and need the data from left to right read smallest largest, please
See example on attachment,

Thank you!

[PAB]

Hi estatefinds,

Put the following formulas in the cells quoted and copy them down...

G11 =SMALL($A11:$E11,1)
H11 =SMALL($A11:$E11,2)
I11 =SMALL($A11:$E11,3)
J11 =SMALL($A11:$E11,4)
K11 =SMALL($A11:$E11,5)

I hope this helps!

[estatefinds]

Wow! that worked Great!!!! Thanks Again I appreciate your help!

[PAB]

You're welcome, thanks for the feedback.