Need help fast-Sorting multiple tables at once


New Member
Apr 29, 2010
I am in need of a quick fix to sort 50 tables within themselves from largest to smallest quantity at the same time. At the moment I am having to go to the sort menu and custom sort the two columns by the 2nd columns header largest to smallest. Im hoping there is a way to do this in mass. I do not want them to sort within the others into one huge spreadsheet. I just need to carry over the same sorting technique to all the tables at once. Please help. Thanks!


Active Member
Nov 21, 2007
If your lucky enough to be sorting on the same column in all the tables you might be able to do this in "group mode"

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...