Copying Formula Issue

  • Thread starter Thread starter Clint
  • Start date Start date
C

Clint

Hello,
I'm using Excel 2003. Having an issue copying a formula with more increments
than 1. It is as follows;
I'm in sheet 2...

='SHEET1'!E1617

I'm trying to increase the E1617 by 8 for every cell I copy this formula to.
I have allot of cells to copy this to and have done it manually up to this
point. ><
Please help.
 
If you are just trying to 'fill' it into the column, then start with the
first 'copy' of it modified to
='Sheet1'!E1617+8
then in the cell below that (assuming it's cell B5 on some other sheet) in
B6 enter:
=B5+8
and fill down to increment each by 8.

If you are copying the original 'SHEET1'!E1617 to other cells somewhat
randomly, then manual alteration may be your only alternative.
 
Mike H.
Thanks!!!! Your way seems to work. I don't much understand it but as long as
it works, I'm g2g!
 
Back
Top