Hello,
I dont understand about VBA or Macros, but if there is a way of doing what i pretend i dont think itīs possible by formulas...
What i need is to auto sort the data of 5 tables in a second sheet (same document) according to the collum of name. The structure of each 5 tables is the same (code, name, price, obs). The sort must be done alphabetically according to the names in all 5 tables, it will be normal to have empty rows.
For easier understanding i made an example document, but only with 2 tables, and where i sorted the tables in the 2 sheet mannualy, just so i can "explain" my self. I want to be able to paste data in the 1 sheet, and automatically in the 2 sheet the data will sort...
Is this possible?
Thanks
Bookmarks