Copying a formula problem

[Pete Provencher]

Using Excel 2000:

I'm trying to copy some information out of some data that I pasted into
excel. I want to copy certain information from one sheet to another sheet.

In my second sheet I have the following formula:

Sheet1!A6

When I copy this down one row I need the row number (6 of A6) to change to
A10. Every row that I copy down I need it to increawse by 4 (A6, A10, A14,
A18.............)

Hope that this can be done.

Pete Provencher

 

[Anders Silven]

Pete,

On way with a formula:
=INDIRECT("Sheet1!A"&ROW()*4+2)
entered on row 1 on the other sheet. You will have to adjust the "+2" in the
formula if entered on another row.

Another way is to enter "Sheet1!A6" in any cell and "Sheet1!A10" in the cell
below (without the quotes).
Then select the two cells and fill down. You will get a series like
Sheet1!A6
Sheet1!A10
Sheet1!A14
Sheet1!A18
.... and so on.
Then Edit>Replace "S" with "=S".

HTH
Anders Silven