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

    Hyperlink or fomula to add result in comments of a cell

    HI Team, Good evening. Need a help with Excel summary. I have few sheets like active employees, New Hire, Attrition and few more sheets. for all the sheets I have prepared a summary by updating the numbers using countif of new hire and separation as per the department. Currently What I am...
  2. Navi

    Pivot table - hide a column which reflects twice

    Hi Team, Need a help with pivot table. I have a pivot with country in row labels, active and inactive headcount as two columns. now i need to bring in active headcount % (which is active Headcount/ row total). Currently when i drop down the headcount in values twice, i get as active headcount...
  3. Navi

    Autorun macro based on changing cell value

    HI i tried the same. when dropdown is changed its not calling the macro to execute..
  4. Navi

    Autorun macro based on changing cell value

    Hi Team, Need help with the below scenario I have a datavalidation done on cell A1 and the datavalidation list has 3 different criteria and have if condition for each criteria Now when the user selects Criteria 1 from the data validation list, Macro 1 should run, and then when he changes to...
  5. Navi

    Filtering past and future months

    hi i want to run when click of a button
  6. Navi

    Filtering past and future months

    Hi vletm, Need one more help. How can i embed the macro in different files n run. because if i use the same code you provided it runs automatically.. i need to run with a click
  7. Navi

    Filtering past and future months

    HI This is working fine.. thanks a lot. i will edit the period alone. Very helpful
  8. Navi

    Filtering past and future months

    Thanks. I have attached a file where we have date from 2018 till 2022. my requirement is that, each month when i work in this file i need to filter from 2018 to next future 6 months. eg: am working in October. i need to select from 2018 date till April 2020. That is 2018 till October 2019 is...
  9. Navi

    Filtering past and future months

    Hi Team, Need a help in excel macro. I have a set of two to three years dates in a column (Mm/dd/yy format) i need to filter the last month and the next six months date... how do I do that. Please help. Thanks, Navi
  10. Navi

    Autotrigger mails based on recurring date in excel

    Any help here. i am unable to find solutions in google.
  11. Navi

    Autotrigger mails based on recurring date in excel

    its that the team is going on more with adhoc reports & adhoc becomes continuous from the next month. and hence we planned to place the file in sharedrive and they can update the base there. hence needed help
  12. Navi

    Autotrigger mails based on recurring date in excel

    Sorry for not providing the detail. Attached a sample file. I have also provided comments for column B & C. kindly let me know if further details required from my end
  13. Navi

    Filter column exculding array

    thanks this is working perfect:)
  14. Navi

    Autotrigger mails based on recurring date in excel

    Email address to be in column D and body of the mail and subject in next two columns. if a date is set for a report. excel should trigger mail on all the months when the date is getting reached
  15. Navi

    Autotrigger mails based on recurring date in excel

    Hi team, I have a data in excel. where column A has type of reports, column B has the dates (only date I., 8th ) and column c has frequency. Need a macro that if the report date is as 8th, and frequency is 2.. then macro should trigger mail to the people as reminder from 6th to 8th on all...
  16. Navi

    Filter column exculding array

    Hi Chihiro, Attached sample file as requested. Thanks in advance. Navi
  17. Navi

    Filter column exculding array

    Hi Chihiro, Thanks for the same. but still its not working. Below provided the entire code which I am using. if we have a list of 5 may be a,b c,d e. the selected array may be "C" which is in cbox. now the macro should filter and eliminate values apart from"C" in the sheets. Sub Filter() Dim...
  18. Navi

    Filter column exculding array

    Hi Team, need your help here. I have a set of data saved as array in macro and I have named the array as cbox. currently I need to filter a column with criteria which are not equal to the array value (> Cbox). Am not getting the result . please help. Below the current code. If Not...
  19. Navi

    Creating UserId and Password.

    Will be sharing the file through googledocs.. hence if they can open with network id and password also is fine. but how to connect the network password to get accepted by Excel.
  20. Navi

    Creating UserId and Password.

    Hi All, Need a help in VBA form. I have a excel with 1000 rows filled with 96 columns. there are different sales manager for whom specific rows are allotted, say for sales manager 1 we have 10 rows, for sales manager 2 we have 25 rows and so on. we will be sharing the entire excel to all...
  21. Navi

    Values based on ageing

    Bills which are created are only with month end date. for instance bill created on 28th Feb 2016 will take minimum 10 months to get paid. so after 30 days from the bill date we will have interest to be paid. hence if i calculate on october 2016 i need to know the interest rate paid from March...
  22. Navi

    Values based on ageing

    Hi, attached sample file. column A has the invoice number. B date and c amount. invoice ageing between 61-90 will have 1% interest and above will have 2 % interest. Column H is the total interest paid till March. Now what i wanted is a formula to directly give me the total of interest paid...
  23. Navi

    Values based on ageing

    Thanks for your post. My query is different. A1 has the value. eg. $ 10000 with date 11/30/16 on 31st Jan interest of 0.1% will be charged. i.e, $ 10 on 28th Feb interest of 0.2% will be charged i.e $ 20 on 31st Mar interest of 0.35 will be charged i.e $ 30 curretnly need to update a fomulae...
Back
Top