ā¢1 min readā¢from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Data entry in one sheet modifying values in another sheet?
Hi everyone! Iām creating an inventory workbook. What Iād like to do is have one tab with our inventory counts, and another tab with data entry that will modify our inventory counts. For example I start my sheet with 5 blue shirts on tab A; tomorrow Katie comes in and asks for 2 blue shirts, which I will enter on tab B, which will then bring my blue shirt count in tab A down to 3. Is there a way to do this? I figure there must be, but having a hard time figuring it out and Googling it š any tips? Thanks so much!!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#financial modeling with spreadsheets
#real-time data collaboration
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#rows.com
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel compatibility
#real-time collaboration
#Excel alternatives
#inventory
#data entry
#workbook