For a better experience, please enable JavaScript in your browser before proceeding.

The rows will, of course, be non-contiguous, so that will be the issue cheers.

In fact there is generally no need to select anything and doing so slows your code.

Im not sure what, if anything, row 51 has to do with what you are trying to achieve, but try this in a copy of your workbook.

I will try searching, but the usual suggestions of Edit and Go To to get to Special Cells section have not worked ta.

In answer to your earlier question, the data begins in A2, with headers taking up the first row.

The earlier code is not showing here as it all works fine, though may be a little bloated due to coming directly from the macro recorder, but some of the rest still has ranges which will limit the usefulness of the code, as files will come in sometimes with 7,000 rows, sometimes 10,000 and sometimes only 4,000.

The earlier autofilter parts are perfect, but the next sections after that hopefully selects all data and sorts it based on data in 3 columns A, B U.

Again the ranges are not right; A2:A6428 needs to encompass the entire column.

Do I just make those sorts of references like this A:A And the line.

Is it maybe not referring to G11 but rather an option in the DataSort menu Would you possibly mind just passing an eye over this to see what you think Thanks in advance mate.

In cell A2 if the value A then allow both positive and negative integers.

I have attached sample data, i need someone to help me convert the left side to how the data looks on the right.

Excel For Mac Autofilter