I am making my first entry into the world of Excel macros today. I need to sort two columns (say, A and B) in descending order by col B. I have three workbooks each with many individual tabs and each tab is a spreadsheet with many such paired columns that will need sorting. All tabs on all workbooks are exactly the same shape (2col x 32row). This will involve a huge amount of repetitive action, so I thought I'd try a macro.
I followed some online instructions and was able to record and use a macro I stored in my personal workbook. The problem is that while the macro worked perfectly on one tab (I was so proud of myself!), it did not work at all on other tabs in the same workbook. Any ideas? Thanks much!
Bookmarks