Previous Topic Next Topic

VBA for excel question

Closed
Kimillie - 4 Dec 2010 à 04:23
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 6 Dec 2010 à 09:09
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

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
6 Dec 2010 à 09:09
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

Similar discussions

Keyboard troubles
jimbobjoe -
car -

38 responses