Excel Import Comments


Joined
Feb 23, 2018
Messages
62
Reaction score
21
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!!???
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top