Totalllllly new to this.... and really self taught on excel so any and all help would be useful
Trying to create an excel template... and having problems with having my master chart extract totals from each individual tab.
The goal is: to have a tab of each product in inventory.
ie: For Clothing, each shirt size will be it's own tab
and then have a master tabulator which as extracts from all tabs to have a total inventory in and out.
Should I use a template? Is one out there that I could use for this? Is it easy to create? Which formulas should I use to extract the numbers?
Thoughts?
Any and all help will be appreciated.
Trying to create an excel template... and having problems with having my master chart extract totals from each individual tab.
The goal is: to have a tab of each product in inventory.
ie: For Clothing, each shirt size will be it's own tab
and then have a master tabulator which as extracts from all tabs to have a total inventory in and out.
Should I use a template? Is one out there that I could use for this? Is it easy to create? Which formulas should I use to extract the numbers?
Thoughts?
Any and all help will be appreciated.
