I've created some reports using a CSV file generated from a database in Excel. I've added several columns using formulas that reference other columns. I've put a good bit of work into creating the report.
I now would like to apply the same formulas that I've added to this spreadsheet to another CSV file that is very similar to the original CSV - perhaps some new columns added.
I'd like to apply the same formulas without manually recreating all of them and the additional columns. I can't figure out an efficient way to do this - I always end up retyping and creating the formulas and columns again manually.
Is there a better way to do this?