John Calder wrote:
Hi

I run Excel 2K.

I have one column and 500 rows of data on one sheet. On another sheet I
want to have a formula that is in every 3rd row which reads each of the
entries in the first sheet.

I can do this manually of course, however when I try to copy it down the
sheet the cell references are all wrong because I am jumping 3 rows at a
time. Is there a formula that will allow me just to copy it down in 3 cell
increments but have it refer to the sequential cells in the 1st sheet.


Thanks

Probably yes, but how to do it depends on the formula you are using and
possibly the specific design of both sheets.

Let's start with the basics: /What exactly/ are you trying to accomplish
on "another sheet"?