+ Reply to Thread
Results 1 to 20 of 20

Credit note log

  1. #1
    Registered User
    Join Date
    08-30-2007
    Posts
    82

    Credit note log

    Hi Again

    i am reverting back to my log which RayUK kindly helped me with. i understand now how to pull certain information from certain places and place it it somewhere else. My new question is about formatting.

    i am adding email adresses using the vlookup formula but would like it to be formatted so that it resembles a hyperlink and opens up your email client. in the example file shown i have written my email adress which works fine but the when i click on the suppliers email it just brings up the formula.

    any ideas.

    Phil
    Last edited by Phil Walters; 09-23-2010 at 09:34 AM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Credit note log

    No attachment

    An email address normally autoformats to underlined blue & a hyperlink
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    08-30-2007
    Posts
    82

    Re: Credit note log

    i thought that to but no such look i will try and attach again

  4. #4
    Registered User
    Join Date
    08-30-2007
    Posts
    82

    Re: Credit note log

    and again for certain
    Attached Files Attached Files

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Credit note log

    You have two email addresses in one cell so Excel doesn't recognise the format

  6. #6
    Registered User
    Join Date
    08-30-2007
    Posts
    82

    Re: Credit note log

    Hi Roy

    i have changed it to just the one email address and it shows in the correct format on the suppliers sheet but not when it is pulled across.

    Phil

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Credit note log

    What do you mean "pulled across"?

  8. #8
    Registered User
    Join Date
    08-30-2007
    Posts
    82

    Re: Credit note log

    i have the three column in the suppliers sheet. the third column has a list of email adresses. i have used and modified your formula to add the email address relevant to the supplier in the cell show below email on the credit note sheet.

    You will see on the credit note that i have written my oqn email address in F4 which has formated perfectly and automatically.

    the email i need to be formated is in A9

    Thanks for your continued assistance.

    Phil

  9. #9
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Credit note log

    I thought that you meant the log sheet. Try this in A9 of the actual form

    =HYPERLINK(VLOOKUP(C16,Suppliers!$A$1:$C$60,3,FALSE))

  10. #10
    Registered User
    Join Date
    08-30-2007
    Posts
    82

    Re: Credit note log

    sorry Roy it didnt work. it just showed the formula.

  11. #11
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Credit note log

    Works for me. have you got calculation set to automatic?

  12. #12
    Registered User
    Join Date
    08-30-2007
    Posts
    82

    Re: Credit note log

    how do i check that?

  13. #13
    Registered User
    Join Date
    08-30-2007
    Posts
    82

    Re: Credit note log

    found it and yes it is set to automatic

  14. #14
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Credit note log

    Here's your example that i added the formula to
    Attached Files Attached Files

  15. #15
    Registered User
    Join Date
    08-30-2007
    Posts
    82

    Re: Credit note log

    Thanks Roy

    for some reason yours works perfectly and mine dosent so i will use yours from now on.

    thanks again for your help.

  16. #16
    Registered User
    Join Date
    08-30-2007
    Posts
    82

    Re: Credit note log

    Hi Roy

    i thought you had cracked it. i get the email address in the correct format but when i click it it says

    "Cannot open the specified file"

    any thoughts as we are so close?

    i did notice that on the email adress i have written in ie QC if you hover over the top it says mailto: and the other dosnt

    Phil
    Last edited by Phil Walters; 09-23-2010 at 09:37 AM.

  17. #17
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Credit note log

    I've looked into this but I have found the problem reported, but not solved.

    I think maybe start a new thread with "VLOOKUP email address results in error"

    Add a link to this post
    Last edited by royUK; 09-23-2010 at 09:41 AM.

  18. #18
    Registered User
    Join Date
    08-30-2007
    Posts
    82

    Re: Credit note log

    hi Roy

    I have edited the above with a problem.

  19. #19
    Registered User
    Join Date
    08-30-2007
    Posts
    82

    Re: Credit note log

    Hi Roy

    Cracked it

    i need to add mailto: before the email adress in the suppliers sheet.

    it works.

    thanks for your time

    Phil

    keep up the fight.

  20. #20
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Credit note log

    Well done, & thanks for sharing

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1