Dynamic sorted "view" over another sheet

[krdale]

Hi Guys,

I have position sheet with several hundred positions and different metrics per position. Each position has its own row.

To get a better overview over things I need to sort the rows based on different columns and I would prefer to do that in a separate sheet, so I retain the structure of my input sheet.

Is there an easy way to do this with VBA code? I've written a little VBA code before, but mostly functions and a few fairly simple subs.

So basically I need to :
- Copy a sheet
- Sort it first on column A then C.

And preferably this should happen "live", so that I don't have to clear the "sorting-sheet" after each sorting?

I can do this with the macro recorder(that is a manual macro, that will clear, select, copy, select paste sort), but it wont be pretty, and not very quick and clean code.

Appreciate any assistance!

 

[alansidman]

Have you considered using a pivot table? This may be the easiest way to get the desired results.

Alan