N
nut_mom
I'll try to make this make as much sense as possible...
Okay, so I receive orders from customers - each order includes all o
the items they ordered (therefore each order includes multiple ite
numbers) - I then use Excel to tally up all of the orders.
There are two different things I need:
1 - How can I, after typing all of the orders into Excel, count up ho
many of each item needs to be ordered (without scrolling down an
counting every time that item number appears...as I have to do now)?
2 - When I type an item number, I'd like the description of the item t
automatically pop up into the column next to it. Is it possible to sav
a list of item numbers with their description so that can happen?
Any help would be much appreciated
Okay, so I receive orders from customers - each order includes all o
the items they ordered (therefore each order includes multiple ite
numbers) - I then use Excel to tally up all of the orders.
There are two different things I need:
1 - How can I, after typing all of the orders into Excel, count up ho
many of each item needs to be ordered (without scrolling down an
counting every time that item number appears...as I have to do now)?
2 - When I type an item number, I'd like the description of the item t
automatically pop up into the column next to it. Is it possible to sav
a list of item numbers with their description so that can happen?
Any help would be much appreciated