Jan 04 2023 04:34 PM
=SUMIF(T_BOM[RAW MATERIAL],"RWC0045",T_BOM[QTY TRANSFER UNTIL NOW])
Above formula value = 35
How I can I insert the 35 to cell that's match to RWC0045?
Jan 05 2023 05:56 AM
@Justme25
I'm afraid it's not clear to me what you want. Could you post a screenshot with an explanation, or attach a sample workbook?
Jan 05 2023 07:19 AM
@Hans Vogelaar
https://d.docs.live.net/85b578a6faa0762c/
what I want to do is to deduct value of RWC0045 in sheet BOM from RWC0045 in sheet RAW MATERIAL
Jan 05 2023 07:25 AM
l attach the screenshot
Jan 05 2023 07:30 AM
Your OneDrive link doesn't work. Right-click the file and select Share from the context menu, then click Copy to copy a share link. You can paste that into a reply.
Jan 05 2023 05:08 PM
https://1drv.ms/x/s!Aix2oPqmeLWFvgiAsIgUdD8ojX_G?e=8EXHMG
Jan 06 2023 04:41 AM
OK, got the file.
Can you now explain in detail what you want to do?
