Excel Import Comments


Joined
Feb 23, 2018
Messages
66
Reaction score
24
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

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