Stock count

[NyDarR]

I'm trying to figure out a way of making a basic stock count. It will have item, stock, how many came in on del, how many was there on previous count ( looking back at previous count)and how many used (using formula). I'm wondering if it's possible to set it up so that rather than a new workbook or sheet for each week, I can have a week number selector at the top and the one page will populate with that week's stock count. It can then be filled in with that week's stock count and delivery ammount. Then I can go to the next page by changing the week and it'll carry over the weeks stock count into the previous week's count and then keep going from there. Also would be able to change the week to older weeks to look back at historical data etc. big ask I know but most people I work with are not savvy so trying to making it a simple 1.pagw affair with just having to change the week number each time. Many thanks

 

[akmatz]

Have you checked out the many free templates that Excel provides? Here a partial snapshot of available templates when I entered the search word: "Inventory".