Copying formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi guy

Cell B1=A
B2=A
B3=A

How can I copy and paste this down the column so that B4=A6...B300=A30

Thanks in advance
Randy
 
Randy,
Enter this formula in B1 and fill down:

=OFFSET(B1,ROW(B1)-1,-1)

You can fill down to the bottom of the data in column A by simply clicking on the fill handle when B1 is selected. The fill handle is the black square in the lower right corner of the selected cell.

Also, I think you meant B300=A599


Good Luck,
Mark Graesser
(e-mail address removed)

----- Randy wrote: -----

Hi guys

Cell B1=A1
B2=A3
B3=A5

How can I copy and paste this down the column so that B4=A6...B300=A302

Thanks in advance!
Randy
 
I think I confused my self...
sht2!A1=sht1!a
sht2A2=sht1!A
sht2!A3=sht1!A
...
sht2!A300=sht1!599 (I was atleast closer with 598 than with 302

At any rate...Im trying to use AutoFIll by highlighting sht2!A1 and A2 and draging down but in the forlmula Im losing skipping every other cell on sht

Thanks
 
Randy,
Another option if your are having trouble with the OFFSET function.

1) Type xsht1!A1 into cell A1 on sht2

2) Type xsht1!A3 into cell A2 on sht2

3) Select both cells and drag the fill handle (black square in lower right corner of selection) down as far as desired. This should increment as xsht!A1, xsht!A3, xsht!A5, xsht!A7,...

4) With area still selected, Edit>Replace, and replace the x with =

By not using a formula to start the fill down will increment. Then you convert the text values to formulas with Replace.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Randy wrote: -----

I think I confused my self....
sht2!A1=sht1!a1
sht2A2=sht1!A3
sht2!A3=sht1!A5
...
sht2!A300=sht1!599 (I was atleast closer with 598 than with 302)

At any rate...Im trying to use AutoFIll by highlighting sht2!A1 and A2 and draging down but in the forlmula Im losing skipping every other cell on sht1

Thanks
 
Back
Top