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




Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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