Hello from Steved

How would I go about putting the below into VBA please.

=IF(ISNUMBER(SMALL(IF($S$6:$S$106="","",ROW($S$6:$ S$106)),ROW(1:1))),INDIRECT("Summary!"&CHAR(COLUMN ()+64)&SMALL(IF($S$6:$S$106="","",ROW($S$6:$S$106) ),ROW(1:1))),"")

Thankyou.