I need to copy every third cell in column A to sheet2 to consecutive rows in column A of sheet2 by placing a formula in receiving cells. I cannot find a way to change the row number in the cell addresses of the formula.

Starting in row 1 on sheet2, try and pull down as needed

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

This brings forward cell A1,A4,A3,A2,A5,A8,A7,A6,A9..... .and I am seeking A1,A4,A7,A10....
Maybe I didn't describe this clearly, I need every fourth cell, with three in between the cells I need. Can you help?
Ken

Is this better ?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

This what sheet1 has on it

A1 John Doe
A2 no name
A3 no name
A4 no name
A5 Jill Doe
A6 no name
A7 no name
A8 no name
A9 Tom Doe
A10 no name
A11 no name
A12 no name
A13 Mary Doe


This is the results from the new formula =INDIRECT("sheet1!A"&((ROW()-1)*3)+1) on sheet2

A1 John Doe
A4 no name
A7 no name
A10 no name
A13 Mary Doe

Not yet the desired results

Pse post a sample sheet showing before and after

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I put the cell address in each cell with the text (a name or "no name") and this is the results from a cut and paste from sheet1 and sheet2.

No sheet attached

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I think it is attached, now.

Attached Files

TEST OF FORMULA.xlsx (10.4 KB, 9 views)

Your sheet does still not show what you want to achieve , only the result of my suggestion which is not what you need

Is it ??

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

The last had both sheet1 and sheet2, I believed.
This time I am sending file, sheet1, which is the project from which I wish to extract (copy) cells and place (paste) them on another sheet thus creating a list of names, addresses, etc.

Thanks for hanging with me and you continued assistance. It seems that there MUST be a way.

Attached Files

test15.xlsx (13.9 KB, 9 views)

Like this ?

Attached Files

test15.xlsx (14.6 KB, 10 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

YES. I am off to work on it. Thank you bunches