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.
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...
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...
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.
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...
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.
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.
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...
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.
Dim colu As Range...
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...
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...
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...
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...
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.
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...
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...
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...
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...
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...
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...