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

    Text formatting in a string

    Hi All I am trying to format text in a string. I receive this worksheet from third party and I have to print visiting cards using this information. Data received contains lot of formatting errors like upper and lower case, double space between words, which I cleared the most of it with the help...
  2. M

    Need VBA code to select Range with Real values only

    Hi All I have data in “column D” in my work sheet, which is derived by formula and now I want to select a range of cells with VBA code in “column D” after the cell “D1” of the worksheet till the last row with the Real Value ignoring the cells with formula result “Blank” below the last Real value...
  3. M

    please guide to get a shorter IF function

    Hi All I have 23 combinations from column A to E and in column G…. I want to give each combination unique number. At present I am doing it with IF function and it's working fine as I am using office 2007 but it is too long and any small mistake can be painful. Is there any shorter way to do it...
  4. M

    need help to get user form in fullscreen

    Hi All I have a Excel file with open event which hides the application and show only user form but the user form is small in size. I want the form to open in Maximized State. any help? Regards Mandar
  5. M

    How to Copy worksheet to new workbook, save as and close it?

    Hi Everyone I am using a vba code to automate the process.. In which at the end I copy the last worksheet into new workbook and close the original workbook.. Now in this code I want to add one more step i.e. saving the new workbook at the same location of original workbook with the file name as...
  6. M

    How to split text string..?

    Hi All I am trying to split the text string in to 35 characters in each line. And if the 35th character is in between a word the string should split whole word to the next column and in next column count 35 characters and again split for next column.. I am trying an array formula in first...
  7. M

    How to generate table from a range of string

    Hi all I am trying to generate the list from string values that are separated by comma in a range with the help of code But the problem is every time I have to change the code manually to get the desired list in desired column. Can it be done with single commend button click without changing...
  8. M

    Extract a list by background color

    Hi all I have a worksheet with employee’s data where some cells are highlighted. Now I want to make a new list of only rows that are highlighted with green color in new workbook. I don’t want to sort the list by color as I need the original sequence of the list. How to do it please help...
  9. M

    how to generate barcode

    Hi All I need to generate the barcode (code128) for the membership card number. At present I am generating it with the help of other software and copy paste each barcode manually one by one in the sheet. Is it possible to generate the barcode in excel itself?? Thanks Mandar
  10. M

    Batch Numbering

    Hi everyone my question is: I have an excel sheet containing membership number say 2827000001 to 2827005000 in column A now I want break it down into a batch of 100 and put the batch number in column B in front of each membership number automatically. i.e. Column A row 1 to 100 - 2827000001 to...
  11. M

    How to create a “tour for the period calendar”

    Hello I am trying to create a “tour for the period calendar” of employees please help me in this. I have Employee Number in column A Tour Start Date in column B Tour End Date in column C of sheet 1. Now in sheet 2 cell A1 is the from date and cell B1 is to date i.e. 3-May-2014 2-june-2014...
  12. M

    creating link in excel to import image in coreldraw from directory

    hi i want to print some ID Cards and i have all variable data in excel i.e. name, id no, address etc. I can print merge it in corel draw it works fine but i am not able to create image link in excel to print merge it from the directory where the photos are saved. is it possible if yes please do...
  13. M

    reorganize data

    hi i need help in reorganize my data i have a data in column A - H row 1 - 5000, we can call row-1 column A-H one record now i want to shift records in a way that row-1 column A-H record 1, row-1 column I-P record 2, row-1 column Q-X record 3; this way 5 records and then next 5 records on row-2...
  14. M

    formula for mark sheet

    hi i need a formula to determine grade of student based on marks obtained by them. GRADE A GRADE B GRADE C GRADE D GRADE E GRADE NO MIN MAX MIN MAX MIN MAX MIN MAX MIN MAX MIN MAX 80 100 60 79 40 59 20 39 1 19 0 0 STUDENT MARKS GRADE ABC 93 A How to do it please help
  15. M

    How to find first empty cell

    How to find first empty cell in a range of cells in a column from the bottom with the help of formula Please help! Col A 20 12 29 24 38 <= A8 this is the ans 28 10 Regards mandar
  16. M

    how to calculate Loan Principal Amount

    hi all I want to calculate Loan Principal Amount when i have information of Interest Rate, Monthly EMI, No of payments. i.e. Rate of interest is 18% P.A. for 5 Years (60 payments, 12 payments per year) and the EMI is 10157.38 now i want to calculate the Loan amount. can it be calculated with...
  17. M

    how to count cell that meet conditional formating

    Hi I have a problem in a spreadsheet where there is data in cell A1 to Q7000 and I have some error in some cells and colored it with the help of conditional formatting. Now I want to count the cell that contains error. In short I want to count cells that meet the condition in a range of cells...
Back
Top