HI
OK so I have a formula that pulls in cell contents from 2 spreadsheets into a 3rd spreadsheet 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 in a column. Of course the cell contents will be different for each date entered.
Some of the cells in the original spreadsheets) 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
I presume it will need to be VBA and VBA is beyond my skill-set!
I would like it to be in the form of a button that runs the code once the date it inputted......
OK so I have a formula that pulls in cell contents from 2 spreadsheets into a 3rd spreadsheet 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 in a column. Of course the cell contents will be different for each date entered.
Some of the cells in the original spreadsheets) 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
I presume it will need to be VBA and VBA is beyond my skill-set!
I would like it to be in the form of a button that runs the code once the date it inputted......
