Auto-fill using values from another worksheet?

[mitts]

Cell B24:B34 contain specific data from another worksheet.

For instance, cell B24 contains the following:

=IF(N('Project List Worksheet'!C4)=0,"",'Project List Worksheet'!C4)

After I select cells B24:B34 and drag down using auto-fill I am hoping to yield the following pattern:

=IF(N('Project List Worksheet'!C6)=0,"",'Project List Worksheet'!C6)

And continue that "+2" pattern for future cells in the new worksheet instead of getting this result:

=IF(N('Project List Worksheet'!C19)=0,"",'Project List Worksheet'!C19)

in cell B39.

Thanks

[Sadath31]

use this
=IF(N(INDIRECT("'Project List Worksheet'!C"&(ROW()-23)*2+2))=0,"",INDIRECT("'Project List Worksheet'!C"&(ROW()-23)*2+2))

[mitts]

use this
=IF(N(INDIRECT("'Project List Worksheet'!C"&(ROW()-23)*2+2))=0,"",INDIRECT("'Project List Worksheet'!C"&(ROW()-23)*2+2))

Does anything go into the row() space?

My current B24:B34 looks like this (I should have included this too, sorry):

B24=IF(N('Project List Worksheet'!C4)=0,"",'Project List Worksheet'!C4)
B25=IF(N('Project List Worksheet'!D4)=0,"",'Project List Worksheet'!D4)
B26=IF(N('Project List Worksheet'!E4)=0,"",'Project List Worksheet'!E4)
B27=IF(N('Project List Worksheet'!F4)=0,"",'Project List Worksheet'!F4)
..=IF(N('Project List Worksheet'!G5)=0,"",'Project List Worksheet'!G5)
..=IF(N('Project List Worksheet'!H5)=0,"",'Project List Worksheet'!H5)
..=IF(N('Project List Worksheet'!I5)=0,"",'Project List Worksheet'!I5)
..=IF(N('Project List Worksheet'!J5)=0,"",'Project List Worksheet'!J5)
..=IF(N('Project List Worksheet'!K4)=0,"",'Project List Worksheet'!K4)
B33=IF(N('Project List Worksheet'!L4)=0,"",'Project List Worksheet'!L4)
B34=IF(N('Project List Worksheet'!M4)=0,"",'Project List Worksheet'!M4)

I have a blank row A20, and have some other cells between B21:B23.

What I want is when I grab the selection A20:D34, and then use auto-fill for the cells below to adjust from this example:

=IF(N('Project List Worksheet'!E4)=0,"",'Project List Worksheet'!E4)

to

=IF(N('Project List Worksheet'!E6)=0,"",'Project List Worksheet'!E6)

and for the ones with 5s,

=IF(N('Project List Worksheet'!J5)=0,"",'Project List Worksheet'!J5)

to

=IF(N('Project List Worksheet'!J7)=0,"",'Project List Worksheet'!J7)

Sorry
& Thanks

[mitts]

bump please.


thanks

[ChemistB]

Did you try Sadath's formula? Nothing goes in the parentheses in ROW().

[mitts]

Did you try Sadath's formula? Nothing goes in the parentheses in ROW().

When I use the autofill option, it links all cells to this result.

IF(N(INDIRECT("'Project List Worksheet'!C"&(ROW()-23)*2+2))=0,"",INDIRECT("'Project List Worksheet'!C"&(ROW()-23)*2+2))

I could be messing up somehow...

[mitts]

I attached a picture of my worksheet...I am trying to get the red-boxed items to be duplicated so they are automatically filled in from another worksheet when data is entered. The two columns to the right of the red-boxed column are all based off of the red-boxed column and I have no problem replicating those from the active sheet.

The second attachment is a picture of the other worksheet where the data is coming from

The following:

=IF(N(INDIRECT("'Project List Worksheet'!C"&(ROW()-23)*2+2))=0,"",INDIRECT("'Project List Worksheet'!C"&(ROW()-23)*2+2))

Will not work for separate row purposes I think, I am not very good at explaining it, I think the pictures will tell the story better than myself.