I have Column headers in rows 1 and 2. I'd like have a macro sort my data (Cols A:BQ) by the value in column A. I do not need a case-sensitive sort. The number of rows will vary so I need the macro to be able to detect how many rows there are and then sort the range A3 to BQ# where # is the number of rows.
I tried to record the macro and then modify it but I keep getting errors. I currently only have 5 rows so the recorded macro defaults to BQ5, but if I add additional rows, it does not include the new rows.
Thank you for your help.