Forum Discussion

skytube's avatar
skytube
Copper Contributor
Jun 09, 2024

inventory tracking system

Hello, how to establish an inventory tracking system in Excel utilizing Logbook codes when a form No. is entered in the first Excel sheet, the corresponding quantity is automatically deducted from t...
excel
  • skytube's avatar
    skytube
    Copper Contributor
    Jun 10, 2024

    Lorenzo 

     

    Could you please assist me in adding this formula to the inventory sheet (yellow-colored cells) in the worksheet below?

    https://pioneerpharmaceutical-my.sharepoint.com/:x:/g/personal/ahmed_selim_pioneerpharma_org/EW6EEgxwVD5Im0O-BXu_LIABzbwCqGeizb2JOAjZuVQ1BA?e=WLgav3

     

    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Jun 10, 2024

      skytube Can't open your file as it requires Credentials

      Either try to attach it here or if not allowed share it i.e. https://support.microsoft.com/en-us/office/share-files-with-onedrive-4e871e9a-4cb7-4c66-8b38-d2ee590532c2 and post the link here

      • skytube's avatar
        skytube
        Copper Contributor
        Jun 10, 2024
        I apologize for any inconvenience
        https://1drv.ms/x/c/558266e921a17e41/EXpNZgX1FmdDpP1UlOMYFOMBmjJwkEbZ1udXZyk7aLWjhg?e=4ss4M5
  • skytube's avatar
    skytube
    Copper Contributor
    Jun 10, 2024

     Thank you very much for your time in working on the file and answering my question. It has helped me a lotLorenzo 

  • MollyHolly333's avatar
    MollyHolly333
    Copper Contributor
    Jun 09, 2024
    that helped me, thanks

Resources