Multi-macro, button to sort by multiple columns

Hello programmers!

How to create a macro that will:
1. Copy Starting Sheet (A1:L2000 All formulas w/ some cell formatting.)
2. Create New Workbook
3. Paste the Values & Formatting of Starting Sheet to New Workbook, Sheet 1
4. Sort the sheet by "Column Title 1" then by "Column Title 2" then by Column Title 3." This sheet will have headers so the sort can be done by name, also the columns are static so we could use H1 then by K1, then by E1.



I know it's a bit much, but I hope to some of you Jedis out there it's a simple Death Star to stifle.

Best,

DemRulesDoe

If you record a macro of you doing this manually, what is the resulting code?

Also regarding

4. Sort the sheet by "Column Title 1" then by "Column Title 2" then by Column Title 3."

To you mean three separate sorting operations, the final one being on Column Title 3?

or do you mean a single sort, sorted by Title Column 1, with duplicate values being ordered by Column Title 2, etc.?

Except for the sorting part, I think this will do what you want.
Also, in the OP it sounds like only the new copy is to be sorted?
Or do you want both the existing Start Sheet to be sorted as well as the newly created worksheet?

Please Login or Register  to view this content.

Hi mikerickson,

This is the resulting code, it works like a charm, but I have a new problem:

Please Login or Register  to view this content.

This does everything in my original problem. Now I need to find a VBA function to paste the Values, Source Formatting and the Validation drop downs from the original sheet, all at once. If I use keyboard shortcuts w/ special paste it will overwrite one or the other. (IE: paste validation will not include values/formatting, or if I paste values + formatting it will not include validation. Doing both actions in a sequence also results in nothing.)

Tried comma separating my special paste functions with no luck:

Please Login or Register  to view this content.

Thank you for the quick response by the way!

The .Copy method in my code should have brought the validation over to the new workbook (for the cells in the indicated range)