I think you are asking for something which is more than a 'simple routine' as
you want to include forms , a report, error checking and updating of multiple
w/sheets. This not a trivial task and would require a detailed
specification.


"Sinner" wrote:

Hi,

I need to automate a simple routine.

I have a excel workbook with multiple sheets (catalogs).
Each catalog has seperate inventory items placed under columns such as
item name, serial number, location, issuance date, track# etc.

Whenever I receive an item, I book it in respective catalog.
For that I need a form in which I can select specific catalog & then
book the items. The form should have a 'browse to file' option which
will allow flexibility to user to load bulk serial numbers compiled in
another excel sheet to a specific catalog.

I need another form to mark items issued at time of issuance. The form
will get the start & end serial & mark 'Issued' with issuance date &
track#.

At the end of a term, let's say month end, I have a sale sheet which
has all the sold pins in seperate column( I compile that manually ). I
need to update the master log by removing all the sold pins from that.
If possible, I should also have a report in case a pin is removed as
sold but not issued for sale like a user might key punch 25 as 52 and
so when I compile the sale sheet manually, 52 will be removed from
master but 52 was never issued for sale. For this I need some sort of
validation which would restrict the master log not to delete items
which have never been issued.