Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: Excel VBA to send outlook email - Modify Subject line & Fix attachments

    Works wonderful I just made a small change to pick up the non default email signature.

    Thank you for your help.
  2. Excel VBA to send outlook email - Modify Subject line & Fix attachments

    Hi Guys,

    So I am a complete novice in Excel VBA. I want to send email using Excel VBA.

    I have excel sheet in following format
    Column A - Name
    Column B - To
    Column C - Subject
    Column D -...
  3. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    Hi Akuini,

    I tried to replace Integer with Long, however still no luck.
    Strangely I could execute the old Macro on huge data. Not sure why sometimes it does not run and five overflow error.
    ...
  4. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    When I tried to run this macro on rows about 60000 rows, It ran once and in next few runs, I got an error of Overflow.

    I will try to replace "integer" with "long" as per your suggestion.
  5. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    Hey Akuini,

    While the code works absolutely brilliant, when I add a big volume, I get an error saying "Error found:Overflow"

    Any idea?
  6. Mandatory input in cell based on previous cell value

    I tried to search the forum, however did not get correct answer. Happy to get to correct link in case I missed it.

    I have a sheet in which user can select a value from drop down in column M. I...
  7. Replies
    0
    Views
    92

    VBA email from outlook - Excel pivot

    Hi,

    I went through http://www.rondebruin.nl/sendmail.htm however it did not help since I am not much familiar with writing VBA code.

    Can anyone help me with VBA to send email based on values...
  8. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    No worries. We have to live with it seems. :-)

    No sorry from your end. You have been a great help.
  9. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    Hi Akuini,

    Could you go through my last post? Do you think it is possible?
  10. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    https://drive.google.com/open?id=1IHtoe1kGYS_5_DmNxrmKuEgAYOyivKdk

    File is uploaded to Google drive.

    Few things for easy reference:-

    1. Job number - Column E
    2. Journal Type - Column R
    3....
  11. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    Okay, I will share the file with you first thing tomorrow morning.
  12. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    So there is one more column called "JournalType" (It may not be present in datasheets which I shared earlier assuming it is not relevant), a transaction should not be marked as WIP if a journaltype...
  13. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    Hi Akuini,

    A requirement has come up to modify the code to accommodate another variable. Do you think we can do this?
  14. Re: Copy Columns Based on Header matching a variable to another sheet in VBA

    I have a similar question where in I have two worksheets (Sheet1 & Sheet2) from where I need to copy + paste few columns in another worksheet. The problem is there are separate columns in each...
  15. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    Wow, This is so convenient and amazing. You are a genius!

    Thank you very much. :-) :cool:
  16. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    Yes, Header starts at row 1. So 3 Pop ups can make this code dynamic:-

    1. Select identifier column
    2. Select amount column
    3. Select column from where final out should be entered by VBA.
  17. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    So another criteria is not needed. We can surely get away without adding it.

    I was thinking to make this code dynamic one. So if I need to use it for any other data formats, I can. Is there a way...
  18. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    I would suggest wait. Let me see if we can get away without any changes. Give me time till EOD or End of tomorrow.
  19. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    Yes, you are correct however Account number identifier can make the difference. For Row number 1219, Account number is different to row number 1236. I.e. Contra by Job by Account.

    This wont make...
  20. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    I was analyzing the result and observed Job number 1312119. There is an amount 23,124 marked as contra by Macro and WIP by Manual plotting and one more same amount with reverse marking. I checked the...
  21. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    When i say gaps, it does not mean mistake. :-)
  22. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    Yes I checked the result and there are some gaps however they can be managed. If my team suggests to add another identifier along with Job number, how difficult of a task it is? I.e. Account number...
  23. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    So when I ran Sub FindWIP(), a pop up came - Total time for processing - 10 seconds.

    This was the happiest moment of 2019.

    Kudos to you for such a marvelous job done. Amazing !

    A Big...
  24. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    I used INT formula to convert to integer. I can use any other better formula. Small change in values don't matter.
  25. Re: Excel Formula/VBA-Conditional Sum to find contra from multiple entries

    So did it finish at your end? It did not finish at my end even for 4000 rows.

    Yes, you can have a look for optimisation and revert back.

    Thanks once again.
Results 1 to 25 of 58
Page 1 of 3 1 2 3