•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?
Our take
Managing inventory efficiently is crucial, and your idea of linking data entry across sheets is a smart approach. By creating one tab for inventory counts and another for data entry, you can streamline updates effortlessly. For example, when you reduce the count of blue shirts after a sale, the inventory tab should reflect this change automatically. There are effective methods to achieve this using formulas like `SUMIF` or linking cells. Let’s explore how you can set this up to empower your inventory management.
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]
Read on the original site
Open the publisher's page for the full experience
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