why do people use macros when PQ exists within Excel
They do very different things. I've got macros to add corporate branding on headers, format pivot tables how I like them, google search the value in the current cell, generate invoices and email companies their outstanding balances, etc
I have a macro that opens every file in a folder and removes any merging.