PDA

View Full Version : Excel/Inventory question

ZYouL8R
03-30-2005, 01:35 PM
I'm organizing alot of aircraft parts out at work and I'd like to use a program that allows me to do a search for a part and it'll tell me where it is. I'm putting all the parts in boxes and placing the boxes on shelves. The shelves are lettered (A-G) and the boxes are numbered (1-12).

So for example, I'd like to be able to type in a part number and it'll tell me which shelf it's on and which box it's in.

Ex: PN324013 ----------> G8

So is there some basic inventory software that does this or is there a function of Excel where this can be done?
Tiny Tim
03-30-2005, 01:47 PM
Make a database. Do you have microsoft access?
Boss Hogg
03-30-2005, 01:50 PM
Sounds like a simple table you could build in Excel. Once you have all the part numbers in Column A and Locations in Column B, you could hit CTRL+F to find the row of data that contains the part number and location.

If you wanted to get "fancy", you could input the part number in cell A1 and use the vlookup feature in cell B1 to return the location.
The Big Matt
03-30-2005, 02:46 PM
a database would be much simpler than excel
Stang2be
03-30-2005, 05:09 PM
Check this out if you need a starting point for access

http://office.microsoft.com/en-us/templates/TC010184581033.aspx?CategoryID=CT011366681033

Microsoft has some templates online and one of them is an inventory access db.

Good luck

Or start here for more access templates

http://office.microsoft.com/en-us/templates/CT011359381033.aspx
Boss Hogg
03-30-2005, 05:16 PM
[QUOTE=The Big Matt]a database would be much simpler than excel[/QUOTE]
Only if he had 65,537 rows of data.
midnight
03-30-2005, 09:07 PM
[QUOTE=Boss Hogg]Only if he had 65,537 rows of data.[/QUOTE]

That limitation drives me nuts, I wish they would increase that.
trey85stang
03-30-2005, 09:56 PM
[QUOTE=midnight]That limitation drives me nuts, I wish they would increase that.[/QUOTE]


Thats why they have Access.
trey85stang
03-30-2005, 09:57 PM
[QUOTE=Boss Hogg]Only if he had 65,537 rows of data.[/QUOTE]

a database would still be simpler, the file would be more stable. I would not trust an excel spreadsheet that had 65k rows of data.
ZYouL8R
03-30-2005, 10:52 PM
I kinda taught myself Access today and figured out how to do it. Thanks guys.