N
nip
Wanting to create a simple workbook to record the inventory of items.
1st worksheet name In
2nd worksheet name out
3rd worksheet name shelf
On #1 the item would be entered when it arrives and then show on #3
When the item is sent out it would be entered in worksheet #2 and
again be reflected in total on #3
Is this maybe something that can be done using forms for the in and
out items so others can enter information in a form and have the
totals show on #3?
Link to a tutorial on this would assist greatly TIA
1st worksheet name In
2nd worksheet name out
3rd worksheet name shelf
On #1 the item would be entered when it arrives and then show on #3
When the item is sent out it would be entered in worksheet #2 and
again be reflected in total on #3
Is this maybe something that can be done using forms for the in and
out items so others can enter information in a form and have the
totals show on #3?
Link to a tutorial on this would assist greatly TIA