Make sure the columns have headers and create a Pivot Table? Or do you mean
something else?

"Freddy" wrote:

I have a table of columns, some titles, others costs.

Think I may need to email the files to someone to better demonstrate it.

Is it possible to create a macro button that will create an additional sheet
that summarises all the headings in column 1 and sums their respective costs

Then another button on the new sheet that will export the data into a
template in their correct columns.

I would greatly appreciate anyone's help