I am trying to copy subtotals in a spreadsheet that has over 20,000 rows so
that I can sort amounts highest to lowest. I am getting the following error:

Microsoft Office Excel cannot create or use the data range reference because
it is too complex. Try one or more of the following:

-Use data that can be selected in on contiguous rectangle (am doing that)
-Use data from the same sheet (am doing that as well)