ā¢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
#google sheets