Automate calculations when adding new column of data

[holdenmcgroin]

Regularly, I get a excel file with P&L monthly actuals. I create 7-8 columns at the end of the spreadsheet that does calculations based on the data that is provided. Is it possible to create a macro that will calculate the data set when I copy and paste new columns?

 

[BSALV]

The macro itself is no big deal.
The problem is, you get a new file without a macro, so where must excel find that macro ?
It has to be a "personal.xlsm" or another open workbook.

 

[holdenmcgroin]

The macro itself is no big deal.
The problem is, you get a new file without a macro, so where must excel find that macro ?
It has to be a "personal.xlsm" or another open workbook.

Is it possible to copy and paste the new data set into an existing worksheet that does have macro?

 

[BSALV]

yes, hundreds of examples here on this forum.
The file with your updates, what' the subdirectory and the name ?
Has it 1 worksheet, if not, what's the name ?
Can you show an image or with XL2BB the header and 5 lines of data ?