M
mtnone
I am pulling data for certain cells on another sheet. It is every 7 cell
that I need from one column of about 1000 rows. When I work on a
referencing the cells I am unable to properly autofill.
For example
I enter =i5 in a cell and =i12 below that that cell and then autofill
then next cell and get =i7, instead of =i19
How can I set this up to count by sevens so when when I fill I am able
to reference i5, i12, i19, ect without typing everything in by hand?
Thank you.
that I need from one column of about 1000 rows. When I work on a
referencing the cells I am unable to properly autofill.
For example
I enter =i5 in a cell and =i12 below that that cell and then autofill
then next cell and get =i7, instead of =i19
How can I set this up to count by sevens so when when I fill I am able
to reference i5, i12, i19, ect without typing everything in by hand?
Thank you.