Copy formulas to next month

Giganews Newsgroups
Subject: Copy formulas to next month
Posted by:  Jennifer
Date: Wed, 2 Jul 2008

I have columns for each month of the year.  I entered formulas into January
and I need to copy the formulas to February.  The problem is the formula
isn't the same for the entire column (so I can't just drag all the way down)
and I need to change the worksheet from which it gets the information.  Is
there any way to do this all at once?  I have about 75 different worksheet to
do this to and it took about a day to just get the formulas into each sheet
for the first month.

Replies