automatically add to cell formula

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

Guest

Here is my question:

1 2 3 4

$1.15 $1.17 $1.59 $1.43

'Data'!$G11 'Data'$G33 'Data'$G55 ????

I want to be able to automatically drag my formula across....each time
adding 22 to the cell reference.....so the next cell formula above would be
'Data'$G77...?
Right now I am doing this manually....any ideas?
Thanks
 
Thu, 23 Aug 2007 16:24:00 -0700 from Tim Elhatton
1 2 3 4

$1.15 $1.17 $1.59 $1.43

'Data'!$G11 'Data'$G33 'Data'$G55 ????

I want to be able to automatically drag my formula across....each time
adding 22 to the cell reference.....so the next cell formula above would be
'Data'$G77...?
Click to expand...

If Data is the name of other worksheet, then you forgot a bang mark
(!).

=indirect("'Data'!$G" & 22*col()-11)
 
Thu, 23 Aug 2007 20:41:45 -0400 from Stan Brown
Thu, 23 Aug 2007 16:24:00 -0700 from Tim Elhatton


If Data is the name of other worksheet, then you forgot a bang mark
(!).

=indirect("'Data'!$G" & 22*col()-11)
Click to expand...

Gary's and I posted nearly the same thing, except that I should have
said column() and not col().
 
For some reason.....I can't get this to work....I will try and explain in
more detail and see if you can help me....I think we are close. Here is the
situation:
Sheet 2 is below
Q1 Q4 Forecast
7.090909091 0 28.52 (start at this cell)
12.52554745 0 12.58333333
0.878205128 0 0.874418605
0.02295082 0 0.02 (grab this one next)
0.566115702 0 2.267011197
6.487603306 0 25.33103646
0.157024793 0 0.38 (grab this one next)
0.120920746 0 0.118078061
0.081876457 0 0.085529097
1.107512319 0 1.15 (grab this one next)
Sheet 1 is below
Client Client Client Client
1 2 3 4
$28.52 $0.02 $0.38 $1.15

Sheet 1 draws information from sheet 2.
The results I want on Sheet 1 are shown above:
$28.52..$0.02 etc...
Your indirect I think will work...but it does not start at the top of Sheet 2.
Any chance you can help?
Thanks
 
Hi there,
Can you please have another look at my 2nd post.....I am still having a
tough time getting what I need done....Thanks
 
Could you have another look at my 2nd post....I am having a tough time
getting this done. Thanks
 
Sun, 26 Aug 2007 13:30:02 -0700 from Tim Elhatton
Could you have another look at my 2nd post....I am having a tough time
getting this done. Thanks
Click to expand...

Sorry, my crystal ball is in the shop. What is "this", what are you
trying to accomplish, and what have you tried?
 
Back
Top