Hi all experts

i have a small store which contains 300 products( MEDICINES).in a
quarter i reviced the items once or twice.But i issue items to various
dept twice in a week or thrice in fortnight.My requirement is

1.on item recieved to my store i enter all items in reciept colum.The
qty should add the previous balance
2. if i issue the qty should deduct.

3 on end of the month stock on hand report shoud generte to print ( if
it possibe with expiry date).

Please help me in excel is it possibel with vba code Like Reciepts,
Issues,Reports, Departments(to select which i issue) user form. and
data management information .


thanks in advance

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to