# Search results

1. ### 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...
2. ### 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
3. ### 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...
4. ### 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.
5. ### 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...
6. ### 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...
7. ### Find the lesser closest date by given date and then multiply the intersect values.

Dear GraH Guido Thanks a lot for your reply with the solution. As I want to learn the VBA Code writing, Can we write the code without using application functions like index and match? Because I want to write the working pure VBA code without using any of the functions as an index match...
8. ### Find the lesser closest date by given date and then multiply the intersect values.

I would like to convert my daily working sheet from normal excel formulas to VBA code as I want to write and learn the working VBA code. I am just beginner in the VBA code writing. Your help will be very grateful for me. Thanks in advance.
9. ### Find the lesser closest date by given date and then multiply the intersect values.

Hi I need a VBA code to get the below results. In the attached workbook Sheet1, Cell D9 is the given date and the cell B12: H12 is the data range Sheet2 A2: A15 is the list of dates where we need to lookup by VBA code In the list of dates in Sheet2, none is matching Sheet1, D9 dates of...
10. ### How to get data between two dates in vba

Dear All Just check the below link sheet where I got all the results except when I select E6 (Raw materials Stock Value) value in the cell P1 dropdown list, as its required VBA code for index match formula. below code is for your information and help me with the code between Line 109 to Line...
11. ### How to get data between two dates in vba

Dear p45cal Really thanks a lot for your codes and the explanation. It is working and given the desired results well. Firstly, I know the macro recording in a simple way like, make borders and change the colours and get the prints. Indeed I do not know how the R1C1 code be recorded by the...
12. ### How to get data between two dates in vba

Well Understood. Can you guide me to write the code? Otherwise, give me an example file with VBA Code which can give similar output.
13. ### How to get data between two dates in vba

Dear Vletm I did not change the case. I just want to write the VBA code and get the results which those formulas do in the cell EL1. That's all I want. Sorry If I conveyed my requirements in the wrong way in my previous posts. Anyway, Really thanks a lot for all your support and times...
14. ### How to get data between two dates in vba

Dear p45cal Thanks a lot for your prompt reply and the time you have spent for my query. Your given solution is excellent and it is met my expectations. However, I am requesting you that can we write some VBA code to get the results in only the cell EL1? My intention is to learn how to...
15. ### How to get data between two dates in vba

Dear All The excel formula is in the cell EL1 and it gives the results depends on cell P1 dropdown list selection. Check the new attached sheet here. When I select Cell EL1 it is showing this big formula and I want to hide without losing the output results. Then I choose to write a VBA code...
16. ### How to get data between two dates in vba

Dear All Sorry for the missing information in my previous posts. Here again, I try to explain in a different way. The below code
17. ### How to get data between two dates in vba

Dear Alan If you did not understand my English then leave it. let others reply to me with the solution who can understand. I am not here to learn English.
18. ### How to get data between two dates in vba

In the below dropbox link sheet, if cell P1 changes from its dropdown list Then EL1 displays the results by using below formulations...
19. ### How to get data between two dates in vba

Hi The below formula I tried to convert VBA code but I struck how I can tell VBA that between two dates and only in sales data to be extracted. IF(P1=EN2,(SUMPRODUCT((J8:J30495<=EN1)*(J8:J30495>=EO1)*(G8:G30495="Sales")*CF8:CF30495)) Cell J8: J30495 is sales date Cell G8: G30495 is having...
20. ### How to understand each line of VBA code

Dear Stevie Thanks a lot for your explanation.
21. ### Sort data by date

Thanks a lot, Vletm It is working well. Sorry for the missed data in the earlier post.
22. ### Sort data by date

Sorry, I forgot to mention in the earlier post. I don't know how to rewrite. Can you please correct the same?
23. ### Sort data by date

Hi Vletm Thanks for your valuable reply. I just change the Product 1 formulation on 6-Jun-17. So, up to 05-Jun-17, it should take old formulation. From 06-Jun-17 onwards the new change to be taken until further change takes place. But, it is not taking correctly, I think a small fine tune...
24. ### Sort data by date

Hi The attached sheet having Sheets of Formulation and Batch card with VBA code which is giving desired results from the sheet "Formulation" according to the C4 and F4 cells value in the sheet "Batch Card". In the cell E3, I have a Date and also in the sheet formulation Column A, I have a...
25. ### How to understand each line of VBA code

Could anyone explain the below codes? Line 3, If Target.Count > 3 Then Exit Sub (What is count 3 mean by) Line 10, K = 7 (What is 7 mean by) Line 15, celda = b.Address (What is Address) Line 18 to 26 (Totally I did not Understand what it does) If you are explaining the above lines, I can...