Merry Christmas and happy new year...
This was great help, and has helped further my understanding. I have used it
to great effect, cheers

mike
P.S. not sure by non-volatile (does not dissppear?) approach, but this is
the code i have used.

"RagDyer" wrote:

Non-volatile approach:

=INDEX('Price List'!B:B,142+3*ROWS($1:1)-3)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Pete_UK" wrote in message
...
Use this:

=INDIRECT("'PRice List'!B"&142+(ROW(A1)-1)*3)

and then just copy it down.

Hope this helps.

Pete


On Dec 15, 11:43 pm, surfermike
wrote:
AS i drag the cell down i want it to increment by 3 .. or whatever?

eg. i manually doing each one at moment..

='PRice List'!$B142

='PRice List'!$B145



"surfermike" wrote:

AS i drag the cell down i want it to increment by 3 .. or whatever?

eg. i manually doing each one at moment..

='PRice List'!$B142

='PRice List'!$B145

"T. Valko" wrote:

You'll have to show us the formula.

--
Biff
Microsoft Excel MVP

"surfermike" wrote in message
...

i wish to copy a cell with a formula, but as i drag it down it only
increments by one

can i make it increment by 2 ? or 3? etc.

='PRice List'!$B148- Hide quoted text -

- Show quoted text -