Solved How to print after doing an Excel 2010 sort.

Dell / Inspiron 17r
May 11, 2018 at 10:49:55
Specs: Windows 10, 2.3/8
I have a spreadsheet that uses about 150 rows. I have also considering using a dynamic print routine whereby I do not need to resize the print area after rows are added or deleted before printing. (This routine uses "offset" and "counta"). After I do a custom sort and get the rows in the order I want, is there a way that I can just print the records that contain the sorted information via the dynamic print routine or does this routine need to be scrapped?

Related to this issue, is there a way that a custom sort will only show those rows that contain the sort information?

Thank you.
Brian W


See More: How to print after doing an Excel 2010 sort.

Reply ↓  Report •

#1
May 11, 2018 at 21:06:07
✔ Best Answer
I, for one, have no idea what you are talking about. I don't know how anyone could tell you if you need to "scrap" the print routine unless we know how the print routine works.

Custom sort? Again, I don't know what your process is, so I don't have anything to offer.

More detail might help us help you.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#2
May 12, 2018 at 06:30:38
DerbyDad03,

Thank you for your comments. It’s difficult to explain things I am not really sure about. After spending considerable time, I was able to figure a reasonable solution to my problem by using the FILTER function.

Thanks again for your assistance.

Brian W


Reply ↓  Report •
Related Solutions


Ask Question