Help tracking inventory

[speakers_86]

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]

bump bump bump

[speakers_86]

can excel do this??

[PY & Associates]

Post the headings of both sheets please.

"speakers_86" <speakers_86.2bl7cw_1153975211.5142@excelforum-nospam.com>
wrote in message
news:speakers_86.2bl7cw_1153975211.5142@excelforum-nospam.com...
>
> 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
>

[speakers_86]

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

[PY & Associates]

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" <speakers_86.2bmsri_1154049609.6441@excelforum-nospam.com>
wrote in message
news:speakers_86.2bmsri_1154049609.6441@excelforum-nospam.com...
>
> 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
>

[PY & Associates]

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" <speakers_86.2bmsri_1154049609.6441@excelforum-nospam.com>
wrote in message
news:speakers_86.2bmsri_1154049609.6441@excelforum-nospam.com...
>
> 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
>

[speakers_86]

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.

[PY & Associates]

you already have our address please.

"speakers_86" <speakers_86.2bmwgv_1154054410.4429@excelforum-nospam.com>
wrote in message
news:speakers_86.2bmwgv_1154054410.4429@excelforum-nospam.com...
>
> 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
>