Hi all, I am hoping to find something to help me with a problem. I have searched all over the web and through the forum and cannot seem to find anything that will do what I need.

I am trying to set up an excel sheet or a access database, etc, that can keep track of individual bag numbers. We manufacture products which each get allocated a unique bag number. I would like a system that will keep track of what numbers are made, what numbers remain in stock, what numbers have been sold and to whom.

I am quite familiar with excel and functions / formulas but not so much with macros.

Option One:
Using a spreadsheet which has the bag numbers vertically, adding to down the list as more are made. Adding orders horizontally each week then checking off which numbers have gone with that order. Stock is in the 1000s with weekly movements in the 100s. So inputting data into a table or spreadsheet would not be very efficient.

Is there a way to automatically insert a range of numbers, using a macro or function, so if I say range 1 - 300 and specify the cells it will insert the numbers 1 - 300 consecutively in the specified cells?

Also I would then need a method of transposing those bags remainging (unchecked) into a more conpact form, preferably a table of the range of bag numbers remaining.

Option Two:
Using MS Access to keep a database - but again entering all the individual bag numbers would be time consuming.


Any suggestions would be grately appreciated. If anyone knows of a function that might help or a downloadable macro or template - or any other possible methods to solve the problem.