Excel Import Comments

S

Simont485

Joined
Feb 23, 2018
Messages
67
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!!???
 

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

Similar Threads

Excel 2 into 1 6
Excel Help with dates 2
Trying to run excel vba code when cell value changes from empty to entered value. 1
Excel Is this possible?? 3
Excel Help needed with Excel 2007 Macro to send contents of a column to the previous column as comments. 0
Comparison of columns using Conditional Formatting 3
Excel MS Excel "IF" Logic Help Needed 1
Counting Results of Formulas 1

Top