Dynamic database

Omar Tafnakji - Sep 8, 2015 at 06:50 AM
 omar - Sep 21, 2015 at 03:55 PM
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,
Thanks a lot ... i do it...