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 could still use the complete formatting and the corresponding links and notes, which I have packed in certain places.
I am very much looking forward to your answers!
Stay healthy! 🙂
Frederik Rier
1 Reply
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.
