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

Recent content by Faseeh

  1. Faseeh

    Automating a Task with VBA - Moving Data between sheets

    Thank you so much, Mark! This is really helpful.
  2. Faseeh

    Automating a Task with VBA - Moving Data between sheets

    Thank you so much for this explanation. What if I want to add more columns to right? Which part i need to adjust to accommodate more columns? I think that the following constant needed to be updated for more columns: Const C = "A1:A#&""¤""&B1:B#&""¤""&C1:C#&""¤""&D1:D#", M =...
  3. Faseeh

    Automating a Task with VBA - Moving Data between sheets

    This is working like a magic!! I am still trying to understand how it is done. :) Please explain it a little!
  4. Faseeh

    Automating a Task with VBA - Moving Data between sheets

    For now around 700 for each of the sheet but as it holds work orders, the number of rows will increase.
  5. Faseeh

    Automating a Task with VBA - Moving Data between sheets

    Hi, Thank you so much for going through the post! I am struggling with the automation of the following task. I have googled a lot but the existing macros either fulfil part of the total requirement or are not working for me (somehow). I have two sheets: 1. Source 2. Ledger. I am trying to...
  6. Faseeh

    Plotting a Running Total (without an intermediate table)

    I believe you will have to do so by Defining a Name - and there you will create a formula that will yield the cumulative figure for each month. When you will be asked to plot a series, you will be using that Name.
  7. Faseeh

    Plotting a Running Total (without an intermediate table)

    I believe the best way is to use a secondary table. May be you can put that in some other sheet to avoid clutter, but the effort that you will put in to get this from one shot formula may be too much.
  8. Faseeh

    Turn time based on Condition

    Hi, Please see this post by chandoo: https://chandoo.org/wp/working-hours-formula/
  9. Faseeh

    animated infographics

    There is no harm in trying with dummy data but it will be really time consuming.
  10. Faseeh

    animated infographics

    Hi, Please check link, it is showing an error.
  11. Faseeh

    zero against dash with indian style rupee format in custom format in excel

    Hi, Please see this post of chandoo: https://chandoo.org/wp/indian-currency-format-excel/
  12. Faseeh

    Double in Slicer

    There is an extra space in cells C3 and C5:C12, removing that space will remove that duplicate... See attachment.
  13. Faseeh

    Total Amount by Month

    Hi, Please check this: =SUMPRODUCT(($A10=Transactions!$C$6:$C$17)*(Transactions!$E$6:$N$17)*(Transactions!$A$6:$A$17>=Budget!C$6)*(Transactions!$A$6:$A$17<=EOMONTH(Budget!C$6,0))) Also see attachment...
  14. Faseeh

    Dependent validation

    Hi Kuriakose, Responding after a long time ..... You need to create named ranges and then use INDIRECT() to fetch data in those lists. See attachment, i hope it is working accurately.
  15. Faseeh

    how to simplify nesting formula

    Just a comment, the length of this formula is 6065 characters that can be reduced by adopting shorter sheet name; replacing it from "from BSR v2 Daily" to name like "BSRV2" to get 4049 characters -This is a reduction of 33%. in formula's length.
Top