•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Can I use excel to track inventory
Our take
If you're looking for a straightforward way to track inventory, Excel can be an effective tool. With its flexibility, you can create a simple inventory tracker tailored to your needs. By setting up a page to add or remove items, you can easily monitor stock levels. Additionally, you can create a second page to alert you when quantities drop below a specified threshold, like one or two. While Access offers powerful features, Excel may be the more accessible choice for your current requirements.
Im looking for a simple inventory tracker ive tried a few templates in access but is to much going on and not that familiar on how to work it. So thought I could try excel
If I create a page that I either add or take an item out can I have another page tell me if im out or low on an item maybe if it falls below 1 or 2 qty ot should I keep trying access.
I looked at a few excell templates to but not quite what im after and not sure how to add what I want or create the formula to do it
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#natural language processing for spreadsheets#AI formula generation techniques#generative AI for data analysis#formula generator#inventory tracker#excel#templates#access#qty#page#formula#create#track#item#simple#low