Auto Sorting

[isuryd]

Hello,

I have a spreadsheet that has a main tab that pulls data from two different tabs. The main sheet has VLOOKUP formulas to pull data from the other tabs to give me a sole tab in which all the data is visible.

I would like to auto sort the C column in descending order, but have not found a macro or formula that works for what I'm looking for.


My main tab looks like this:

[TABLE="width: 332"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD]Employee ID[/TD]
[TD]Employee[/TD]
[TD="align: center"]CPH[/TD]
[/TR]
[TR]
[TD]10101[/TD]
[TD]John Doe[/TD]
[TD="align: center"]275[/TD]
[/TR]
[TR]
[TD]10102[/TD]
[TD]Jane Doe[/TD]
[TD="align: center"]180[/TD]
[/TR]
[TR]
[TD]10103[/TD]
[TD]Bobby Doe[/TD]
[TD="align: center"]176[/TD]
[/TR]
[TR]
[TD]10104[/TD]
[TD]Craig Doe[/TD]
[TD="align: center"]168[/TD]
[/TR]
[TR]
[TD]10105[/TD]
[TD]Lindsay Doe[/TD]
[TD="align: center"]163[/TD]
[/TR]
</tbody>[/TABLE]


I need to sort the data by the CPH (c) column, which has a VLOOKUP formula in it, in descending order.

Is this possible since column C's data is showing using a formula and it's not a concrete number?

 

[Muhammad_Usman]

Welcome to Board!

It seems difficult may be expert have solution of this! but my suggestion in this regards is to copy your actual data paste values and then sort according to column c. Its all done by a macro!