MrExcel Publishing
Your One Stop for Excel Tips & Solutions

New to this


Posted by Roy on June 13, 2001 1:11 PM

I am trying to develop a system to automate a manual task in work. I need to generate a database of information from drumming operations that take place. I want to be able to choose from a list of products to drum and automatically generate the next batch number for that particular product. When the drumming has been completed i want the user to input the amount of drums done and input this figure. I then want this to be stored on a worksheet/database with date time product amount drummed etc....

I am totally new to this so any help code tips macro's etc would be greatly appreciated.

Thanks for any help

Roy


Posted by Joe Was on June 13, 2001 3:18 PM

Will you select only one cell for product or do you want to custom mix product to each drumming op? (That is combine cells to create a list of items, drummed under one batch number?)
Is the batch number a product number with a date or is it a serial number?

Product Stock Last Batch
1 Glycerol 12345 33
2 Glycerin 67890 121
...

If your data sheet has this data and you batch sheet is setup as a printable form a VB macro could be made to; You select one product, press macro hot-key or Form Button, runs macro, copies data from data sheet to batch sheet form, batch number is increased by 1 as x=x+1, old data sheet batch number is deleted, data sheet batch number cell is updated with new last batch number.
Is this what you would like to do?
Please supply more iinformation. JSW