Copying every 3rd cell across.

Hi Richard,

Thank you for getting back to me. I have re-uploaded the spreadsheet with a few pointers to explain (see attached) , hopefully its bit more easier to understand. Looking at the spreadsheet I want those highlighted in red (every 3rd cell, colmun b) under the before banner to be copied across from info column to date column a. I have duplicated the data entries under before, then the same data is pasted in after just show its the same data and I just need to extract every 3rd cell in column e to column d, contents only , but I have manually copied the data and placed in where I need it, in the date column as a example. Hopefully the arrows help.

Let me know if I articulated this properly

Thanks

Sorry but I don't understand what you mean at all.

Please show a before and after situation and clearly explain how you get from one to the other. i.e. the steps and rules you have followed.
At the moment I just don't know what you started with.

Try

in D4

=IF(MOD(ROWS($1:1-1),3)=1,INDEX($B$4:$B$18,INT((ROWS($1:1)-1)/3)*3+3),"")

in E4

=IF(MOD(ROWS($1:1-1),3)<>0,INDEX($B$4:$B$18,ROWS($1:1)),"")

copy down

I am sure there is better 365 solution!

Maybe a dynamic array:

=LET(d,B6:B19,i,B4:B17,dr,IF(LEFT(d,7)="Updated",d,""),ir,IF(LEFT(i,7)<>"Updated",i,""),CHOOSE({1,2},dr,ir))

It seems that you would like cell B3 to display: updated: 14.03.22 and cell B6 to display: Updated:*14 March 2022.
Note that if you were to put a formula into cell B1 and drag down it would erase the text in cells B1:B2, B4:B5 etc.
For Example 2, cell B3 could simply be populated using =A1, now select cell B3 and press the Ctrl + c keys.
Now you can select cell B6 and press the Ctrl + v keys which would automatically paste =A4 into cell B6.
That said a VBA solution like BSB's may be a better choice, although I know so little about VBA I may be mistaken.