Excel/Inventory question - DFWstangs Forums
 
LinkBack Thread Tools Display Modes
post #1 of 10 (permalink) Old 03-30-2005, 12:35 PM Thread Starter
Sports weenie @ full attn
 
ZYouL8R's Avatar
 
Join Date: Dec 2002
Location: Laughlin AFB
Posts: 5,638
Excel/Inventory question

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?

ZYouL8R is offline  
Sponsored Links
Advertisement
 
post #2 of 10 (permalink) Old 03-30-2005, 12:47 PM
Timmay
 
Tiny Tim's Avatar
 
Join Date: Aug 2001
Posts: 4,898
Make a database. Do you have microsoft access?
Tiny Tim is offline  
post #3 of 10 (permalink) Old 03-30-2005, 12:50 PM
M0DERAT0R
 
Boss Hogg's Avatar
 
Join Date: Apr 2000
Location: Hazzard County
Posts: 19,655
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.

'08 Pontiac G8 GT
Bone Stock
13.7 @ 102 mph
Boss Hogg is offline  
 
post #4 of 10 (permalink) Old 03-30-2005, 01:46 PM
Very Interesting
 
The Big Matt's Avatar
 
Join Date: Mar 2000
Location: Around the World
Posts: 9,856
a database would be much simpler than excel
The Big Matt is offline  
post #5 of 10 (permalink) Old 03-30-2005, 04:09 PM
El Camino
 
Stang2be's Avatar
 
Join Date: Sep 2003
Location: in front of the keyboard
Posts: 3,432
Check this out if you need a starting point for access

http://office.microsoft.com/en-us/te...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/te...359381033.aspx

2007 Taurus SEL - daily driver
1974 El Camino SS - 400sb

Quote:
Originally Posted by purrrfectstang
Umm.. what is the ID-10T settings?
Stang2be is offline  
post #6 of 10 (permalink) Old 03-30-2005, 04:16 PM
M0DERAT0R
 
Boss Hogg's Avatar
 
Join Date: Apr 2000
Location: Hazzard County
Posts: 19,655
Quote:
Originally Posted by The Big Matt
a database would be much simpler than excel
Only if he had 65,537 rows of data.

'08 Pontiac G8 GT
Bone Stock
13.7 @ 102 mph
Boss Hogg is offline  
post #7 of 10 (permalink) Old 03-30-2005, 08:07 PM
4's a Charm!
 
midnight's Avatar
 
Join Date: Sep 2000
Location: Far, Far away
Posts: 1,096
Quote:
Originally Posted by Boss Hogg
Only if he had 65,537 rows of data.
That limitation drives me nuts, I wish they would increase that.
midnight is offline  
post #8 of 10 (permalink) Old 03-30-2005, 08:56 PM
 
Join Date: Nov 2002
Posts: 5,831
Quote:
Originally Posted by midnight
That limitation drives me nuts, I wish they would increase that.

Thats why they have Access.
trey85stang is offline  
post #9 of 10 (permalink) Old 03-30-2005, 08:57 PM
 
Join Date: Nov 2002
Posts: 5,831
Quote:
Originally Posted by Boss Hogg
Only if he had 65,537 rows of data.
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.
trey85stang is offline  
post #10 of 10 (permalink) Old 03-30-2005, 09:52 PM Thread Starter
Sports weenie @ full attn
 
ZYouL8R's Avatar
 
Join Date: Dec 2002
Location: Laughlin AFB
Posts: 5,638
I kinda taught myself Access today and figured out how to do it. Thanks guys.

ZYouL8R is offline  
Sponsored Links
Advertisement
 
Reply

Bookmarks

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the DFWstangs Forums forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome