• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Sharon Slatter

    Formula to be able to select as Hyperlink

    I have the below formula in a Contact Spreadsheet, it all works great except the cell that this formula is in displaus as an email but is not able to be selected or shown as an actual hyperlink. Does anyone know how to adapt to be able to click as an email link...
  2. Sharon Slatter

    adding to VBA Code for using Expand groups in protected mode

    Hi All, I am using the below code so I can open expanded groups of data in protected mode, is there anyway of adding to this code so that I am able to still insert Hyperlinks, I know I can click on inset hyperlinks when ordinarily protecting a sheet but to enable the expand groups I have to use...
  3. Sharon Slatter

    Formula for Passed Upcoming and Paid dates

    NBVC, Yours has worked, thanks very much for your help.
  4. Sharon Slatter

    Formula for Passed Upcoming and Paid dates

    Hi Vletm and NBVC, Unfortunately neither of these do what I need them to do, the first part with the Due, Paid Not Due Yet works fine, but it does not incorporate the Rejected and Credited parts into the formula. See attached.
  5. Sharon Slatter

    Formula for Passed Upcoming and Paid dates

    Hiya, Here is an example sheet, as you can see were it says Credit or Rejected, it is showing as paid, I want the word Paid to be replaced by Credit or Rejected.
  6. Sharon Slatter

    Formula for Passed Upcoming and Paid dates

    NBVC, Try: =IF(ISTEXT(Q13),Q13,IF(Q13<>"","Paid",IF(ISBLANK(L13),"",IF(L13<TODAY(),"Overdue",IF(TODAY()>=L13-3,"Becoming Due","Not Due"))))) That one does not work unfortunately, and it doesn't have the Credit/Rejected text in it. I wont waste any more of your time. Thank you so much for...
  7. Sharon Slatter

    Formula for Passed Upcoming and Paid dates

    I had read them, quite some time ago and refreshed myself today after this post.
  8. Sharon Slatter

    Formula for Passed Upcoming and Paid dates

    Sorry, I wasn't aware that posting on two forums was cross posting. I have also posted here https://www.mrexcel.com/forum/excel-questions/1094577-adapt-formula-include-becoming-due-paid.html
  9. Sharon Slatter

    Formula for Passed Upcoming and Paid dates

    I'm not quite sure what is meant by this, but would posting as a new thread work?
  10. Sharon Slatter

    Formula for Passed Upcoming and Paid dates

    That worked creat, I just want to ask something else of you, is there also a way of adapting the code so that if the word "Rejected" or "Credit" shows in Column Q instead of a date, can these show in Column L instead as well??
  11. Sharon Slatter

    Formula for Passed Upcoming and Paid dates

    That's great, is there any way it can be adapted so that it will still show Paid even if Column L is blank but Column Q has a date in it?
  12. Sharon Slatter

    Formula for Passed Upcoming and Paid dates

    Can anyone advise please :(
  13. Sharon Slatter

    Formula for Passed Upcoming and Paid dates

    Good Morning all, I have the below Formula which is great but I want to add to it to show, upcoming due dates (3 days before due) saying "Becoming Due" and also if a date is in Column Q then the cell that the formula is in (Column M) will say "Paid"...
  14. Sharon Slatter

    Formula for weeks weather in Excel

    Hi All, I have a spreadsheet with various data for Footfall in it, I want to be able to show a weather Icon for the weather for each week, ie, if it has been sunny, cluding and rain over a 1 week period, it would show for example. Does anyone know how to go about this or even if it is...
  15. Sharon Slatter

    Return Vlookup as a hyperlink

    Thanks but this is all beyond me, I adapted another workbook, so I have no idea what the formula do, or how to get rid of errors. Thanks
  16. Sharon Slatter

    Return Vlookup as a hyperlink

    I am sorry to say this has also not worked. Thank you for your time.
  17. Sharon Slatter

    Return Vlookup as a hyperlink

    I have done this but it is still not working. I have attached an example worksheet, maybe you can take a look at it. My actual workbook has data all the way down to 100, none of the email addresses are working.
  18. Sharon Slatter

    Return Vlookup as a hyperlink

    Hi Ankushrs1, You haven't given the formula?
  19. Sharon Slatter

    Return Vlookup as a hyperlink

    Hi All, I have the below formula but I want it to return it as a hyperlink as it looks up email addresses, can any one show me how to adapt. =IF($A3="","",IF(INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1)="","",INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1))) Thanks Shazz x
  20. Sharon Slatter

    Conditional Format next 5 days

    Hi All, I am using =AND(F1>TODAY(),F1<=(TODAY()+5)) to conditional Format within the next 5 days, but it is not highlighting the todays date, does anyone now how to adapt this formula to include this? Thanks Shazz
  21. Sharon Slatter

    VLookup Supplier Names

    Hi All, I want to be able to click on a Supplier in the drop down menu on the PO Tab and all the address details are pulled through onto the cells under the supplier name, I know this is possible but I cant work out how to do this. Can someone help at all?? Shazz x
Back
Top