I have an array formula that only brings over rows that are not Blank It works OK until you add rows to the other sheet.
=IFERROR(INDEX('Daily Chgs'!$B$3:$B$45,SMALL(IF('Daily Chgs'!$B$3:$B$45<>"",ROW($A$1:$A$43)),ROW(A1))),"")
when rows are added the the Daily Chgs the Formula will adjust say i add 10 rows then $B$3:$B$45 Becomes $B$3:$B$55 But the rest ROW($A$1:$A$43) does not change
It should be ROW($A$1:$A$53) -
I'm Not sure how to modify this to adjust properly When it does not adjust properly it displays no information in cell.
Maybe there is another way to accomplish this?
Bookmarks