auto sort data in one column and apply sorting to all columns

**lmonroe** · 01-02-2013, 04:51 PM

Hi All,

I have some very basic programming experience, but it hasn't been enough to help me through this problem. I have attached the sheet I am working on.

Ideally, as each person makes modifications to a row on this sheet, they will also change Column A to the number assigned to the person responsible for the next step of the process. Each time any entry in Column A is is changed, I would like the whole sheet to sort automatically (least to greatest or vice versa, it does not matter) The idea is that all projects waiting on input from each person will be grouped together automatically so each person can easily see where their time needs to be spent. The information in each row is tied together and must be kept together. The only (partial) solutions I have come up with on my own and by following other threads only auto sort columns A and B; the rest of the sheet does not change, so that isn't helpful.

My experience level is such that I know how to use/understand basic logical statements, but I do not know what a 'macro' is.

Thank you for your help!

**Charles** · 01-02-2013, 05:30 PM

HI,

I used the worksheet event code. When the user adds data to column A the macro will run.
I recorded the Sort part of the macro. This can be changed.
I tried to upload the file, but could not.
If you right click the tab BMR Export you can select View code and past the following code to it.
Use test data when you try the code.

Please Login or Register  to view this content.

**lmonroe** · 01-02-2013, 05:42 PM

Charles,

Please consider this a digital handshake. When I found this forum, I thought I would get help, but I certainly did not think it would happen in 15 minutes. Thank you very much for your help. All the best and Happy New Year.

Luke Monroe

**lmonroe** · 01-02-2013, 06:45 PM

Hi Charles,

New question for you. My document now works great and this does exactly what I was hoping it would do, but is there a way to answer this same question without using a macros? I am trying to make this document available to my team to edit in a cloud based setting, but when I have the macros enabled I cannot upload the file to Microsoft Skydrive. I tried uploading it to the Google Doc cloud computing base too and no success. I am able to upload and edit earlier versions of the document without the macros enabled to both of those sites. Any suggestions?

Thank you,

Luke Monroe

**Charles** · 01-02-2013, 09:52 PM

Hi,

Sorry to say I do not know. I do not think you can use formulas, but I'm not a formula peson.
I'll do some checking tomorrow.
Ps the code I provide does not sort completely. It only sorts the specified range in the code.
This can be modified to include the new data entry.

**Charles** · 01-03-2013, 08:18 PM

Hi,

From the info that I could find you can not do as you want with "SkyDrive" I did find this, but do not know if you can use it for what you want.

http://mail.business-spreadsheets.com/forum.asp?t=1085