Autofill Functions....

  • Thread starter Thread starter The Boondock Saint
  • Start date Start date
T

The Boondock Saint

Can you autofill functions to the right, and have it increase the numbers...

for example... in A1 the formula would be

A1 =sheet1!$G2

And B1 is

B1 =sheet1!$G7

So I want C1 too equal

=sheet1!$G12

Ive put the $ in front of the G so it stays the same... but how do i get the
number to increase by 5 each time using autofill

Cheers
 
Back
Top