Excel auto sorting.

[imaduck]

Hello.

I often find answers to my questions here, so I thought I'd throw one out I can seem to find a cohesive answer to
(mainly because I'm not really sure I'm looking at)

I've got a fairly complex excel doc going on. And while all the formulas are fairly simple I can't work out how to sort the last tab properly.

It consists of 50 odd scoreboards which will update as the middle tab is filled out.

I sort of have two questions regarding the same thing.

at the end of the day what I want is for those sheets to sort themselves into order (largest to smallest) and make sure they link to the column next to them when they change.

at the moment I'm copy+pasting values only and sorting them manually, which doesn't take long, but seems a bit much

Scenario 1

I know this is likely going to require macro to auto sort active data, is that an easy macro / something that already exists, or is it going to be a headache to implement

Scenario 2

adding filters for easily clickable sorts - I'd be happy with this, to be honest, but I don't know how to replicate the data from the 58th row in the first row without them constantly being linked (so the filter function doesn't do anything)



Thanks for any help

I've probably made no sense, if so I appologise

(I've had to upload to file externally as it's too big apparently)

http://www.filedropper.com/template12nocomments_1

[ChemistB]

Select your data, on the ribbon, go to the Insert Tab> Table (hopefully you only have a single header row)
The headers now automatically have a dropdown for sorting or filtering (will affect entire table)
Also, when you add rows or columns, they will automatically be added to the table. You will need to manually resort.

Does that help?

[imaduck]

This was EXACTLY what I was looking for

You are a dreamboat!

But now i've bumped into another problem.

in cells A1,B1,C1 - i have - ='Step 2 - Scoreboard'!C1 ='Step 2 - Scoreboard'!C52 and a blank cell

in D1, E1, F1 - I want - ='Step 2 - Scoreboard'!D1 ='Step 2 - Scoreboard'!D52 and a blank cell


and I need it to go on like this for about 50 cells.

the auto formula obviously doesn't catch my drift and gets it all wrong, is there an easier way than doing this all manually?

[ChemistB]

Not sure what your formulas are trying to do. Ideally, upload an example sheet (Go Advanced>Manage Attachments). Sounds like something that can be done with a complicated INDEX/MATCH or an OFFSET