Forum Discussion

Stacey123520's avatar
Stacey123520
Copper Contributor
Jan 12, 2022

Inventory Spreadsheet

Hi, 

 

I'm hoping someone can help me as this is beginning to drive me crazy, I can not seem to make it work.

 

I have an excel inventory spreadsheet.

 

The first sheet is the master inventory tab, then afterwards there are multiple sheets, all with the same information on but specific to each site.

 

Im trying to get a formula working so that if i had say 10 traffic cones out on site it would take this away from the available cell on the master sheet.

 

I managed to get it working for the 1st sheet but then when i added a 2nd sheet, it wouldn't work.

 

Any ideas?

 

Thanks so much 🙂

 

excel
Formulas and Functions

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jan 13, 2022

      

    Inventory list for Download

    Templates Inventories

     

    If this Information dont helps, please ... Give more detailed information about your project.

    It is best to insert a file (without sensitive data), where you describe your project step by step on the basis of this file.

    ( Drag and drop here or browse files to attach
    Maximum size: 71 MB • Maximum attachments allowed: 5   )

    Inform us about your computer environment, Excel version, operating system, storage medium (hard drive, OneDrive, Sharepoint, tec.).

    In this way you can get a solution proposal that is tailored to you much faster and more precisely,

    and you save the helpers a lot of time in that they no longer need to guess what-where-how your plan is. Welcome to your Excel discussion space!

     

    Hope I was able to help you with this info.

    Thank you for your understanding and patience

     

    NikolinoDE

    I know I don't know anything (Socrates)

     

     

    Stacey123520

Resources