• 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

    combo graph

    Hi, I am trying to plot a combo graph for data that includes division name, cost of quality in dollars and scrap as% of sales for yr 2013 to 2017. for example , lets say division name is Apple, Mango, Pineapple,grape, pear. I want to show cost of quality for each division for yr 2013 to...
  2. S

    Excel crashes when file with Macro is closed

    Hi, Attached file crashes every time when it is not saved and closed if there is another file open in the same excel session. it does not crashes if it is the only file open in the session or if another file is open in a different excel session. Please help. Thanks Sushil
  3. S

    macro to insert formula with if condition

    Hi, i am looking for a macro to insert formula in all of column H based on the condition that column G is not empty. formula will be if cell in column g is "DR" then value in cell corresponding in column H will be + of value in cell in column B, if it is "CR" in column G then it will be...
  4. S

    Excel crashes when i close the file having macro.

    Hi, I have a following macro in a worksbook. whenever i close this workbook and another work book is open.. excel crashes. Only time excel does not crash is if i open another excel session and if there i open macro enabled work book. Please let me know why this is happening. Thanks in advance...
  5. S

    Auto run macro when saving an excel file

    Hi, I have macro to update pivot table when save button is clicked. but the problem is if the macro is not enabled before then the macro does not auto run. is it possible to add another code to the below macro which enables the macros first and the auto runs it. Thanks Sushil Sub update()...
  6. S

    Auto run macro to keep the file shared after closing

    Hi, i have a password protected shared file where many users update their part. Most often some one always forgot to share the file and put the password back before closing the file.when it is opened next time, then file is locked and message only says it is opened by another user and it is...
  7. S

    Cell color changes whenever the cell value changes

    Hi, i have a spreadsheet where i have to update the values frequently. i want the cell color to change alternatively between 2 colors so that i know which cells have been updated. can you please help on this. Thanks Sushil
  8. S

    Copied excel chart shows hidden data after source data file closed

    Hi, i copied a excel chart with source data in a different workbook. the source data had data in some hidden colums too. Copied chart looks exactly the same as the chart in the source data file. But as soon as i close the source data file, copied chart starts showing the hidden data too. is...
Back
Top