Recent content by RonB

Hi Brian, thanks for your response. Others have also told me that the combination of autosort and linking two sheets could be a problem. I modified my code for sheet 2, which gave me the autosort, but the data did not sort properly because of the conflict between the sort orientations. I solved...

Hello I have a spreadsheet with 20 columns. The columns alternate between text and number data. Row 1 is a header row and is not sorted. The data is automatically sorted in descending order on the number columns which also sorts the text with the numbers. The sorting is done during data entry...

Hi Brian, the project changed a bit from the original request. It ended as follows: It used columns A, B,C, D,E, F,G, H,I, J,K A is a number column that is not sorted B is a name column which is sorted when C sorts C is the ranking column which is sorted in ascending order DE, FG, HI, JK...

Hi Brian, Here is the code I received from my other source. It works exactly as planned. Thanks again for your help. Private Sub Worksheet_Change(ByVal Target As Range) Dim c As Long On Error Resume Next Application.ScreenUpdating = False Application.EnableEvents = False For c = 3...

Thanks for your help MI and Brian, I tried MI's suggestions with the Macros and couldn't get them to work. I also tried to paste your code with no luck. I am completely in the dark regarding VB code. In the meantime I received another code suggestion that worked. I appreciate you help, Ron

Is there a way to automate without using a command button. I would like to sort automatically without pushing any additional buttons? I also do not know how to write VB.

Hi, is it possible to set up an auto sort function in excel 2002? I would like to have my spread sheet auto sort after each new row is complete. I would like it to sort based on the results of one column. For example: column A would contain text, column B would contain text, column C would...