Inventory

  • Thread starter Thread starter GREGPOOH43
  • Start date Start date
G

GREGPOOH43

I NEED SOME DIRECTION

ON SHEET 1 I HAVE ITEM# PART DESCRIPTION AND A ON HAND QUANITY

ON SHEET 2 I HAVE ITEM# AND ISSUE OR RECIEVE IS THERE ANY WAY T
SUBTRACT AND ADD INVENTORY FROM SHEET 2 TO SHEET 1. IM NOT WHAT I NEE
TO DO TO GET THIS TO HAPPEN. OR IF IT CANT BE DONE IN A SPREADSHEET.

THANKS FOR ANY HELP OR DIRECTION

GRE
 
without knowing any detail, have a look at the vlookup function. you ca
do something like =a1-lookup(-your formula here - )

else post more detail
 
"GREGPOOH43 >" ...
I NEED SOME DIRECTION

ON SHEET 1 I HAVE ITEM# PART DESCRIPTION AND A ON HAND QUANITY

ON SHEET 2 I HAVE ITEM# AND ISSUE OR RECIEVE IS THERE ANY WAY TO
SUBTRACT AND ADD INVENTORY FROM SHEET 2 TO SHEET 1. IM NOT WHAT I NEED
TO DO TO GET THIS TO HAPPEN. OR IF IT CANT BE DONE IN A SPREADSHEET.

THANKS FOR ANY HELP OR DIRECTION
Click to expand...

Greg,

Before we begin to address your question, I have to inform you of newsgroup
etiquette: Please don't write in CAPS as it appears that you are screaming
at us at the top of your lungs. I am sure you don't mean to scream, but
that is how it is interpreted. That, and it is much harder to read. Please
help us help you.

Now to address, your question, yes Excel can probably do what you need done
by moving stuff from Sheet 1 to Sheet 2 or vice versa. Without knowing the
very specifics of your problem (you need to provide more detail), it is
difficult to provide specific advice. You might need to program Excel
(VBA - macros), to get what you need done.

Depending on the complexity of your inventory system, you might find Access
(database application) to be a better program for your needs.

Also, you might wish to search Google's archives for "inventory" in the
Excel newsgroups. The link to do that is here:

http://www.google.com/advanced_group_search?q=group:*excel

Just plug "inventory" without the quotes in the "with all the words" box.
You can then look through some of the previous questions and answers to get
a better feel as to how you might want to structure your solution.

Hope that helps.

Best regards,
Kevin
 
Back
Top