- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- Copying Formulas

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

- RE: Copying Formulas posted by Abode on Wed, 10 May 2006
- Re: Copying Formulas posted by Bryan Hessey on Wed, 10 May 2006