ATan
02-18-2009, 04:16 AM
I have a protected worksheet that I need to do sorting whenever there are new entry of data.
The sorting is always done with Column A in ascending order. The data to sort always start from row 7 down to the last row with data. There is an empty row in between another row which I use to do summation of the data. The data is between Col A to Col R.
I tried using macro recording but it mess up my data because the selection of the row to be sort took row 6 and the rows after the last empty rows which contains some summation rows. I need to make sure only from row 7 to the last row with data are sort and nothing else.
Thank you in advance for helping out.
The sorting is always done with Column A in ascending order. The data to sort always start from row 7 down to the last row with data. There is an empty row in between another row which I use to do summation of the data. The data is between Col A to Col R.
I tried using macro recording but it mess up my data because the selection of the row to be sort took row 6 and the rows after the last empty rows which contains some summation rows. I need to make sure only from row 7 to the last row with data are sort and nothing else.
Thank you in advance for helping out.