Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Make Excel 2010 Automatically Organize by Column "A" with Header

03 Jan 2014   #1
codyjacks

Windows 7 Home Premium x64
 
 
Make Excel 2010 Automatically Organize by Column "A" with Header

Hi all,
I'm working on an excel spreadsheet for my passwords. My columns are labeled website, username and password, respectively. I know how to go to data>sort to sort what I have so far, but is there a way for me to be able to put a new website, username and password at the bottom of the list, and it automatically go to where it should (alphabetically) go based on the website column (username and passwords are not alphabetically organized; just website)?
Thanks in advance,
Cody


My System SpecsSystem Spec
.
09 Jan 2014   #2
TanyaC

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

Unfortunately not an easy task.

There are ways to accomplish this automatically with data of fixed dimensions, but I have not seen any way to do this, especially with a growing list.

A couple of examples of scripts to do this are here... Auto Sort A List by Values in Excel
My System SpecsSystem Spec
09 Jan 2014   #3
codyjacks

Windows 7 Home Premium x64
 
 

Hmph. That's too bad. What do you mean by data of fixed dimensions? I know how to sort a list of data by selecting it and applying a command to it... But that doesn't do it automatically. Is this what you mean? I simply want it to automatically sort by one column, as opposed to multiple as described in the link. Also, would this code change effect all excel spreadsheets I make in the future? Or just the one I was working on when I applied the code?

I understand that this is something that would ordinarily be done by a company who firstly NEEDS it done, and pays an expert to do it... But I'm really not one to accept limitations handed to me, and I WANT to customize my computer however I see fit. Haha.

Thanks for your help!
My System SpecsSystem Spec
.

09 Jan 2014   #4
TanyaC

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

Even though you want to sort by one column, you will be sorting multiple columns of data.

Fixed dimensions means the number of columns and rows remains the same. If you add rows to the dataset then you have a "growing" or "variable" dataset. In such a case, you would have to modify your VBA code to include the new rows.

You could create the script to include a number of blank rows, but remember excel sees blank rows as valid data and will place them first, before other data.

You could then create a second sheet that compresses out the blank lines on the sorted sheet, and you would have have what you wanted. I'm not aware of you level of excel expertise, but to do this would require a moderate level of knowledge. (Using INDEX, ROWS and other such functions)

Headers are easy. You simply freeze the panes on the first row below the headers.

You can also use auto filters as headers.
My System SpecsSystem Spec
Reply

 Make Excel 2010 Automatically Organize by Column "A" with Header




Thread Tools




Similar help and support threads
Thread Forum
BSOD - Happens randomly. "Bad Pool Header", "DRIVER_VERIFIER"
Hi everyone, I recently have noticed more and more BSODs. I had this problem about 6 months ago and was able to track it down to drivers that came from Daemon tools. I cleared all that out and it fixed the issue. I don't think these new BSODs are related but they might be. This seems to be...
BSOD Help and Support
Excel 2010 "File In Use" notification doesn't show
Hello! We have shared folder on server that specific users can open it. In that folder there are bunch of excel files that they need to fill in. Problem starts when one user opens the document and starts filling the excel file, in that moment other user opens the same excel file but doesn't get...
Microsoft Office
How to edit/delete "Comments" in Excel 2010 Starter?
I'm working with a 1997-2003 Compatibility View spreadsheet in Excel Starter and I use Comments (the little windows to pop-up when you hover the mouse over a cell) throughout. I don't see how to edit or delete them, when I right-click, it only gives me "show/hide" them. Thanks!
Microsoft Office
BSOD "Bad Pool Header" and "Page In Nonpage Area" Runs in Safe Mode
Hi, I am having a problem with my newer computer, I just got this rig a few months ago and never had a problem until last Thursday. It Blue Screened on me while I was installing ARC GIS 10.1. From then on it randomly crashes. (I have previously installed ARC GIS 10 and never had a problem.) I...
BSOD Help and Support
Random "Bad Pool Header" and "System Service Exception" BSODs
I have been getting these "Bad Pool Header" and "System Service Exception" BSODs for about a day now (the "Bad Pool Header" one tends to pop up more often then the other btw). I ran a registry cleaner which didn't work and ran memtest this morning and it showed that my memory was fine. The BSODs...
BSOD Help and Support
Need "TO" column to show in Outlook 2010
Hi all, new to SevenForums as of today. First of all, I am speaking of my Outlook Inbox, not messages. My Inbox currently has columns for "From", "Subject", "Received" and "Size." My question is: Can I have a "To" column show in my Inbox? Yes, all emails I receive are to me, but I hate...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 18:56.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App