hi, my goal for this macro is to find the column heading "invoice number" then sorting the entire or most of the spreadsheet from said invoice number column. i've tried recording it but sometimes the report will have a different amount of columns and rows, so I'm trying to use a do while/if statement to find the column heading first before it sorts. however when I run it doesn't do anything.
EDIT: I th ink I'm not implementing the option compare text correctly as well.![]()
Please Login or Register to view this content.
Bookmarks