Dynamic database

Solved/Closed
Omar Tafnakji - Sep 8, 2015 at 06:50 AM
 omar - Sep 21, 2015 at 03:55 PM
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

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
Sep 8, 2015 at 11:19 AM
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
0
Thanks a lot ... i do it...
0