Search:

Type: Posts; User: exceluser9; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    22
    Views
    5,197

    Re: How can become MrExcel MVP

    Does mvp get paid? If so how? And what are the criteria?
  2. Re: Sending emails from excel based on row - Urgent

    Thank you so much Dante.

    Appreciate your support :)
  3. Re: Sending emails from excel based on row - Urgent

    Hi Dante,

    I tried the code which you gave but row 1 it wasnt copying. Hence, i have changed to below and it works fine now

    sh.Range("A1:BA" & lr).AutoFilter Columns("BA").Column, Ky
    ...
  4. Re: Sending emails from excel based on row - Urgent

    Hi Dante,

    Yes it works,

    But I have headers in row 1 and 2.

    Please could you amend code at below line to tick the blank as well so it picks header.

    sh.Range("A1:BA" & lr).AutoFilter...
  5. Re: Workday formula required based on depending dates

    Thank you so much Eric :)

    Appreciate your support.
  6. Re: Sending emails from excel based on row - Urgent

    Do I have to enter cc email address in place of wcc? And where do I enter from email address will it be picked from column E?

    dam.cc = wcc
  7. Re: Sending emails from excel based on row - Urgent

    Thanks Dante

    Where do I enter CC email address as well and in column "E" will have different generic email address can outlook use that as from email address?

    Can outlook also pick signature?
  8. Re: Sending emails from excel based on row - Urgent

    Ok I will try

    Also i want to enter CC email address as well and in column "E" will have different generic email address can outlook use that as from email address?

    Can outlook also pick...
  9. Re: Sending emails from excel based on row - Urgent

    It says

    we cant do that at a merged cel
  10. Re: Workday formula required based on depending dates

    Thanks Eric, it works, appreciate your help.

    Quick question can the holiday list be added? so that the workday calculates after the holiday date in case i need in future?
  11. Re: Sending emails from excel based on row - Urgent

    Hi Dante,

    I have tried the code and im receiving error message as runtime error 1004 stating we cant do that at a merged cell from sh.Range("AA:AA").ClearContents and it continues

    In my sheet...
  12. Re: Workday formula required based on depending dates

    Hi Eric,

    Also I require one more formula for a different data where there is one more addition i.e Logo S. Where the workday calculation for it should happen once the completed date for
    "Number"...
  13. Re: Workday formula required based on depending dates

    Hi Eric,

    It works. Thank you so much

    Appreciate your support :)
  14. Re: Workday formula required based on depending dates

    2/1/1900 was displayed when i used your formula. I have input the dates manually now to give you examples.
  15. Re: Workday formula required based on depending dates

    HI Eric,

    Please ignore post 18 for now, its a formula for new requirement and i will update it with details once this task is completed.

    Below is the example for post 17 with completed date...
  16. Re: Workday formula required based on depending dates

    Also I require one more formula for a different data where there is one more addition i.e Logo S. Where the workday calculation for it should happen once the completed date for "Number" is found...
  17. Re: Workday formula required based on depending dates

    HI Eric,

    Apologies, I think there is a miscommunication. Workday calculation for "Number" should be populated only if 6 tasks are completed out of 7. Also workday calculation for "Number" is...
  18. Re: Workday formula required based on depending dates

    Hi Eric.

    Nope, temp is not equivalent to Form. Temp is equivalent only to Agreement. Date for agreement should be populated only if temp has a completed date, if not it should remain blank.
    ...
  19. Re: Workday formula required based on depending dates

    Hi Eric,

    Also i have noticed that for SL# 18134 the date for Number is no populating once 6 task is completed. Is it because Form is not part of...
  20. Re: Workday formula required based on depending dates

    Hi Eric,

    I tried the formula but for SL# 18137 on Agreement its gives the date even before the task for Temp is completed. It should be blank, could you help. Thanks in advance

    For SL # 18134...
  21. Re: Sending emails from excel based on row - Urgent

    Hi,

    I require below data in attachment.

    Workbook 1


    <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
    ID
    From
  22. Re: Sending emails from excel based on row - Urgent

    Hi Dante,

    After each filter based on user and email addess the visible cell data should go into the new workbook
  23. Re: Workday formula required based on depending dates

    Hi Eric,

    I tried the formula which you gave and I have removed the duplicates. But for agreement in SL# 18134 comes as blank in workday calculation. It should display next workday if the depending...
  24. Re: Workday formula required based on depending dates

    Hi Eric.
    I'm really sry duplicate in 18134 (Document) is my mistake. There won't be duplicate in data.
  25. Re: Workday formula required based on depending dates

    Hi Eric,

    Thank you, your assumption on 6 task calculation is correct.

    Formula works fine but when i delete any date in task completed every workday calculation goes blank. There should be blank...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4