Forum Discussion
Import 21 Excel tables without losing the formatting
Hello everybody, i am looking for a simple and fast way to combine my excel tables, which i have all created following the same pattern, into one big "master list". The best way would be if i...
Frederik_Rier The easiest and quickest way to combine tables is with Power Query / Get & Transform, but that will lose links / formatting etc. To keep those elements you can only really copy & paste, either manually or through writing a VBA macro of some kind.