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

    How to use Data Validation list with formulas using name range

    Ohh my god!!!:) It woks like charm!!! Excellent link, thanks allot Mr.BOBHC(EXCEL NINJA) but also having a problem in dependent data validation with dynamic data validation together, i am trying but not working together. for more information please see attachment Note:Ref. hp to ig columns...
  2. A

    How to use Data Validation list with formulas using name range

    Hello Everyone, Please anyone have an idea the problem i am facing how to resolve without using vba code. For Problem Scenario Please check attachment jgp file, now i want to do data validation list on j1 that showing 3 words (super dealer, dealer & retailer) that on selection on j1...
  3. A

    email problem from excel

    thanks to all, Now my template is working nice which i wanted but not from SecurityManager.DisableOOMWarnings = False this code. lastly i have downloaded 3rd party application (api function) and now its working cool with only one click. thanks again for support.
  4. A

    email problem from excel

    you can use this one also https://rapidshare.com/files/3801969919/Mail_Merge_updates.xls thanks
  5. A

    email problem from excel

    thanks for reply again, here is link https://rapidshare.com/files/2003985118/Mail_Merge_updates.xls or may be this one https://rapidshare.com/files/3801969919/Mail_Merge_updates.xls password for login: 123 password for code: alif.laila note: please click mail merge button in which...
  6. A

    email problem from excel

    hello everyone i have design one template in 2003 excel for mail merge and every thing is working fine but only one problem which i am getting is that when i try to send button in my excel so after completing full process give me warning message A PROGRAM IS TRYING TO SEND AN EMAIL MESSAGE...
  7. A

    Story of 3 Excel Ninjas.............

    Hello Everyone, I have seen that topic, really that presentation is very nice which shown in gif file and xls. So here i have one issue with my sales excel file which i use to send 3 different branches on weekly bases so how to generate same gif chart report using my sales data for 3...
  8. A

    Merge two excel files

    Thanks for your quick respond.
  9. A

    Merge two excel files

    Hello Everyone, I have 2 excel files, one for weekly transfer report of branches and secound for weekly sales report òf branches. is it possible to merge two excel files based on common column barcode. i just eager to know in excel because i can do this using sql query easily without any...
  10. A

    How to add a button such that button just run your macro

    Hello, very nice, But is this possible in 2003 also as i am looking in 2003 but din't find it ?? Thanks
  11. A

    Convert Week number to dates.

    Great great great Excell-ent. Many Many Thanks, Mr. Indian & Luke M.
  12. A

    Convert Week number to dates.

    Hello Everyone, For Example: If today's date is 27/march/2012, so weeknum function will show you 14th week, but is there any way to show all 14th week's dates in {workbook(1).range("A2:A8").value} field can anyone help me to solve my problem.? Thanks
  13. A

    Getting Problem, Mailmarge from Excel...?

    Hello Sir, Many many Thanks, Thats working great. Thanks again
  14. A

    Getting Problem, Mailmarge from Excel...?

    Hello, Thanks to all for that links which you provided me. and about that link i already work on it. http://www.rondebruin.nl/sendmail.htm Thanks again. but the problem is the thing which i want that doesn't mension here in that link and here in my excel file i wanted to design macro/vba...
  15. A

    Getting Problem, Mailmarge from Excel...?

    Hello, I have a 4800 email address in single excel column, so is it possible to send in outlook To: field,......?on one click of command button or something like same directly using macros. can anyone help me ? Thanks Note: Actually this excel sheet usually we use for advertisment.
  16. A

    macros code permanently enable, how......?

    Hello Mr Luke M, & Prasad dn, Thanks allot, Now its clear to me.
  17. A

    macros code permanently enable, how......?

    Hello prasad dn here the way you explain me its very nice and draw attraction. so please could you tell me how to do this. i am very need full for this. thanks
  18. A

    macros code permanently enable, how......?

    i have one excel file in which i have design some macro code but when i double click that file fistly ask the security warning with disable, enable and help tab. so is it possible....? without asking me that box i want to open excel file with macros running code how can i fix that problem...
  19. A

    How to hide or lock macros code using password..........?

    Thanks thanks thanks my friend, i wouldn't know this and its really hepl me . thanks again.
  20. A

    How to hide or lock macros code using password..........?

    I have design one excel file for tax calculation and in the file i used some macors code but i can't able to protect them so Can Anyone help me.? please. Thanks
  21. A

    Can anyone solve my excel problem?

    Thanks everyone for important and valueable comments. I have used macros for input box of both the columns. and its working very fine and good so now its fullfill my requirement now. thanks again.
  22. A

    Can anyone solve my excel problem?

    Hello............ I am working on one excel file for tax calculation purpose but i stuck on one problem. In details/Example i have a 3 column like a1 has percentage column, b1 has amount column and last/c1 column show total amount of consignment which we received, here what i want to do if...
Back
Top