Data below

Copper Contributor

Have a file with two tabs and I would like to copy and paste the formulas from A2 to A3 the problem is that the new value for A3 is in tab Scan row 6 

1 Reply

@FJMSalgueiro 

In A2:

=CLEAN(TRIM(INDEX(Scan!$A:$A,5*ROW()+COLUMN()-5)))&""

Fill down, then to the right, or vice versa.