Import 21 Excel tables without losing the formatting

[Frederik_Rier]

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

[#2]

@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.