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

    Formatting using Macro

    Suresh, Thanks for your effort. I have downloaded your file and checked. superb! Best Regards, Vargeesh
  2. V

    Formatting using Macro

    Thanks a lot! Krishna. Thank you so much. It works very well. Thank you for your help. Cheers!
  3. V

    Formatting using Macro

    Hi Krishna, Thanks for your reply. I will check and let you know. Regards, Vargeesh
  4. V

    Formatting using Macro

    Hi, Can you please advice me for the above. Thank you, Vargeesh
  5. V

    Formatting using Macro

    Hi Suresh, I have uploaded the file and below is the path. http://www.2shared.com/file/lca1YMhS/New_folder.html The workbook "sampledata.xlsx" contains the raw data. The workbook "sampledata_FINAL.xlsx" contains the result of the raw data. Kindly advice me for further proceedings...
  6. V

    Formatting using Macro

    Thank you for your nice effort Luke. When i ran your code it was thrown an error "400". Can you please advice me. Thank you, Vargeesh
  7. V

    Formatting using Macro

    Hi All, I have to format a report on daily basis. For that I had recorded a macro and it works quiet good. But when i have less data or more data it wasn't working. My activities are as follows:- 1. Select the entire sheet. 2. Go to sort > sort by "Column A" 3. "Sort Warning"...
  8. V

    Assign shortcut key to a command button

    Hi Luke, Thanks a lot! It's working fine. Cheers!
  9. V

    Assign shortcut key to a command button

    Hi SirJB7, Thanks for your reply. My command button is on the excel sheet and for that i want to set shortcut key. Now i am using mouse to access the command button. I just wanna set a shortcut key for that. Waiting for your valuable advice. Thanks!
  10. V

    Assign shortcut key to a command button

    Hi, I wrote some code in a command button and it is working well. However, every time i needs to click it by using mouse. Can you please advise me how to set a shortcut key for the command button. It would be more helpful instead of using mouse. Thanks for your help in advance...
  11. V

    Data validation

    Hi, Sorry. One correction in the above comment. Scenario 3 is working. Scenario 1 and 2 is not working. Thanks, Vargeesh
  12. V

    Data validation

    Luke, Scenario 2 is working. Rest of the two aren't working. It is accepting "0" alone. if i enter any other digit it is throwing the error message. Eg: 099, 025, 055, etc. Regards, Vargeesh
  13. V

    Data validation

    Hi Luke, Thanks for your kind advice. The formula is working for the cell A2 alone. But i don't know how to do it for the entire column in the "Data Validation" dialog box. Regards, Vargeesh
  14. V

    Data validation

    Hi, Scenario 1: When entering data in a cell it should start with "0" and should allow upto "099". if else display an error message. Scenario 2: While entering data in a cell it should start with "0" and should accept upto 5 digits alone. if else display an error message. Scenario 3: A...
  15. V

    To identify the begining number

    Hi oldchippy,Montrey and XLinXL, Thank you for your valuable advise. It's working. Thanks & Regards, Vargeesh
  16. V

    To Link an excel sheet with Formatting

    Hi SirJB7, Montrey and Faseeh Thanks for your nice reply. Regards, Vargeesh
  17. V

    To identify the begining number

    Hi, can you help me to find out whether the number starting with "1". if else it should throw a message like "Check it". My data will be like this: 1562 1156 1365 Kindly advice me the formula.
  18. V

    To Link an excel sheet with Formatting

    Faseeh, I just tried. it works. This is the formula to get the student number in 5 digits. =TEXT(Sheet1!E2,"00000") Regards, Vargeesh
  19. V

    To Link an excel sheet with Formatting

    Hi Faseeh, There is a solution for certain things. To insert "0" in dept field (="0"&Sheet1!T2) so we can get prefix with "0". But i want to insert some formula in the linked worksheet. Can you help me how to write a formula in a linked sheet. Regards, Vargeesh
  20. V

    To Link an excel sheet with Formatting

    Hi, I have a student data i one sheet. I want to have the data in another sheet with formatting. Eg: The fields are: StudNo, DOB, Fees, DeptNo, etc. My linked sheet should have the following formatting:- Condition for StudNo: It should begins with "0".(In raw data it will not begins with...
  21. V

    Macro for Find All

    Hi, I need a macro code for the below. I have a workbook with more than 30 sheets. When i find something, it should find all and should export to a new workbook. And the workbook name should be the searched criteria. For instance: - My query is: "COM" The Process should be: 1...
  22. V

    GO TO ANY EXCEL CELL

    Hi Ashok, Steps:- 1. Just press the function key "F5". 2. Now "Go To" dialog box will display 3. Key in your cell name. For instance, A720 or H5268 like wise. 4. Press "Enter" Thanks, Vargeesh
  23. V

    To find the name

    I am using this formula =INDEX(A1:A50000,MATCH(C1,B1:B50000,0)) And if the entered number is not in the student list it should display a message like "Does not Exist". How can i insert the message in the same code.
  24. V

    To find the name

    Thank you... Have a great day...
  25. V

    To find the name

    Hello Mrzoogle, How wonderful its workig. Thanks a lot. Cheers, Vargeesh
Back
Top