Can I sort a column automatically everytime I close a file

**jimmy05** · 06-07-2012, 09:12 AM

Hi,

I have one file collecting data from another spreadsheet using Lookup functions. For this to work the 'database' of information always needs to be in numerical order, which is fine. However I have a few people adding/editing data within this spreadsheet and can therefore not guarantee that it will always be left in numerical order.

I was wondering if there is a way of automating this as the file is closed? ie every time the database is closed column A is sorted A to Z?

Any ideas? I am a novice when it comes to any macros but I'm sure one of you genius's can do this!!

Thanks

Jim

**rkey** · 06-07-2012, 09:19 AM

1 open the VB Editor.

2 View the Project Explorer if not already visible.

3 Right click over the "ThisWorkbook" object. Select 'View code'.

4 In the Code page, add the following code...

Please Login or Register  to view this content.

**jimmy05** · 06-07-2012, 10:03 AM

Hi rkey,

Thanks for your help.

I have done as suggested, and when I close the file something appears to happen on the data (the data in col a flashes), but nothing actually gets sorted.

Any suggestions?

Thanks

**6StringJazzer** · 06-07-2012, 11:09 AM

The posted solution is missing one line of code:

Please Login or Register  to view this content.

The posted solution will sort only column A. That sounds like what you said you wanted but is that the only data in your worksheet? Or do you need to sort a lot of columns of data using column A as the sort key?

By the way, for the worksheet reference I would suggest deleting "ActiveWorkbook." (including the dot). In this case it probably won't cause an issue but in general depending on ActiveWorkbook (or Active anything) is risky since you as the coder don't really know for certain what is going to be active at any given time, and if code changes later it's even stickier.