Updating Master Log records
 

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.

Updating Master Log records
 

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.

Updating Master Log records
 

Thanks Toppers : )

I can send you sample of each in xl with detailed specification /
requirments.
Let me know if that's fine with you.

BR
S i n n e r ~ ~

Updating Master Log records
 

OK... I'll take a look and see what's involved.

post to:

toppers at REMOVETHISjohntopley.fsnet.co.uk

"Sinner" wrote:

Thanks Toppers : )

I can send you sample of each in xl with detailed specification /
requirments.
Let me know if that's fine with you.

BR
S i n n e r ~ ~

Updating Master Log records
 

Dear toppers the mail bounced back saying content not allowed.

Its a simple xl file of 50 KB..

You email me at imsguyATgmail.com so tht I can reply back.

Thx.

Updating Master Log records
 

Dear Toppers,

Can I have your e-mail add??

Thx

Updating Master Log records
 

I sent e-mail to you several days ago; plus my address is in previous posting.

Just re-sent (1:15 UK time 12 June)

"Sinner" wrote:

Dear Toppers,

Can I have your e-mail add??

Thx

Updating Master Log records
 

Dear sorry abt the delay.

I have emailed you.

Thx.