Attached is workbook. Macro1 moves columns in a certain order from the sheet1(main) to another sheet (AccountNumber)(from which print preview shows a report (AccountNumber order). Note arrangement of columns in sheet1(Main) and those that appear in the print preview. There are 11 columns in the sheet but only seven appear on print preview. This first report has seven columns in a certin order, but "account number" is now in the first column to coincide with report title "...account number order. Now I need a macro2(already done) which moves the seven columns in the same order except for first column which will be "Benefactor" and prints as in "account Number" . Macro1 was designed by a compatriot of yours and works very good. **Then there will be a third reports along the same lines except it will be entitled "Originator" with "originator" in the first column . The "sorter" macro is called toward the end of macro1 & 2. Notice that the sheets for rpt 2 and 3 (originator) are already established. Above has been accomplished. See attached file. Now rearrange in a new macro3 the seven columns so Originator is first (to be sorted on) and the others remain in their original order. Then a new sorter macro called "originator; then mcacro 3 prints preview.
Hopefully gowflow will get this assignment. ID number was 34240811 and related questions.