VBA for excel question

Closed
Kimillie - Dec 4, 2010 at 04:23 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 6, 2010 at 09:09 AM
Hello,
I have a worksheets in which I have a set of data in range A3:A50 and B3:B50 and C3:C50 and D3:D50 until J3:J50 that come from another worksheets.where the column B to J represents the properties of the object, and column A represents the object.
I am trying to auto sort the object from the properties based on the input properties asigned in column B to J.

How can I wirte the program to sort the objects out based on the linking properties required using the VBA for excel. Any source provided for reference.
Thanks






Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Dec 6, 2010 at 09:09 AM
Hi Kimillie,

Don't know how well I understand you, but if you want to sort your data do the following:
Select your header row, goto top menus > data > filter > autofilter.
Now from the dropdown lists select anyway you want to sort your data.

If you want a VB code for this, try recording a macro.

Best regards,
Trowa
0