Dynamic database [Solved/Closed]

Report
-
 omar -
Hello,
i have a database sheet about spare parts in my store .. this spare pasrts are changed their counted daily , i need the formula that refreash my spare parts acount automaticly and give me the latest data , ( the outgoing spare parts are done in excel sheet also ...)

thanks alot




1 reply

Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
446
Hi Omar,

You can use the VLOOKUP formula to place the outgoing parts on the same row as your stock and then subtract to get the actual stock amount.

Best regards,
Trowa
Thanks a lot ... i do it...