Search results

@Marc L Thanks for your code. In my actual sheet Intersect reference in another sheet "Sheet2.range("E10:G11") I don't know how to change the below code line from If Not Intersect([K16:M17], Target) Is Nothing Then to if not intersect(. ) is nothing then. I attached the sample...

Dear Excel Genius As per the below snapshot, if row 15 gets negative values when I change the values in rows 16 and 17, then I get the pop-up message. If I press OK then it has to do ".Undo" to get back the previous positive values in row 15. I used the below code for the pop-up message...

Thanks @p45cal

Dear Excel Genius, I use the Sumproduct function in the alternate cells to calculate the RM Purchase cost. 3 sample formulas and their snapshot are below. =SUMPRODUCT(Purchase[Price RM1],Purchase[Qty RM1]) =SUMPRODUCT(Purchase[Price RM2],Purchase[Qty RM2]) =SUMPRODUCT(Purchase[Price...

Yes, I found the mistake in what I did. Actually, I applied data validation only in the "K15" Now I understood and applied the data validation in the input cells too, which is trigger the pop-up messages promptly. Once again thanks a lot for your valuable reply @pecoflyer

Thanks @pecoflyer

Thanks @pecoflyer

The attachment is here.

@pecoflyer Thanks a lot for your reply The Data Validation pop-up comes when I edit the cells and not the value gets negative as per its formula. See below GIF I have added custom data validation with the formula. Find the attached sheet FYI. I am not preferred to use Conditional Format as...

Dear Excel Genius I want to pop up a message when the cells have negative values. To achieve that I used Data Validation > Decimal > Between > Error Message like below snapshot. After applying the data validation, I got pop up when I entered the negative values manually like below snapshot...

Dear Excel Genius In the below values, Many Names and F1 to F6 are repeated and duplicates exist. But I want to highlight the duplicates with both the columns, not just in one. For Example, Anbu F1 is the real duplicates, but if I apply Conditional Formates to find the duplicates, it...

Dear Excel Genius I have a excel workbook having 3 tables in one sheet name called "Production" Table 1, Product_Formulation Table 2 Consumption Table 3 Cost_Calcu Table 2 and Table 3 data updated from table1 with formulas. But I don't know how to activate them. For example, As per below...

Excellently working!!! Thanks again @Excel Wizard

@Excel Wizard I have transferred your suggested formula into my real working sheet where I have 34 RM (18 is Active) and above 40 products. all it is in Table format. I did some mistakes while transferring the formula. please see the below image and the attached file for the modification...

@Peter Bartholomew Thank you so much for your post and the lambda function in detail. I will create the real data with an example set of data. then I will transfer the lambda to there. if I get stuck somewhere then I will ask the question by posting here. Once again thanks for the lambda...

Working perfectly. Thanks a lot for your support.

@Peter Bartholomew I have observed and added the naming of RM2 to RM10 and I got the desired results in the sample file. But I don't know how to transfer the same to my actual file as it is having some kind of code inside the name manager. Sorry for my inability in the same. Thanks again...

@Excel Wizard I have applied both of your formulas and got some differences in the results. see below snapshot and the attached file for your kind consideration. The Red highlighted RM 5 Price is the wrong value by the first of your suggested formula. The Green Highlighted RM 5 Price is...

The above formula I tried for RM 1 and transfer from RM 2 to RM 10, But for RM 6 and 7 there is an error. I couldn't track what is it? Could you please check and clear the error? Tried column AU to BD. After this Calculation, I will transfer to the W column to get the final cost ( Sum of AU to...

@Peter Bartholomew and @Excel Wizard Thanks a ton to both of you! I just downloaded and it seems both formulae are working fine. I am trying to get all the 10 RM costs in Column W. Due to table formation, in the @Peter Bartholomew solution, I need some more time to understand and transfer it...

Dear Excel Genius I have produced some products in my company which is having or used different raw materials purchased with different prices. I want to calculate the products price per kg by using (Raw Materials) FIFO Method. Below is the example data I have calculated Products 1 to 5's RM 1...

Hi As per the below GIF I am calculating RM Cost per kg in the column of BA and BB. I would like to modify the code for the below changes. 1) RM Price and purchase qty should be in the new worksheet. not in the same sheet as of now. 2) Results of RM1 to RM10 Calculated and printed in...

It is working excellent. Thanks a ton, @fadee2 for your time and the solution.

In the attached sheet I have split and added all the new sheets with it is data. Sheet1 is the source data, remaining all is the new sheet I have added manually. Here, I added the Stations and Grades list for example. I need a VBA Code which can add only selected headings list.

Thanks for your swift response @fadee2 Yes, it is possible by VBA Code. Sorry, I did not understand what you are expecting. Let some MAC or Windows users supply the code.