• 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 Anbuselvam K

  1. A

    Code for sum the value with two criteria

    Thanks, it is working.
  2. A

    Code for sum the value with two criteria

    In the cell C2: C6 the RM Prices are same and C7 got changed, So D7 I need to show the sum value from sheets Master Data RM2 up to A6 date. In this case, D1 to D6 must be blank and D7 has to show values. Like that all the yellow highlighted cells must show the values.
  3. A

    Code for sum the value with two criteria

    In the cells, D22 the below excel formula gives the desired result =SUMIF('Master Data'!$B$9:$B$9580,"<"&A22,'Master Data'!$CH$9:$CH$10170) Like D22 I have more than 1000 cells in the same sheet which is highlighted in yellow colour and with no values. I want the same results in all yellow...
  4. A

    Code for sum the value with two criteria

    With the below code Pick_Data, I just find the left last cell date value and top last cell RM number showing in the MsgBox. The below code I have created after watching the macro recording steps. After finding the intersect date and RMName, How do I get the desired results as mentioned in my...
  5. A

    Code for sum the value with two criteria

    I have added two more expected results In the cells F101 and H20 for your information. Ask me if you require further details. I am here to provide the same. https://www.dropbox.com/s/6of29s0mai85lao/MSP%20Chandoo.xlsb?dl=0
  6. A

    Code for sum the value with two criteria

    Hi The below linked excel file Module1, I have a below code to find out the Yellow highlighted cells without any values in that, After finding those cells I need to check each highlighted cells intersect column "A" Value (Date) and then it has to check those dates in another sheet then...
  7. A

    VBA code for search, find and pick the appropriate data

    Dear Vletm In the sample file, it is not allowing to add RM 7 and RM8... etc. I have totally 55 RM and further, it will be an increase can you please change the code or advice which part of the code to be changed to add the RM? Thanks in advance.
  8. A

    VBA code for search, find and pick the appropriate data

    Dear Vletm & Marc L Both of your solutions are working well and good. I will implement this to my original file and I will contact you here If I am struck with the modifications. Thanks a ton for your valuable and prompt support.
  9. A

    VBA code for search, find and pick the appropriate data

    Hi In the attached excel file have 3 worksheets called Permanent Formulas and the Temporary Formulas which are the source data and Master Data which is input data. In the Sheet Master Data Range A9: B12 is the input data. With this input data, it has to find the appropriate formulas from both...
  10. A

    Find the lesser closest date by given date and then multiply the intersect values.

    Hi I have added two codes here. The code1 is working well, But when I add the code1 into code2 it is showing type mismatch error in Line 92. Please check the code and give me a solution. https://www.dropbox.com/s/n8qtozpmue5eox0/VBA.xlsm?dl=0 Code1 Sub indexmatch() Dim colu As Range...
  11. A

    Find the lesser closest date by given date and then multiply the intersect values.

    Can anyone help! How do I write the code For i = 85 to 136 in Sheets("Master Data") and For i = 2 to 53 in sheets("RM Price") Thanks in advance
  12. A

    Find the lesser closest date by given date and then multiply the intersect values.

    Dear All I need your valuable support, Almost I finished my code and struck with the last one thing as below the highlighted code line is taking i = 85 to 136 column number in both sheets. How do I write the code For i = 85 to 136 in Sheets("Master Data") and For i = 2 to 53 in sheets("RM...
  13. A

    Find the lesser closest date by given date and then multiply the intersect values.

    Sorry, I don't know further how to multiply the intersect values and where the object A is filled. if your time permits please guide me to get the solutions.
  14. A

    Find the lesser closest date by given date and then multiply the intersect values.

    Dear Marc L After finding the date in column A, Can we use Set B2I15= Intersect(Columns("B:I"), A.EntireRow) The below code is for sumproduct formulas results by pure VBA code for your information. The sum-product formula is...
  15. A

    Find the lesser closest date by given date and then multiply the intersect values.

    Dear Marc L Thanks for your reply Check the attachment for your study. it is not giving proper results in the cell D10 Also, the code has an application function of sumproduct which I do not require. I want the code without using the sumproduct index and match functions. I hope you can...
Top