Excel auto sort?

dcdz78 · 01-15-2008, 05:10 PM

Hello,

This may be simple or impossible, I am not sure but I was wondering if there was a way to make, say, column C, automatically sort alphabetically when I open the spreadsheet. I wasn't sure if this was possible so I just thought I would ask.

Thank you in advance!

Dale

**Jack.Sparrow** · 01-16-2008, 05:01 AM

I don't think it's possible to do that when you open the file, but it's a one click process once you do open it.

**Glaswegian** · 01-16-2008, 06:11 AM

You would need VBA code to do this, as part of the Workbook Open Event. It's fairly straightfoward - post back if you need help with this.

01-15-2008, 05:10 PM	#1 (permalink)
dcdz78 Registered User Join Date: May 2007 Location: Eugene Oregon Posts: 41 OS: Vista Ultimate Edition	Excel auto sort? Hello, This may be simple or impossible, I am not sure but I was wondering if there was a way to make, say, column C, automatically sort alphabetically when I open the spreadsheet. I wasn't sure if this was possible so I just thought I would ask. Thank you in advance! Dale

01-16-2008, 05:01 AM	#2 (permalink)
Jack.Sparrow Resident Pirate Join Date: Jan 2007 Location: Qld, Aus Posts: 17,867 OS: XP SP3/Vista SP1 My System Blog Entries: 6	Re: Excel auto sort? I don't think it's possible to do that when you open the file, but it's a one click process once you do open it. __________________ //PC Wizard//Speedfan//Can you run it?//Posting Screenshots//Posting System Specs//Donations//

01-16-2008, 06:11 AM	#3 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,413 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Excel auto sort? You would need VBA code to do this, as part of the Workbook Open Event. It's fairly straightfoward - post back if you need help with this. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner