Looking for a formula that will copy data from one chart to another

[Longbow 44]

Hello I am looking for a formula that will copy data if it sees an (x) column T from the input table. If it does it will copy what is in the cells form B:J and paste them in output table below. See attached file for example. I guess it would help if I attach the file oops ...

[Pete_UK]

Put this formula in U3:

=IF(T3="X",MAX(U$2:U2)+1,"-")

then copy down to the bottom of your Input table. Then you can use this formula in cell B13:

=IFERROR(INDEX($B$3:$J$7,MATCH(ROWS($1:1),$U$3:$U$7,0),MATCH(B$12,$B$2:$J$2,0)),"")

Copy down and across as required.

Hope this helps.

Pete

[CheeseSandwich]

Try the below in cell B13:

Please Login or Register  to view this content.

[Longbow 44]

Thank you kindly