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

Hi

Start here:
http://www.contextures.com/xlUserForm01.html

HTH. Best wishes Harald

"nip" <gbreath@gmail.com> wrote in message
news:5aef7fca-7f2a-462b-8305-e0dfffabe810@d1g2000hsg.googlegroups.com...
> 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