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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
Thanks a lot ... i do it...
0