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

    numbers in one sheet

    i tried but the macro is not working.
  2. W

    numbers in one sheet

    Hi Please find the attached file. I have data in the row wise . with using of formula or through macro the number will come in the single cell followed by comma. regards Shahul
  3. W

    space issue in the data

    hi Please find the attached data which was download from the software in that there was a lot of spaces in the data. kindly guide how to remove the space. regards Shahul
  4. W

    Last Processed Details reqd

    Hi I have a raw date which contains emp code,name and Salary Processed date. It contains all the raw data. I want the formula or macro to find up to what month the salary is processed. I am attaching the sample for your reference Example 1) If the Employee A salary is Processed from Jan...
  5. W

    Formula error need to solved

    Please find the attached sample file
  6. W

    Formula error need to solved

    other references
  7. W

    Formula error need to solved

    hi ur formula is working fine if the data is continuous But if sum up the different range (not continous) it is not working I am attaching the file for your reference
  8. W

    Formula error need to solved

    Hi I have 4 datas to sum (ie Total) Mark 1 Mark 2 Mark 3 Mark 4 I want to total this 4 Marks. In that the Mark 3 has #N/A i want to show total of rest of the values. How to do that I am attaching the sample files
  9. W

    Data validation

    any other way is there without separating. becaz i have the list in one dump it contains 1000 of datas
  10. W

    Data validation

    only five 1) Admin 2) DistrictDistributor 3) SubdistDistributor 4) Retailer 5) User
  11. W

    Data validation

    Dear Kchiba for that i have to separate the retailer / distr. But i have the data base in one list.
  12. W

    Data validation

    Hi Please find the attached file. i have list of user type and owner name details in the single dump file. if i select the user type as retailer and in the next column only the retailer name will come if i select the user type as Distributor the next column only the Distributor name will come...
  13. W

    Microsoft office installation error

    Hi while installing the micrsoft office 2010 it showing the attached error. kindly help in how to solve this issue Error Text setup has detected legacy groove or microsoft groove server software on this system
  14. W

    Macro to Paste the data from Notepad to Excel

    if i run the macro i automattically ask for the path
  15. W

    Macro to Paste the data from Notepad to Excel

    k thanks. i want the macro code to select the path name automatically (Differ from time to time ie C Drive, D Drive etc). So every time i have to change the path name in the code.
  16. W

    Macro to Paste the data from Notepad to Excel

    Hi I have a folder which contains many note pad (.txt files). I want to open all notepad files one by one and copy and paste in the One excel sheet. I required the macro for the same. regards Shahul
  17. W

    how to open the excel file with file name

    Hi I have a index page in that many buttons are there. If i click the button automatically the excel file will open. i tried only the path name has been to be give like C Drive D Drive. But the Supporting files are there in the particular folder itself. If i copy the files in the DVD...
  18. W

    how open pdf using vba macro

    if i call the button or run the macro the pdf will open
  19. W

    how open pdf using vba macro

    Hi can you guide how open pdf file using vba macro
  20. W

    how to cut the particular chart

    hi can you shown the screen shot i am unable to do that.
  21. W

    how to cut the particular chart

    Hi i am attaching the data and chart. i want to cut only the green colour portion. when i trying to cut the particular portion (colour) and paste it another location. it paste the full portion and table. can u guide how to do that.
  22. W

    formula reqd

    i want the formula if the value is 3.2 then it consider as 3.5 if the value is 3.8 then it consider as 4 Regards Shahul
  23. W

    Expenses Data Formula Reqd

    Hi Somendra The Calculation is showing wrong. For the Code 40102286 the total expenses is Rs. 40146/- but in the first year it is wrongly showing as 40146/- but the correct amount is 2468/- for second year 20357/- and third year 17321/-
  24. W

    Expenses Data Formula Reqd

    can you explain about the formula I did not understad about the COLUMNS($C21:C21))))...
Back
Top