I hope I can explain this clearly.

Assume in COLUMN-A I have data from ROW-1 through ROW-500

In COLUMN-B, I want B1 to refer to A1; B2 to refer to A6, B3 to refer to A11
(every 5th one).

Is there an easy way to create COLUMN-B without me having to enter in 100
cells manually?

My initial thought was to create the first 3 or 4 and then select and drag
down, but that doesn't seem to work.

Thanks in advance!