Help tracking inventory

  • Thread starter Thread starter speakers_86
  • Start date Start date
S

speakers_86

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
 
You mean the names of the sheets? the sheets are calledLog, warehouse,
techs, customers
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with Excel worksheet 4
Left Lookups across multiple data sheets 4
Using Access 2003 for Inventory 2
Inventory/Sales/Warehouses 6
Help with Query Design 1
Index Function Problem 7
how to put qty & date of the item 0
How to make an inventory of incomming goods 1

Back
Top