Search results

Again it is showing "DATE" Instead of 04-Feb-2020 in the subject line.

After selecting 04-Feb-2020 from the date filter is showing the subject "Month of February 2020" only.

Hi With the below code I am sending the email from outlook with the selected cells as an image. In the subject as per code, today date is showing. Instead of today's date, I want to show the selected date through a filter. Eg: If I filter 04-Feb-2020 then the subject should show 04-Feb-2020...

Dear Vletm I have added the notes on how I calculated the cost of RM1 to RM3 for your kind consideration.

To produce 200kg of Product1 is required only 20kg of RM1 and remaining it will take as distilled water. (This is the formulation of chemicals products) Column B:K is the formulations of each product. Total formulation won't be 100% because balance water will consider automatically.

Dear vletm I hope the attached sheet will explain my expected results. Expecting your support.

Below is the one I expected in column"X" B is the result and C is the calculation for the results. A B C My expected results below Result Calculation Cell X4 $ 30.00 (10*$1)+(10*$2) Cell X5 $ 15.00 (5*$3) Cell X6 $ 35.00 (5*$3)+(5*$4) My expected result must be...

there is no further change in the previous post. can you please modify the code. Thanks in advance.

Dear Vletm Thanks for your valuable reply. My apologies if I was wrong in the first post. It is not calculating the cost as per purchase prices. below are the details for further modifications of the code. Column Y:AR is the purchased quantity and it's price of RM1 to RM10 Column M:V is...

Hi I have RM1 (Raw Material) to RM10 (Raw Material) Purchase with different quantity and price. Also, Product1 to Product12 with different combination formulations of RM1 to RM10 as per attached sheet. I want to calculate Each product RM (Raw Material) cost per kg from the purchase price...

Got the corrected code. https://www.mrexcel.com/board/threads/vba-document-particular-cells-value-address-and-heading-to-new-sheet.1118757/#post-5393777

Dear Marc L Thanks for your suggestion and your valuable time spent towards my question. Let me wait for others help as I really can't find with the VBA inner help to build the code.

In the attached sheet 2 have the expected results. With your earlier code, I can find the yellow highlighted cells and then I do not know how to modify the codes to get the cell values, heading and address to the other new sheet. Also, in your earlier code, you were using dictionary and other...

Dear Herofox If there is a problem with uploading, please share the Dropbox or Onedrive file link for the quick action. Please note that, You are checking the dates and extract the prices accordingly. Actually we need to check the quantity consumption with the price changes, Also need to...

Sorry, I match the heading of RM 1 Qty now for the checking. Check the attached sheet. In that, I added your formula results as well as expected results in the next column manually. Also, I added the calculations for the FIFO for the cell D41. Actually, we need to pick the cost of the RM...

Dear Herofox Check the attached file with your suggested formula. It is not showing the results. Could you please attach the file with your formulation. Thanks for your effort.

Dear All Find the attached workbook having the sheets of RM Consumption and RM Purchase. RM's are RM1 to RM51 In RM Consumption sheet I have RM Price and RM quantity, Whenever the RM Price changes I have highlighted by yellow colour. I need the price in RM Purchase sheet, next to the...

Dear All Find the attached sheet, In that, I want to find the yellow-coloured cells and it must be documented to the new sheet with its value and cell address. For that, I tried below code and I got error 438 Option Explicit Sub SelectColoredCells() Dim Sh As Worksheet Dim rCell As...

Thanks, it is working.

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. https://www.dropbox.com/s/6of29s0mai85lao/MSP%20Chandoo.xlsb?dl=0

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

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.