Re: $$Excel-Macros$$ hi-help required .

thanks ..thanks a lot. one little doubt...if i delete or add a qty in the list...then pivot table is not updated immediately ? i need it to be updated regards,sarvesh lahoti. --- On Tue, 6/4/10, rf1234 rf1234 wrote: From: rf1234 rf1234 Subject: Re: $$Excel-Macros$$ hi-help required . To

Re: $$Excel-Macros$$ hi-help required .

Here is the solution attached you can do it with the help of sumproduct formula or with Sumif Formula Regards Hemant On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh wrote: > > hi > > i have a worksheet where sizes and qty are maintained for each item in this > way > > 460*12 Pet 31 460*12 Pet 265 46

Re: $$Excel-Macros$$ hi-help required .

6/4/10, rf1234 rf1234 * wrote: > > > From: rf1234 rf1234 > Subject: Re: $$Excel-Macros$$ hi-help required . > To: excel-macros@googlegroups.com > Cc: sarve...@yahoo.com > Date: Tuesday, 6 April, 2010, 10:52 AM > > > Hello Dear, > Attached workbook has a sample for yo

$$Excel-Macros$$ hi-help required .

hi  i have a worksheet where sizes and qty are maintained for each item in this way 460*12 Pet 31 460*12 Pet 265 460*12 Pet 340 460*12 Pet 392 460*12 Pet 523 460*12 Pet 150 470*12 Pet 35 470*12 Pet 212 470*12 Pet 159