Re: $$Excel-Macros$$ stock on hand report generate

2011-09-02 Thread Satish Bandaru
On Fri, Sep 2, 2011 at 5:59 PM, dguillett1 wrote: > > I would suggest a different structure something like this with all on one > line and use filters and SUBTOTAL(109 > date > item > scheme > recd > issued > on hand > Thanks for your kind suggestion.I will try this. Thanks again -- -

Re: $$Excel-Macros$$ stock on hand report generate

2011-09-02 Thread dguillett1
I would suggest a different structure something like this with all on one line and use filters and SUBTOTAL(109 date item scheme recd issued on hand From: Satish Bandaru Sent: Friday, September 02, 2011 4:17 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ stock on

Re: $$Excel-Macros$$ stock on hand report generate

2011-09-02 Thread Satish Bandaru
hi venkat sure see attached copy help on user form to enter reciepts and issues. thanks in advance. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

Re: $$Excel-Macros$$ stock on hand report generate

2011-08-30 Thread Venkat CV
Hi Jasmin, Share some sample data... *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 10:27 PM, jasmin wrote: > 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 tw

$$Excel-Macros$$ stock on hand report generate

2011-08-30 Thread jasmin
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 ad