Hello Dear,
Use the following instruction.
Select Range
Data Menu
Pivot Table And Pivot Chart Report
Next("Follow the instruction")
or go to link below
http://www.cpearson.com/excel/pivots.htm
http://www.contextures.com/xlpivot07.html
Hope it Will Help
Happy to Help
:)
Shyam
On Tue, Apr 6, 2010 at 11:47 AM, Sarvesh <sarve...@yahoo.com> wrote:
> hi
> thanks for your help.
>
> what you are doing is right..but i dont knwo pivot table and how did u do
> it...any tutorial for the same...?
>
>
>
> regards,
> *sarvesh lahoti.*
>
>
> --- On *Tue, 6/4/10, rf1234 rf1234 <rfhyd1...@gmail.com>* wrote:
>
>
> From: rf1234 rf1234 <rfhyd1...@gmail.com>
> 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 your problem.
>
>
>
>
>
>
>
>
>
>
>
> Hope it Will Help
> Happy to Help
> :)
> Shyam
>
>
>
>
>
>
>
>
> On Mon, Apr 5, 2010 at 7:35 PM, Sarvesh
> <sarve...@yahoo.com<http://mc/compose?to=sarve...@yahoo.com>
> > wrote:
>
>>
>> hi
>>
>> firstly r u from hyderabad... just felt so with ur mail id.( i am from
>> hyderabad)
>>
>> i am attaching my actual file. plz go thru it.
>>
>> thanks a ton.
>>
>>
>> regards,
>> *sarvesh lahoti.*
>>
>>
>> --- On *Mon, 5/4/10, rf1234 rf1234
>> <rfhyd1...@gmail.com<http://mc/compose?to=rfhyd1...@gmail.com>
>> >* wrote:
>>
>>
>> From: rf1234 rf1234
>> <rfhyd1...@gmail.com<http://mc/compose?to=rfhyd1...@gmail.com>
>> >
>> Subject: Re: $$Excel-Macros$$ hi-help required .
>> To:
>> excel-macros@googlegroups.com<http://mc/compose?to=excel-mac...@googlegroups.com>
>> Cc: sarve...@yahoo.com <http://mc/compose?to=sarve...@yahoo.com>
>> Date: Monday, 5 April, 2010, 5:03 PM
>>
>>
>> Hello Dear,
>> Following attachment have a solution regarding your problem.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Hope it Will Help
>> Happy to Help
>> :)
>> Shyam
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh
>> <sarve...@yahoo.com<http://mc/compose?to=sarve...@yahoo.com>
>> > 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 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 480*12
>>> Pet 131 480*12 Pet 7 480*12 Pet 56 480*12 Pet 12 480*12 Pet 91
>>>
>>> daily some sizes and qty are added , deleted, modified.
>>>
>>> i need to know the total requirement of each size eg: 480*12 pet
>>> =+131+7+56+12+91 which is 297.
>>>
>>> same way need for all the sizes. the list is very big.
>>>
>>> i am not familiar with macros , any other formulae based solution will be
>>> helpful.
>>>
>>> thanks
>>>
>>>
>>> regards,
>>> *sarvesh lahoti.*
>>>
>>> ------------------------------
>>> Your Mail works best with the New Yahoo Optimized IE8. Get it
>>> NOW!<http://in.rd.yahoo.com/tagline_ie8_new/*http://downloads.yahoo.com/in/internetexplorer/>.
>>>
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our Facebook Group @
>>> http://www.facebook.com/group.php?gid=287779555678
>>> 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<http://mc/compose?to=excel-mac...@googlegroups.com>
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>>
>>
>> --
>>
>> Thanks Regards
>> Shyam
>> Software Engineer
>>
>> ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
>> When one door of happiness closes, another opens;
>> but often we look so long at the closed door that we do not see the
>> one which has been opened for us.
>> - Helen Keller
>>
>> ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
>> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
>> aber oft schauen wir so lange auf die geschlossene Tür,
>> dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
>>
>> ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 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<http://mc/compose?to=excel-mac...@googlegroups.com>
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>>
>> ------------------------------
>> The INTERNET now has a personality. YOURS! See your Yahoo!
>> Homepage<http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/>
>> .
>>
>
>
>
> --
>
> Thanks Regards
> Shyam
> Software Engineer
>
> ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
> When one door of happiness closes, another opens;
> but often we look so long at the closed door that we do not see the
> one which has been opened for us.
> - Helen Keller
>
> ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
> aber oft schauen wir so lange auf die geschlossene Tür,
> dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
>
> ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
>
>
> ------------------------------
> Your Mail works best with the New Yahoo Optimized IE8. Get it
> NOW!<http://in.rd.yahoo.com/tagline_ie8_new/*http://downloads.yahoo.com/in/internetexplorer/>
> .
>
--
Thanks Regards
Shyam
Software Engineer
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
When one door of happiness closes, another opens;
but often we look so long at the closed door that we do not see the
one which has been opened for us.
- Helen Keller
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
