HI
OK so I have a formula that pulls in cell contents based on date input.
=IFERROR(LEFT(INDEX(Sheet1!$B$3:$M$20,MATCH($A17,Sheet1!$A$3:$A$20,0),MATCH(B$4,Sheet1!$B$2:$M$2,0)),1),"")
So for any date input it will display the cell contents for that date. Of course the cell contents will be different for each date entered.
Some of the cells in the original spreadsheet (sheet 1) have comments on them.
I need to show the comments as well as the cell contents and then conditional format the cell when the comment contains N/A
VBA I guess!!???
OK so I have a formula that pulls in cell contents based on date input.
=IFERROR(LEFT(INDEX(Sheet1!$B$3:$M$20,MATCH($A17,Sheet1!$A$3:$A$20,0),MATCH(B$4,Sheet1!$B$2:$M$2,0)),1),"")
So for any date input it will display the cell contents for that date. Of course the cell contents will be different for each date entered.
Some of the cells in the original spreadsheet (sheet 1) have comments on them.
I need to show the comments as well as the cell contents and then conditional format the cell when the comment contains N/A
VBA I guess!!???
