Hello,
I have these two macro's and would like to know what each step does so I can modify them to work on other sheets. Is there anyone out there who can do this for me?
=IFERROR(INDEX(CHARTASSIGN!$C$3:$C$30,SMALL(IF(LEFT(CHARTASSIGN!$C$3:$C$30,3)<>"DR.",0,100)+IF(CHARTASSIGN!$C$3:$C$30>"",0,100)+ROW(CHARTASSIGN!$S$3:$S$30)-2,ROWS(CHARTASSIGN!$C$3:$C3)),0),"")

=IFERROR(INDEX(sheet2!$D$4:$D$74,SMALL(IF(LEFT(sheet2!$D$4:$D$74,3)<>"7,7mtg",0,100)+IF(sheet2!$D$4:$D$74>"",0,100)+ROW(sheet2!$S$3:$S$30)-2,ROWS(sheet2!$D$D4$D4)),0),"")

they are both entered with the CNTL SHFT ENter command to get the correct brackets. When coping the brackets do not follow.
Thank you
John