Jul 01 2021 01:59 PM
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
Jul 01 2021 02:14 PM
In A2:
=CLEAN(TRIM(INDEX(Scan!$A:$A,5*ROW()+COLUMN()-5)))&""
Fill down, then to the right, or vice versa.