VBA for excel question [Closed]

Report
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
-
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






1 reply

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!