subject:"$$Excel\-Macros$$ hi\-help required ."

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

2010-04-06 Thread Sarvesh

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: 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  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  wrote:



From: rf1234 rf1234 
Subject: Re: $$Excel-Macros$$ hi-help required .

To: excel-macros@googlegroups.com
Cc: 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  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!. 
-- 
--
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




-- 

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
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

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

2010-04-06 Thread Hemant K

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  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!.
>
>
> --
>
> --
> 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
>



-- 
Regards

Hemant Koranne
Check out my web site for learning excel
http://exceltnt.blogspot.com/

-- 
--
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

To unsubscribe, reply using "remove me" as the subject.


Solution.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

2010-04-06 Thread rf1234 rf1234

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  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 * 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 your problem.
>
>
>
>
>
>
>
>
>
>
>
> Hope it Will Help
> Happy to Help
> :)
> Shyam
>
>
>
>
>
>
>
>
> On Mon, Apr 5, 2010 at 7:35 PM, Sarvesh 
> 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 
>> http://mc/compose?to=rfhyd1...@gmail.com>
>> >* wrote:
>>
>>
>> From: rf1234 rf1234 
>> 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 
>> 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>
>>>
>>> <><><><><><><><><><><><><><><><><><><><>

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

2010-04-05 Thread Sarvesh


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.


  The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. 
http://in.yahoo.com/

-- 
--
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

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

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

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

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

4 matches

Site Navigation

Mail list logo

Footer information