Hello all. Very new to both the forum and working with VBA. I have what I think should be a relatively easy problem. I have recorded a macro to sort on column C then sort on column A. My eventual goal is to be able to do this sort an 20 different sheets within the same workbook, but I have been unable to figure out how to apply this particular code to all the sheets other than recording the macro as I sort on each sheet. My basic code is as follows:
and I recorded doing the same thing over three worksheets here:
Whats more frustrating is I have been able to get what I need multiple other ways with other pieces of code (an array in one and this:
in another) but I can't get this copy one to work. Any help is greatly appreciated!
Derek
Bookmarks