Hello All !!

I'll keep it simple but would appreciate help.

Firstly I start with a blank sheet
In column A, I type the numbers 1 through 20, in order for 20 rows,
underneath each other, so that finally A20 = 20. I know I can use auto fill
after typing 1 and 2.

Then in column B I want to copy the A-values but by adding a step. Assume a
step of 3. Then I want;
B1 = cell contents of A1
B2 = cell contents of A4
B3 = cell contents of A7

and so on. I would like to know how to get excel to understand my pattern,
and auto fill it by highlighting.

In my real spreadsheet i have various random sales figures in Column A, and
want to copy every 7th figure into column B.

Help would be appreciated.

Many Thanks

Rajen