• 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. J

    Formula for find Tax Value from Total Value.

    Tax will come 43179.12556 Total Value 388612.13 and except tax value = 345433.0044 except tax calculation formula as given below. Same like a formula need to find out the tax. =A2/(1+12.5%)
  2. J

    Formula for find Tax Value from Total Value.

    I would like to find out Tax value from Total Value. Ex. Total Value = 388612.13. I want to find out 12.5% Tax Value from the Total Value.
  3. J

    macro correction

    http://www20.zippyshare.com/v/88180771/file.html Here with I attached excel sheets (2sheets) also macro.
  4. J

    macro correction

    Suppose Scheme amount = 800. I would like to give SalesRep who are present fullday and Half Day. Here 3 SalesRep Present (Worked) full day and One SalesRep present (Worked) Half Day. So from the amount of 800 need to divide each 3 SalesRep worked full day with 225 and Half Day worked SalesRep...
  5. J

    macro correction

    I would like to correct this code as details given below Scheme amount = 800 then amount need to divide to SalesRep presented and Half day presented. Suppose 3 SalesRep worked full day and 1 SalesRep worked half day, then full day worked 3 rep will get 225 each and 1 Rep will get 125. So how...
  6. J

    account statement

    Thanks its working good. Thanks a lot. Regards
  7. J

    account statement

    I could not download the file. Showing error file not found.
  8. J

    account statement

    I would like to make an account statement as per attached excel file.There is macro but not achieve the actual result.If somebody give a solution highly appreciated. Accounts Statement.xlsm http://www38.zippyshare.com/v/20664243/file.html I have foxpro code if you need I can post here for...
  9. J

    Macro Copy partywise and Datewise to new sheet

    Thanks lots.
  10. J

    Macro Copy partywise and Datewise to new sheet

    Great Job. Thank you so much.
  11. J

    Macro Copy partywise and Datewise to new sheet

    Did you see the sample file.
  12. J

    Macro Copy partywise and Datewise to new sheet

    Thank you for your kind reply, http://www73.zippyshare.com/v/43092846/file.html Sheet 2 contains sample result (2)option.
  13. J

    Macro Copy partywise and Datewise to new sheet

    http://www23.zippyshare.com/v/68417631/file.html I would like to copy to a new worksheet sorted by date wise, party wise but in different blocks. Eg. Akash Associates, Tax Exempted block - copy all transaction to new sheet in the same workbook related to Akash Associates, of Tax...
  14. J

    Macro Copy partywise and Datewise to new sheet

    I would like to copy party wise and date wise to new sheet with the help of macro. Tax Exempted Date Party Name Bill No. Amount 22/06/2012 Jackson company 3 11,573.48 22/06/2012 Primer associates 5 41,316.07 14/08/2012 Rital corporation 11 9,155.67 10/09/2012 Jackson company 19...
View older results
Back
Top