Help tracking inventory
 

I need help with something that may be very complicated. Ive got a
excel workbook that i use to track inventory at my job. there is
sheet for logging equipment transfers, another to display equipment o
a technicians truck, and another to display equipment in customer
houses, and another for the warehouse. Im looking for a way to ge
excel to automatically look at the log and transfer the equipment fro
truck to truck, truck to customer, truck to warehouse, etc.

example of the log

Equipment ID From To
102 Bryans truck warehouse

once this is logged, can excel go to the technicians page, find 10
under bryan, and move it to the sheet for the warehouse. Oh, also, 10
is an airscrubber. So it needs to be moved from the column o
airscrubbers under bryan to the column of airscrubbers unde
warehouse.

it may be hard to understand this not looking at what im talking about
but any help would be greatly appreciated

--
speakers_8
-----------------------------------------------------------------------
speakers_86's Profile: http://www.excelforum.com/member.php...fo&userid=3683
View this thread: http://www.excelforum.com/showthread.php?threadid=56546

Help tracking inventory
 

bump bump bump


--
speakers_86
------------------------------------------------------------------------
speakers_86's Profile: http://www.excelforum.com/member.php...o&userid=36839
View this thread: http://www.excelforum.com/showthread...hreadid=565467

Help tracking inventory
 

can excel do this??


--
speakers_86
------------------------------------------------------------------------
speakers_86's Profile: http://www.excelforum.com/member.php...o&userid=36839
View this thread: http://www.excelforum.com/showthread...hreadid=565467

Help tracking inventory
 

Post the headings of both sheets please.

"speakers_86"
wrote in message
...

I need help with something that may be very complicated. Ive got an
excel workbook that i use to track inventory at my job. there is a
sheet for logging equipment transfers, another to display equipment on
a technicians truck, and another to display equipment in customers
houses, and another for the warehouse. Im looking for a way to get
excel to automatically look at the log and transfer the equipment from
truck to truck, truck to customer, truck to warehouse, etc.

example of the log

Equipment ID From To
102 Bryans truck warehouse

once this is logged, can excel go to the technicians page, find 102
under bryan, and move it to the sheet for the warehouse. Oh, also, 102
is an airscrubber. So it needs to be moved from the column of
airscrubbers under bryan to the column of airscrubbers under
warehouse.

it may be hard to understand this not looking at what im talking about,
but any help would be greatly appreciated.


--
speakers_86
------------------------------------------------------------------------
speakers_86's Profile:
http://www.excelforum.com/member.php...o&userid=36839
View this thread: http://www.excelforum.com/showthread...hreadid=565467

Help tracking inventory
 

You mean the names of the sheets? the sheets are calledLog, warehouse,
techs, customers


--
speakers_86
------------------------------------------------------------------------
speakers_86's Profile: http://www.excelforum.com/member.php...o&userid=36839
View this thread: http://www.excelforum.com/showthread...hreadid=565467

Help tracking inventory
 

We mean headings of the columns.
We are not sure how you spread out descriptions of the items.
If not confidential, send us part of the files please.

"speakers_86"
wrote in message
...

You mean the names of the sheets? the sheets are calledLog, warehouse,
techs, customers


--
speakers_86
------------------------------------------------------------------------
speakers_86's Profile:
http://www.excelforum.com/member.php...o&userid=36839
View this thread: http://www.excelforum.com/showthread...hreadid=565467

Help tracking inventory
 

the headings are air mover, air scrubber, dehumidifier, hepa vac, wall
vent, i think there are more but i dont have the workbook on this
computer and of course im not connected to the network in the office.

but if you want to give me your email address i can send you the file
tomorrow morning. of course i would understand if you dont want to do
that.


--
speakers_86
------------------------------------------------------------------------
speakers_86's Profile: http://www.excelforum.com/member.php...o&userid=36839
View this thread: http://www.excelforum.com/showthread...hreadid=565467

Help tracking inventory
 

you already have our address please.

"speakers_86"
wrote in message
...

the headings are air mover, air scrubber, dehumidifier, hepa vac, wall
vent, i think there are more but i dont have the workbook on this
computer and of course im not connected to the network in the office.

but if you want to give me your email address i can send you the file
tomorrow morning. of course i would understand if you dont want to do
that.


--
speakers_86
------------------------------------------------------------------------
speakers_86's Profile:
http://www.excelforum.com/member.php...o&userid=36839
View this thread: http://www.excelforum.com/showthread...hreadid=565467

Help tracking inventory
 

umm...i do?


--
speakers_86
------------------------------------------------------------------------
speakers_86's Profile: http://www.excelforum.com/member.php...o&userid=36839
View this thread: http://www.excelforum.com/showthread...hreadid=565467

Help tracking inventory
 

Just reply
do not reply to group

"speakers_86"
wrote in message
...

umm...i do?


--
speakers_86
------------------------------------------------------------------------
speakers_86's Profile:
http://www.excelforum.com/member.php...o&userid=36839
View this thread: http://www.excelforum.com/showthread...hreadid=565467

Help tracking inventory
 

Okay, i think i got it now.

edit: im trying to send you a private message but it wont let m
attach my file. ill try again later.

PY & Associates Wrote:
Just reply
do not reply to group

"speakers_86

wrote in message
...

umm...i do?


--
speakers_86

------------------------------------------------------------------------
speakers_86's Profile:
http://www.excelforum.com/member.php...o&userid=36839
View this thread
http://www.excelforum.com/showthread...hreadid=565467


--
speakers_8
-----------------------------------------------------------------------
speakers_86's Profile: http://www.excelforum.com/member.php...fo&userid=3683
View this thread: http://www.excelforum.com/showthread.php?threadid=56546