Add Button in Excell to sort Data

J

jeanlafleur

Hi There,

I have a spreadsheet that I need to add a button to sort certain cells
I cannot figure it out. I would appreciate it if someone could hel
me out.

MFR. SKU DESCRIPTION CONDITION PRICE
¥
PHONES
TIE 10864 UAT 24-Line Refurbished $65
TIE 15311 BCP 24-Line Refurbished $70
NORTEL NT8B27 T7316E telep Unused $39
NORTEL NT8B26 T7208 Telephone Unused $15
MITEL 9115 Superset 420 Dk Refurbished $69
MITEL 9184 Superset 4DN Refurbished $70

COMPONENTS
NORTEL NTAB98 Call Pilot 100 Unused $100
NORTEL NTAB24 Call Pilot 150 Unused $129
MITEL MC-33A DNIC Line Card Refurbished $225
MITEL MC-330 DNIC Line Card-2 Refurbished $325

SYSTEMS
TIE 16x48x8 System: Refurbished $195
NORTEL Norstar (CICS): Unused $169
MITEL 9104-5 SX-50 8x48 Refurbished $260


The button is the arrow between MFR. and PHONES. When the user click
on the arrow the spreadsheet has to be sorted by price but do not leav
PHONES or COMPONENTS or SYSTEMS.

Ideally when it is ascending sorted, the arrow should point down; whe
it is descending sorted, the arrow should point up. We may need t
arrow buttons for this.

When I preview the post, there is no delimiter. To view it better cop
and paste the data to Excel.

Thank you in advaced for your help
 
Top