View Single Post
 
Old 11-19-2015, 03:28 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Oct 2015
Posts: 79
Officer_Bierschnitt is on a distinguished road
Default Custom sort - two header_lines?

Hi,

I want to write a macro to do some simple things on an Excel file. That Excel file comes from Crystal_reports, our main reporting tool, and it has two header_lines - in the first, there is only the report_title and the second line has the actual headers.
How can I do a custom sort on the entire table and tell Excel to consider two header_lines? When I tick that checkbox, then by default only one header_line is considered.

Thanks a lot!

Best regards,

Officer_Bierschnitt
Reply With Quote