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

    Macro question or VB

    john8714 he his the « Arrogant ». He dint know the respect of people who helping to them.. what he thinks if he found solution himself what he needs and not proper reply to Mr.vletm. why to post his question to solve here in chandoo.org.and not respecting to forum rules. :(
  2. S

    Dates

    Try this; =IF(WEEKDAY(A1+1)<>7,A1+1,A1+4)
  3. S

    Run Chart as Animate by start and stop button to check the graph

    No problems sir take your own time. 7) yes its old version only i mean to say the line graph not to show the break line gaps between two values to show as continue line graph. #24 as you mentioned i noticed that y i need to check on form control button not in Activex its ok sir i try to do...
  4. S

    Run Chart as Animate by start and stop button to check the graph

    sir, i attached the one file can your modify the code. By selecting list in drop down combo box the chart i will bring to the front view. all the code are working in Active x control button combo box later i check with my company pc the active x control is not working so i need to change in Form...
  5. S

    Run Chart as Animate by start and stop button to check the graph

    sir, i became speechless after seeing your updated version file wowwwwww... mind blowing. This calculation for me very hard time to complete more than 3 months i took for all the 20 worksheets but 1 days you finish all my calculation and making me crazy sir, you really made my very happiest day...
  6. S

    Run Chart as Animate by start and stop button to check the graph

    sir, but the values 14.22 is critical and values showing below as rainfall it may be difficult to understand or may not? i need some additional requirement in chart i show the button - Run the chart. because of i have 20 worksheet to display when i select and de-select the the chart its...
  7. S

    Run Chart as Animate by start and stop button to check the graph

    Hello sir, please have a look i updated the data in your last version file without any link. 1.About Formulas 1a) Like ALPHA, BRAVO, CHARLIE Cell I20 are empty? All three alpha, bravo, chalie sheet I20 cells fields are updated. 1b) Cells D20..D384 has same formula as well few more...
  8. S

    Run Chart as Animate by start and stop button to check the graph

    Hello sir, Good morning.. please check the updated data file. 1. All the formulas are corrected and no negative values. 2. There is some Error showing like #N/A to avoid the zero value on the graph. 3. i checked your new updated version wow, mind blowing exactly this i need the same you did it i...
  9. S

    Run Chart as Animate by start and stop button to check the graph

    Sir i will update the data in this file and send you soon. 1. After 19-jan it will not come 1st jan the dates are sequence like 1-jan to 31-jan. This dates are now corrected in new file. 2. The critical values will be always 14.22 it will not change this value only to identify the critical...
  10. S

    Run Chart as Animate by start and stop button to check the graph

    sir its really super ... we can select the data by day/week /months
  11. S

    Run Chart as Animate by start and stop button to check the graph

    Hello sir, sorry for the late reply actually i am doing the date problems what you mentioned in chart now i updated the new data with corrected date chart on three worksheets this is my actually workbook. Now all the dates are in sequence
  12. S

    Run Chart as Animate by start and stop button to check the graph

    sir, step by step you impressionism me lot :)and i am lot of things learning more from you its about like god's gift. Forget to tell you what is purpose of this chart. its about the filter elements to change if high delta pressure so the target value showing in red line is constant value is...
  13. S

    Run Chart as Animate by start and stop button to check the graph

    Wow, Now chart also working perfect and additional CTRL option is very nice feature i dint expect this sir, if possible i need few changes on it. 1. when we are de-select the particular months list instead of blank white color. Turn into red color. 2. Chart can be expand by dates wise (eg:-...
  14. S

    Run Chart as Animate by start and stop button to check the graph

    Hi Vletm, Many thanks for the reply and i am so much happy that you given the first version is very nice. when i run the code the chart is not give any updating only the months are running in timer. sir, if i understand your idea correctly that which months are i select and i refresh to select...
  15. S

    Run Chart as Animate by start and stop button to check the graph

    i have a workbook which contains three worksheet name called ( Alpha, Bravo,Charlie) and each worksheet there is a chart and i display all the chart in one worksheet called All in one sheet. Now what i need to run the chart as animate of whole year data value or selecting by quarterly wise. if i...
  16. S

    Automatic send Reminder Email if Due date Approching

    There is some updated code its just working fine but It's only an issue the first times when ever run the macro. The first time when i run it, it'll generate the 15 day emails. The next time, it'll see that the 15 day email has already been sent and skip ahead to check for the 30 day email...
  17. S

    Automatic send Reminder Email if Due date Approching

    Hi SirJB7, Finally i am very happy that i got the reply thank you sir. You are right sir, i am not the author of this code i just got the guidelines sample code try to solve but Now i'am getting more clarity of work after you explained to me i will give a try to solve based on your given steps...
  18. S

    Automatic send Reminder Email if Due date Approching

    Hi, i want to send reminder email to client via outlook if due date is reaching before 30 and 15 days. once mail send to the client then date to be registered in column "H, I" of 15 and 30 days. The code which is working by separate module of 15 and 30 days working fine and i tried to make in...
  19. S

    set print area by different ranges and auto fit in pages

    Anyone try to advice some idea to get the solution
  20. S

    set print area by different ranges and auto fit in pages

    Hi, may be my question is not clear i think so i try to give some more point what i need. How can i print automatically to print different range to combine to make print preview has a landscape page view. Eg:- what i need to print two pages of worksheet. 1. first page to print together the...
  21. S

    set print area by different ranges and auto fit in pages

    Hello Teams, i have a excel sheet of leaving planning it everything works fine done by our site only now i came up for something i need to print the sheet its not cleat view of all details so i need to make it of each worksheet as two pages by selecting different ranges 1. page i need from...
  22. S

    Congrats on the shoutout from MakeUseOf.com

    wow congrats to chandoo members and teams...:):awesome:
  23. S

    conditional formatting formula to modify

    Wow, that is so amazing!! Thank you so much, it work the way I need.!! if likes can have 1000 times i can press for you sir really u made my day I hope that you have a blessed day
  24. S

    conditional formatting formula to modify

    yes correct sir what u mentioned.
Back
Top