# Thread: Is there a Formula that will fill data into every 2nd cell? Thanks: 0 Likes: 0

1. ## Is there a Formula that will fill data into every 2nd cell?

Hi

I am trying to take data entered from say B3:D3 and use a formula so that it will post into every 2nd cell on a different worksheet.

So it would post to C7, E7, G7 etc

Is this possible

Thanks
Sinead   Reply With Quote

2. ## Re: Is there a Formula that will fill data into every 2nd cell?

Bạn kiểm tra số Cột này:
Công thức:
= IF (MOD (COLUMN (), 2), 1, "")  Reply With Quote

3. ## Re: Is there a Formula that will fill data into every 2nd cell? Originally Posted by Sineadd Is this possible
Hi, you could try this in C7 copied across - change the sheet name as appropriate.

=IF(ISODD(COLUMNS(\$C7:C7)),INDEX('Sheet1'!\$B\$3:\$D\$3,ROUNDUP(COLUMNS(\$C7:C7)/2,0)),"")  Reply With Quote

4. ## Re: Is there a Formula that will fill data into every 2nd cell?

Thank you so much this works perfect   Reply With Quote

5. ## Re: Is there a Formula that will fill data into every 2nd cell? Originally Posted by FormR Hi, you could try this in C7 copied across - change the sheet name as appropriate.

=IF(ISODD(COLUMNS(\$C7:C7)),INDEX('Sheet1'!\$B\$3:\$D\$3,ROUNDUP(COLUMNS(\$C7:C7)/2,0)),"")

Thank you this worked perfectly   Reply With Quote

## User Tag List

2nd, cell, data, formula, post 