Import Comments

Excel Discussion in 'Microsoft Office' started by Simont485, Jun 4, 2018.

  1. Simont485

    Simont485

    Joined:
    Feb 23, 2018
    Likes Received:
    10
    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!!???
     
    Simont485, Jun 4, 2018
    #1
    1. Advertisements

  2. Simont485

    Becky Webmistress Administrator

    Joined:
    Mar 25, 2003
    Likes Received:
    1,359
    Location:
    Manchester
    Yup, I don't know of any formula that would achieve this unfortunately :(
     
    Becky, Jun 5, 2018
    #2
    1. 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 (here). After that, you can post your question and our members will help you out.