Copy of a Row

S

Steved

Hello from Steved I was given by this group the Below
Formula and I require help please.

Master
=VALUE(LEFT(E1,1)) Working as it should

Sheet2, add this formula in A1
=IF(Sheet1!R1=2, ROW(),"") Working as it should

But the below formula is to copy from A1 to Q1 and
copy to sheet2 in row 1, but it does not, could you
please point me in the right direction

Then of F1 on Sheet2 add this formula
{=IF(ISNUMBER(SMALL(IF($B$1:$B$6="","",ROW($B$1:$B$6)),ROW
(1:1))),INDIRECT("M
aster!"&CHAR(COLUMN()+64)&SMALL(IF($B$1:$B$6="","",ROW
($B$1:$B$6)),ROW(1:1))
),"")}
this is an arrya formula, so commit with Ctrl-Shift-Enter.
Copy across to Q1, and down the full number of rows.


Thankyou.
 
Top