LinkBack URL
About LinkBacks
I need to repeat the following rows and formula with column a starting at 9150 and going through 15,000 in 50 point increments. Can anyone help me with a formula I can copy and paste easly. Please see the attached example.
Thanks!
I need to repeat the following rows and formula with column a starting at 9150 and going through 15,000 in 50 point increments. Can anyone help me with a formula I can copy and paste easly. Please see the attached example.
Thanks!
Last edited by oldchippy; 10-28-2008 at 07:25 PM.
Just select A2:A3 and drag down the fill handle.
Entia non sunt multiplicanda sine necessitate
Hi,
Make use of absolute references, i.e.
C3 =$C$2-G3
D3 =$A$2/A3
Copy both down to row 5, then select A5:G5 and drag down (Auto-fill) to row 119
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
If you copy your last row down until your Column A value is the desired value, you're done.
Or are you looking for the copying to be done automatically until Column A hits 15,000? Then you would need VBA to do that and you may want to ask this in the programming forum.
cheers
Teylyn
Thanks Oldchippy that was exactly what i needed. This form and its members are the gratest. Thanks to everyone who to the time to reply! This place is grate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks