copying formulas from worksheets

  • Thread starter Thread starter Russ07
  • Start date Start date
R

Russ07

I have a yearly accounting of expenses. The type expense in top row and the
months in the 1st column. I have a worksheet for each month and also one
called "Summary" which I have formulas in which identify which cell I want to
populate in the summary sheet. It would be nice to type 1st 2-3 formulas and
then be able to autofil the rest. If that can't be done, then take the
formulas from a workbook for the previous year and just copy the formulas.
 
First make a copy of the workbook from a previous year. Then in this copy:

Edit > Goto... > Special > Constants >
and then:
Edit > Clear > Contents

The newly copied workbook will have all the formulas, but none of the data.
 
Gary...thanks for working w/ me on this.

I did what you suggested but there is a reference to the 2007 workbook
file....called "RE Expenses 2007.xls". I'm creating the 2008 workbook called
"RE Expenses 2008". I really need a mass edit of the file name that comes up
in each cell to correct 2007 to 2008. The sheet I'm working on is called
"Summary". It draws data from each sheet (Jan, Feb, Mar, etc).
 
Russ07 said:
Gary...thanks for working w/ me on this.

I did what you suggested but there is a reference to the 2007 workbook
file....called "RE Expenses 2007.xls". I'm creating the 2008 workbook
called
"RE Expenses 2008". I really need a mass edit of the file name that comes
up
in each cell to correct 2007 to 2008. The sheet I'm working on is called
"Summary". It draws data from each sheet (Jan, Feb, Mar, etc).
Click to expand...

Find and replace. Find 2007, replace with 2008....
 
Back
Top