Copying Formulas

Giganews Newsgroups
Subject: Copying Formulas
Posted by:  kellbro (kellbro.27m00z_1147293901.4509@excelforum-nospam.com)
Date: Wed, 10 May 2006

i need help copying formulas.  i know excel assumes all references are
relative....but i don't want it to, but i also don't want them absolute
either!:confused:

For Example:
i have data in columns A-D and rows 1-10 (it's a mixture of data and
formulas) pertaining to one employee.  I copied this section 20 times
below the original (for an additional 20 employees).

Then in Row 1 and Columns E-BC i created formulas to manipulate the
data for the first employee (so all the formulas use cells A1-D10).
When i copy these formulas to Row 2, Columns E-BC the formula defaults
to the data in the cells one row below what i used for employee one.
How do I copy it and tell it to use Rows 11-20 (rather than 2-11)??

I know I can manually go in and alter each formula....but i really
don't want to do that.  any help would be appreciated.  thank you!

--
kellbro
------------------------------------------------------------------------
kellbro's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34317
View this thread:http://www.excelforum.com/showthread.php?threadid=540818

Replies