How to create macro to sort multiple tables in dynamic range?

[munnie]

Hi all, need some help with this sort macro, been trying for days to crack it. I'm trying to sort multiple tables by a single column (eg Header10) in a worksheet. Problem is the tables have fixed columns but different (dynamic) row numbers. Also for the sorting, the first row data (bolded) in each table range has to remain, ie sort from 2nd row onwards (I'm guessing that can be solve with Offset). Attached a sample data. Also can it work if more tables were to be added into the worksheet?

TestSort.xls

Appreciate if someone can help. Thanks!

[nilem]

Hi Munnie,
try it

Please Login or Register  to view this content.

[munnie]

Hi Nilem,

Thanks! It works like a charm
Just curious as to why the macro won't work if the data cells are linked (ie vlookup from another worksheet). Any reason?