Excel 2007 : Easily adding previously formatted columns and formulas to new excel reprts

[twalton34]

This is stemming from my previous issue. So I receive this reports, although they do not include ALL of the information needed, I found to get this information I must add a couple columns, one with a formula in order to get the data I need. I run these reports hourly. Is there any way for me to quickly and easily make the changes necessary to each hourly reprt as i get these rather than manually adding the columns and formulas, and copying and pasting the cells every time i open a new report?

[twalton34]

So for a better example of the problem.

In the reports I receive there's a column with a number that represents minutes,but its just general formatting, and in another column there's a date(2/23/2011 17:03, etc..). The information i need is found be subtracting the number of minutes by the date. So first I have to add another column with the equation =TIME(,j8,0) to get the actual minute value of the 170, plus I have to add another column with a default date for the equation. Also another column for the formula which subtracts the time from the date. Is there anyway I can duplicate that process on each report i pull every hour?

[twalton34]

Actually I figured it out!!!!

All I did was copy one cell from each column I needed to transfer(Formula included). In the new excel document I highlighted the column where i needed the information inserted, and selected Insert copied cells. That created the columns, and populated the columns with the formulas needed. At that point i just copied and pasted the populated cell, into the rest of the newly created columns!