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.
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.