• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel 2007 - Want to create 2 fields, part number quantity, then sum

L

laser guy

New Member
Would like suggestions on putting in a couple of boxes, enter a part number, then quantity. Have a table show all part numbers, their total quantity each.


or


use drop down (do have sheet with part numbers, corresponding prices )to select part number, input total, date, then have a running summary of all parts and their corresponding quantities and sub-totals ($) to make it easier to order these parts.


Thanks!


Kevin aka Laser Guy
 
Good day Kevin


This may be of help to you


http://chandoo.org/forums/topic/changing-drop-down-menus
 
Good Day Lymm and Thank You for your response -


Yes, having a user form to enter data ( part number; quantity ) and send to a table where it would sum quantity based on part number would be the ideal situation. Don't have to have the pricing, but it would be a nice add-in.

( I really need to be able to enter the same part number, maybe several times a day with it's quantity each time and end up with one table with totals for each separate part number..... i.e. - "4500-20, qty 2; 4500-22, qty 1; 4500-20, qty 4"-

then the table would show - 4500-20 qty 6; 4500-22 qty 1 )


Kevin aka Laser Guy


( if only our brains had USB 3.0 ports to share info ! )


Thanks all!
 
Do you have a sample file you could post with the layout that you require and a sample of your database etc.
 
http://rapidshare.com/files/3125845226/Test%20File.xlsx


First column has all the part numbers. Would like to enter a p/n in the field to the right, then qty and have it keep a running sum total for each p/n in the quantity column.
 
Sorry, didn't see note about Dropbox until I installed Google Drive....let's try that first if that's ok....

Try this link - https://docs.google.com/file/d/0B5fC8KNiR0QYelpscmZPNjlVR3c/edit?usp=sharing


I put a couple boxes on the form, no code under them.


K
 
You must log in or register to reply here.
Back
Top