Using Excel for trailer Yard Inventory

Hello: I have been banging my head against the wall for weeks on how to work this one out!

I work at a trucking company which has multiple parking lots with many trailers on them. I keep Excel "maps" which work as overhead views of the yards with numbers displayed to keep inventory and I update these maps daily. I've been trying to find a way to link the list of trailer numbers that are supposed to be sitting in our yards (according to our company inventory) to the yard maps so that it will confirm that the trailer is actually sitting on the yard. Not only that, I would also like the spreadsheet to say what yard or row the trailer is sitting in, and somehow indicate that a trailer is there that shouldn't be there or that a trailer is missing. (the main yard is divided into rows Row A, B, C, etc, the other yards are not but I'd like it to say the name of the yard it is sitting in)

I attached a couple of demo images to give a visual on what I'd like it to be like. Each yard map would occupy it's own tab or sheet. Can this be done? Please let me know cause this would save me at least an hour each day if I could update the maps only and not have to manually change each row if a trailer moved or left!

PS. Maybe the additional and missing trailers could occupy separate tabs if necessary???

Also, I know my demo's are in Open Office but I use Excel at work

G'day and welcome to the forum,

See Attached.

Cheers

RC

sorry i couldn't resist

Since my hangover has clear and Martin great solution (hahahaha) has got me thinkin' that you may need your data this way.

Just select the Trailer's name on the "Yard" sheet.

G'day Moon,

I'm still confused.......which way are you inputting the data. Like my first example or the second example ?

Cheers

RC

G'day Moon,

Here is the workbook you have ask for. Without not sounding rude etc etc. I'd suggest you learn the 2 main formula that I used in case other users damage the workbook but in saying that you can hide the Database sheet (which the best thing to do) and un/protect certain cells on your Main Inventory and Additional Sheets.

Btw I had a compatibility warning when I saved the workbook. The warning reference to Excel 5.0. If this is the case that you are using this workbook on older program the conditional formatting in the 'Location' column we be lost. Cos the cell turns red when the trailer is missing.

Please let us (the Forum) know if more help is required.

Cheers

RC

Martin!
))))))))))

Originally Posted by notieno

Hey, are you able to answer my question down below?

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

George,

I would suggest you start your own thread and link to this one for reference.
There's a better chance that someone will respond to your request as this is a very old thread.