Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tracking inventory | Excel Worksheet Functions | |||
tracking inventory | Excel Discussion (Misc queries) | |||
Inventory Tracking Sheet | Excel Worksheet Functions | |||
Tracking inventory | Setting up and Configuration of Excel | |||
FIFO Inventory tracking | Excel Programming |