Autofill by increment

[Guest]

Hi There
I am trying to do something which seems easy and intuitive but I can't get it to work. I would like to create a table of data from existing data on the worksheet and create a chart. I am trying to use Autofill and have the data automatically populated. I need every 20th row from the existing data.

For example,
Existing Location Data is in b9, b29, b49, etc. I would like this data to be pop'd in ar3, ar4, ar5 et
Existing acct data is in d5, d25, d45, etc. I would like this data to be pop'd in as3, as4, as5 et

(The existing data is in a form layout, so that's why it appears to be a bit all over the place)

I'm pretty bad at VB (I've been trying that all afternoon with not much luck). Also, I tried Autofill by filling in several rows and then pulling it down. I can't seem to get that to work either.

Any help the experts can provide would be much appreciated!
Thanks in advance
Ingri

 

[Frank Kabel]

Hi
enter the following formula in AR3
=OFFSET($B$9,(ROW()-3)*20,0)
and copy down
In AS3 enter
=OFFSET($D$5,(ROW()-3)*20,0)

--
Regards
Frank Kabel
Frankfurt, Germany

Hi There!
I am trying to do something which seems easy and intuitive but I

can't get it to work. I would like to create a table of data from
existing data on the worksheet and create a chart. I am trying to use
Autofill and have the data automatically populated. I need every 20th
row from the existing data.

For example,
Existing Location Data is in b9, b29, b49, etc. I would like this

data to be pop'd in ar3, ar4, ar5 etc

Existing acct data is in d5, d25, d45, etc. I would like this data

to be pop'd in as3, as4, as5 etc

(The existing data is in a form layout, so that's why it appears to be a bit all over the place).

I'm pretty bad at VB (I've been trying that all afternoon with not

much luck). Also, I tried Autofill by filling in several rows and then
pulling it down. I can't seem to get that to work either.

 

[Guest]

Es geht wunderbar!!! Vielen Dank!!

----- Frank Kabel wrote: ----

H
enter the following formula in AR
=OFFSET($B$9,(ROW()-3)*20,0
and copy dow
In AS3 ente
=OFFSET($D$5,(ROW()-3)*20,0

-
Regard
Frank Kabe
Frankfurt, German

Hi There
I am trying to do something which seems easy and intuitive but

can't get it to work. I would like to create a table of data fro
existing data on the worksheet and create a chart. I am trying to us
Autofill and have the data automatically populated. I need every 20t
row from the existing data

Existing Location Data is in b9, b29, b49, etc. I would like thi

data to be pop'd in ar3, ar4, ar5 et

Existing acct data is in d5, d25, d45, etc. I would like this dat

to be pop'd in as3, as4, as5 etmuch luck). Also, I tried Autofill by filling in several rows and the
pulling it down. I can't seem to get that to work either