Im trying to create an inventory worksheet with couple of pages. 1 displaying the totals, 2 where you enter info to add to inventory, and 3 page to subtract from inventory.
I tried making a macro that take the info from page 2 and add it to the total inventory page but could not figure out how because I keep making a loop. EX... B5 in total inventory has "99" and on the 2nd page i enter "1" that i need to add to the "99". I need help with figuring out how to make a macro or something else so that when i click a button on page 2, it will add that 1 to the 99 and = 100. Same thing for the subtraction (page 3)
I have a feeling that this is something really easy to do and that i am overthinking it, but i can come up with a solution. If need be, i can upload my excel file if really needed
Bookmarks