Help needed quickly PLEASE....
I have a large amount of global production data by consecutive years (column H) for a unit in a refinery. The data has consecutive production data for many individual locations. I need to add a new year for each location. I would like to copy the last year I have (2026), insert new row and paste the exact values as above then update to the new year i need (2027).
I need this asap. I would appreciate it soo much if someone can show me how to write this macro so I can do it all again later when I need to for next year! please.
I have a large amount of global production data by consecutive years (column H) for a unit in a refinery. The data has consecutive production data for many individual locations. I need to add a new year for each location. I would like to copy the last year I have (2026), insert new row and paste the exact values as above then update to the new year i need (2027).
I need this asap. I would appreciate it soo much if someone can show me how to write this macro so I can do it all again later when I need to for next year! please.