Copying fomula down...

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

Guest

I have the following:
cell G1 = A2
cell G2 = A4
cell G3 = A6

Is there a way to have this go all the way down the column. I know if the
cells equaled A2, A3, A4 I could just drag it down but it doesn't work in
this case. Any ideas? Thanks
 
Actually this is what the exact cells are:

G1:=ODDS!C2
G2:=ODDS!C4
G3:=ODDS!C6

How would I alter the formula you provided me with in this case? Thanks.
 
Try:

=INDIRECT("ODDS!C"&ROW(1:1)*2)

HTH
JG

Jambruins said:
Actually this is what the exact cells are:

G1:=ODDS!C2
G2:=ODDS!C4
G3:=ODDS!C6

How would I alter the formula you provided me with in this case? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top