Re: $$Excel-Macros$$ Vlookup with 2 criteria

[Venkat CV]

Hi Srinivas,

Try the formula...and look attached sample...

*=SUMPRODUCT(($C$3:$C$5=G3)*($D$3:$D$5=H3)*($E$3:$E$5))*



On Tue, Aug 30, 2011 at 11:43 PM, Shrinivas Shevde
wrote:

> Dear all
> Can I use Vlookup with 2 criteria?
> If Yes please let me know
>
>
> --
> Shrini
>
> --
>
> --
> 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
>



-- 
*Best Regards,*
*Venkat *
*Chennai*
*
*
*
*

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


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

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

[Venkat CV]

Hi Rajan,

Nice Array formula & Sumproduct superb solution...

*Best Regards,*
*Venkat *
*Chennai*
*
*

On Tue, Aug 30, 2011 at 10:34 PM, Rajan_Verma wrote:

>  *See the attached *
>
> * *
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Venkat CV
> *Sent:* Wednesday, August 31, 2011 7:33 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS
> Excel 2003
>
>  ** **
>
> Hi Amit
>
> ** **
>
> See below link for Sumifs in 2003
>
> http://chandoo.org/forums/topic/converting-sumifs-to-excel-2003 
>
> ** **
>
> -- 
>
> *Best Regards,*
>
> *Venkat *
>
> *Chennai*
>
> ** **
>
> ** **
>
> On Tue, Aug 30, 2011 at 9:54 PM, Amit Desai (MERU) <
> amit.de...@merucabs.com> wrote:
>
> Dear All,
>
>  
>
> Do we have any option for countifs & Sumifs formula in MS Excel 2003?
>
>  
>
> Best Regards,
>
> Amit Desai
>
>  
>
> ** **
>  --
>
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
>
> --
> 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
>
>
>
> 
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> --
>
> --
> 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
>
> --
>
> --
> 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
>



-- 
*
*
*
*

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

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

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



-- 
*
*
*
*

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

RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

[Rajan_Verma]

See the attached 

 

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Wednesday, August 31, 2011 7:33 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS
Excel 2003

 

Hi Amit

 

See below link for Sumifs in 2003

http://chandoo.org/forums/topic/converting-sumifs-to-excel-2003 

 

-- 

Best Regards,

Venkat 

Chennai

 

 

On Tue, Aug 30, 2011 at 9:54 PM, Amit Desai (MERU) 
wrote:

Dear All,

 

Do we have any option for countifs & Sumifs formula in MS Excel 2003?

 

Best Regards,

Amit Desai

 

 

  _  

Disclaimer: This message and its attachments contain confidential
information and may also contain legally privileged information. This
message is intended solely for the named addressee. If you are not the
addressee indicated in this message (or authorized to receive for
addressee), you may not copy or deliver any part of this message or its
attachments to anyone or use any part of this message or its attachments.
Rather, you should permanently delete this message and its attachments (and
all copies) from your system and kindly notify the sender by reply e-mail.
Any content of this message and its attachments that does not relate to the
official business of Meru Cab Company Pvt. Ltd. must be taken not to have
been sent or endorsed by any of them. Email communications are not private
and no warranty is made that e-mail communications are timely, secure or
free from computer virus or other defect.

-- 

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





 

 

 

 

 

-- 

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

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


Book1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

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

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

RE: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...

[Rajan_Verma]

Sir ji EK sample file attached Kar do ..

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of B Sharma
Sent: Wednesday, August 31, 2011 9:24 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ How to use Multiple criteria in DSUM
function...

Yes Rajan,
You are right  I am using the same for the time being...
but I wanted to use this through Dsum... anyways ... thanks for your
time...






On Aug 30, 7:32 pm, "Rajan_Verma"  wrote:
> Hi Bajrang,
> You can use sumifs() Function for this I think, or attached a sample file
to
> better understand your Query,
>
> Rajan.
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of B Sharma
> Sent: Tuesday, August 16, 2011 12:53 PM
> To: MS EXCEL AND VBA MACROS
> Cc: rajanverma1...@gmail.com
> Subject: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...
>
> Hello to Excel Experts and other users of this group.
>
> I've been looking everywhere   about how to put several criteria in
> different cell ranges in:
>
> DSUM(database, field, criteria).
>
> I have a very large database and using Dsum and I am using different
> different criteria  in different different columns.
>
> Normally you put for example A1:G2 and everything works fine. Now the
> problem is that I have quite many criterias that are common for
> several DSUM() and I would like to split the criterias into for
> example A1:D2 and G1:G2.
>
> I've triad DSUM(database, field, {A1:D2, G1:G2}) (cannot use arrays
> with refernces..),
> DSUM(database, field, A1:D2, G1:G2) (too many arguments..).. etc.
>
> What can I do?
>
> If anyone has an idea please let me know !!
>
> B. Sharma
>
> --
>
---
-
> --
> 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 athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below
linkhttp://www.facebook.com/discussexcel

-- 

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

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

RE: $$Excel-Macros$$ Decimal greater than 0.5

[Rajan_Verma]

You can also use this :

 

=MROUND(B5,1)

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Wednesday, August 31, 2011 10:07 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Decimal greater than 0.5

 

Hi,

 

try Round formula Example Below

 

=ROUND(A1,0)

 

Best Regards,

Venkat 

Chennai

 

 

On Tue, Aug 30, 2011 at 10:54 PM, Skanda  wrote:

Hi All,

 How to convert the numbers in a column based on following:

 example:

13.45 should be displayed as 13

13.5 or 13.51(decimal equal or greater than .5) should be 14.

 

 

-- 

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





 

-- 

 

 

 

 

-- 

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

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

RE: $$Excel-Macros$$ Combox List in Userform

[Rajan_Verma]

See attached file..

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mr Excellent
Sent: Wednesday, August 31, 2011 10:20 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Combox List in Userform

 

Hi All,

 

Attached is the sheet where i need the data to be loaded Combo box of the
userform given, i need  a VBA Code which picks the data from the excel
spread sheet and provides them in the combo box as a drop down list..please
help

 

Thanks

Prasad.

-- 

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

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


Copy of Country.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Combox List in Userform

[Mr Excellent]

Hi All,

Attached is the sheet where i need the data to be loaded Combo box of the
userform given, i need  a VBA Code which picks the data from the excel
spread sheet and provides them in the combo box as a drop down list..please
help

Thanks
Prasad.

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


Country.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Decimal greater than 0.5

[Venkat CV]

Hi,

try Round formula Example Below

=ROUND(A1,0)

*Best Regards,*
*Venkat *
*Chennai*
*
*

On Tue, Aug 30, 2011 at 10:54 PM, Skanda  wrote:

> Hi All,
>  How to convert the numbers in a column based on following:
>  example:
> 13.45 should be displayed as 13
> 13.5 or 13.51(decimal equal or greater than .5) should be 14.
>
>
>  --
>
> --
> 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
>



-- 
*
*
*
*

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

Re: $$Excel-Macros$$ Attach file for discussion

[Venkat CV]

Hi,

In your G mail   Just  click Compose Mail and attach and write your query
and send it to

*excel-macros@googlegroups.com*

*Best Regards,*
*Venkat *
*Chennai*

On Wed, Aug 31, 2011 at 2:47 AM, Tripp  wrote:

> How can I attach a spreadsheet for review?
>
> --
>
> --
> 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
>



-- 
*
*
*
*
*
*

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

Re: $$Excel-Macros$$ Macro to remove repeats and merge

[Venkat CV]

Hi,

You can try Remove duplicate's option in Excel 2007 or 2010 use ALT+A+T

*Best Regards,*
*Venkat *
*Chennai*

On Wed, Aug 31, 2011 at 2:44 AM, Gaetan M  wrote:

> I have the following:
>
> Column A  B   C D
> E F
> 12722 12722 51.564.89   RNLOX
> 12723 12723 51.564.89   RNLOX
>
> Would you have the solution to replace B1 by B2 and delete row 2 once
> completed since they have been merge?
>
> Thanks,
>
> G.
>
> --
>
> --
> 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
>



-- 
*
*
*
*
*
*

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

$$Excel-Macros$$ Decimal greater than 0.5

[Skanda]

Hi All,
 How to convert the numbers in a column based on following:
 example:
13.45 should be displayed as 13
13.5 or 13.51(decimal equal or greater than .5) should be 14.

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

$$Excel-Macros$$ Attach file for discussion

[Tripp]

How can I attach a spreadsheet for review?

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

$$Excel-Macros$$ Macro to remove repeats and merge

[Gaetan M]

I have the following:

Column A  B   C D
E F
12722 12722 51.564.89   RNLOX
12723 12723 51.564.89   RNLOX

Would you have the solution to replace B1 by B2 and delete row 2 once
completed since they have been merge?

Thanks,

G.

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

Re: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...

[B Sharma]

Yes Rajan,
You are right  I am using the same for the time being...
but I wanted to use this through Dsum... anyways ... thanks for your
time...






On Aug 30, 7:32 pm, "Rajan_Verma"  wrote:
> Hi Bajrang,
> You can use sumifs() Function for this I think, or attached a sample file to
> better understand your Query,
>
> Rajan.
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of B Sharma
> Sent: Tuesday, August 16, 2011 12:53 PM
> To: MS EXCEL AND VBA MACROS
> Cc: rajanverma1...@gmail.com
> Subject: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...
>
> Hello to Excel Experts and other users of this group.
>
> I've been looking everywhere   about how to put several criteria in
> different cell ranges in:
>
> DSUM(database, field, criteria).
>
> I have a very large database and using Dsum and I am using different
> different criteria  in different different columns.
>
> Normally you put for example A1:G2 and everything works fine. Now the
> problem is that I have quite many criterias that are common for
> several DSUM() and I would like to split the criterias into for
> example A1:D2 and G1:G2.
>
> I've triad DSUM(database, field, {A1:D2, G1:G2}) (cannot use arrays
> with refernces..),
> DSUM(database, field, A1:D2, G1:G2) (too many arguments..).. etc.
>
> What can I do?
>
> If anyone has an idea please let me know !!
>
> B. Sharma
>
> --
> --- -
> --
> 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 athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel

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

Re: $$Excel-Macros$$ Calculate Product Sold To Date by Product

[Venkat CV]

Hi john,

Try the Below...

=SUMIF($B$2:$B$8,B2,$D$2:$D$8)

*Best Regards,*
*Venkat *
*Chennai*
*
*

On Tue, Aug 30, 2011 at 9:39 PM, John A. Smith wrote:

> Your help please.  I have a log of product sold and need to calculate the
> different product sold to date, like a running accumulation field specific
> to product listed in column B.
>
> Please see my attached spreadsheet.  Thanking you in advance for all your
> great help.
>
> John
>
> --
>
> --
> 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
>



-- 
*
*
*
*

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

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

[Venkat CV]

Hi Amit

See below link for Sumifs in 2003
http://chandoo.org/forums/topic/converting-sumifs-to-excel-2003

-- 
*Best Regards,*
*Venkat *
*Chennai*
*
*

On Tue, Aug 30, 2011 at 9:54 PM, Amit Desai (MERU)
wrote:

>  Dear All,
>
> ** **
>
> Do we have any option for countifs & Sumifs formula in MS Excel 2003?
>
> ** **
>
> Best Regards,
>
> Amit Desai
>
> ** **
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
>
> --
> 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
>



*
*
*
*

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

Re: $$Excel-Macros$$ User form

[Venkat CV]

Hi Surya,

Try the Below...

*Private Sub Workbook_Open()*
*UserForm1.show*
*End Sub*


*Best Regards,*
*Venkat *
*Chennai*
*
*


On Tue, Aug 30, 2011 at 9:00 PM, Suryaprasad wrote:

> Hi Venkat,
>
> Sorry for the wrong attachment, here is the updated one.
>
> What i need is when i open the spread sheet the form should POP
> automatically.
>
> Thanks
> Prasad.
>
>
> On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV  wrote:
>
>> Hi Surya,
>>
>> Your excel sheet is empty..Please check..
>>
>>  *Best Regards,*
>> *Venkat *
>> *Chennai*
>> *
>> *
>> *
>> *
>>
>>   On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad 
>> wrote:
>>
>>> Hi ,
>>>
>>> Please see my excel spread sheet i need the userform as POP see the chail
>>> mail
>>>
>>> Thanks
>>> Prasad
>>>   On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 wrote:
>>>
   What userform? Put this in the ThisWorkbook module

 Private Sub Workbook_Open()
 nameofyouruserformhere.Show
 End Sub

  *From:* Suryaprasad 
 *Sent:* Tuesday, August 30, 2011 7:42 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ User form

   Hi All,

 Need  a small help , i need to get a pop up of the user form when my
 excel is opened, see the attachment

 Thanks
 Prasad.
 --

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

 --

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

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



-- 
*
*
*
*

-- 
--

Re: $$Excel-Macros$$ Re: Need macro to split the files

[ChilExcel]

I have also created thousands of functions, and PivotTables

you're asking or you're selling web site?



2011/8/30 Frederic LE GUEN - MVP Excel 

> Hi
> I have written today a page about the way to create a worksheet
> function of a criteria
> http://www.excel-exercice.com/en/2074/creation-of-worksheets-by-criteria
>
> I'm sure that this tip will help you ;)
>
> On 30 août, 06:52, anu gomathi  wrote:
> > Hi Experts,
> >
> > I am very new to this forum.
> >
> > Attached the details report & the out put file. I need a macro to split
> the
> > workbook as per the below condition:
> >
> > The detail report file should be splitted based on the divisional lead &
> > regional lead.
> >
> > Condition 1: while splitting the file summary should be there in the
> summary
> > sheet. Better the formula would be useful instead of values.
> >
> > Condition2 : The Qtr code Q1 Fy12 details should come in the summary
> sheet &
> > rest all the qtr's should be in details sheet.
> >
> > Please help me in this.
> >
> > Thanks in advance.
> >
> > Regards
> >
> > Anu
> >
> >  Detail report.xls
> > 1506KAfficherTélécharger
> >
> >  Andy Huntrods-SI Report-010811.xls
> > 104KAfficherTélécharger
>
> --
>
> --
> 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
>



-- 
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41

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

$$Excel-Macros$$ Re: Need macro to split the files

[Frederic LE GUEN - MVP Excel]

Hi
I have written today a page about the way to create a worksheet
function of a criteria
http://www.excel-exercice.com/en/2074/creation-of-worksheets-by-criteria

I'm sure that this tip will help you ;)

On 30 août, 06:52, anu gomathi  wrote:
> Hi Experts,
>
> I am very new to this forum.
>
> Attached the details report & the out put file. I need a macro to split the
> workbook as per the below condition:
>
> The detail report file should be splitted based on the divisional lead &
> regional lead.
>
> Condition 1: while splitting the file summary should be there in the summary
> sheet. Better the formula would be useful instead of values.
>
> Condition2 : The Qtr code Q1 Fy12 details should come in the summary sheet &
> rest all the qtr's should be in details sheet.
>
> Please help me in this.
>
> Thanks in advance.
>
> Regards
>
> Anu
>
>  Detail report.xls
> 1506KAfficherTélécharger
>
>  Andy Huntrods-SI Report-010811.xls
> 104KAfficherTélécharger

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

Re: $$Excel-Macros$$ Re: Need macro to split the files

[ChilExcel]

Please attach file



2011/8/30 anu gomathi 

> Hi,
>
> Can u pls explain me the steps. Any way i need the summary in the detail
> sheet.
>
> Regards
> Anu
>
>   On Tue, Aug 30, 2011 at 2:52 PM, Frederic LE GUEN - MVP Excel <
> fleg...@gmail.com> wrote:
>
>> Why don't you use a pivot table with the table option to split your
>> document by Division and Regional lead ?
>>
>>
>> On 30 août, 06:52, anu gomathi  wrote:
>> > Hi Experts,
>> >
>> > I am very new to this forum.
>> >
>> > Attached the details report & the out put file. I need a macro to split
>> the
>> > workbook as per the below condition:
>> >
>> > The detail report file should be splitted based on the divisional lead &
>> > regional lead.
>> >
>> > Condition 1: while splitting the file summary should be there in the
>> summary
>> > sheet. Better the formula would be useful instead of values.
>> >
>> > Condition2 : The Qtr code Q1 Fy12 details should come in the summary
>> sheet &
>> > rest all the qtr's should be in details sheet.
>> >
>> > Please help me in this.
>> >
>> > Thanks in advance.
>> >
>> > Regards
>> >
>> > Anu
>> >
>> >  Detail report.xls
>> > 1506KAfficherTélécharger
>> >
>> >  Andy Huntrods-SI Report-010811.xls
>> > 104KAfficherTélécharger
>>
>> --
>>
>> --
>> 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
>>
>
> --
>
> --
> 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
>



-- 
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41

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

Re: $$Excel-Macros$$ Calculate Product Sold To Date by Product

[John A. Smith]

Thank you very much for your quick response, your patience and your help.

John

On Tue, Aug 30, 2011 at 12:37 PM, dguillett1  wrote:

>  in d2 copied down
> =SUMIF($B$2:B2,B2,$C$2:C2)
>
>  *From:* John A. Smith 
> *Sent:* Tuesday, August 30, 2011 11:09 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Calculate Product Sold To Date by Product
>
>   Your help please.  I have a log of product sold and need to calculate
> the different product sold to date, like a running accumulation field
> specific to product listed in column B.
>
> Please see my attached spreadsheet.  Thanking you in advance for all your
> great help.
>
> John
> --
>
> --
> 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
>
> --
>
> --
> 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
>

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

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

[dguillett1]

TRY it!!!

From: Amit Desai (MERU) 
Sent: Tuesday, August 30, 2011 12:18 PM
To: excel-macros@googlegroups.com 
Subject: RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 
2003

But what if I need a count (& not sum)of numbers in a cell?

 

Best Regards,

Amit Desai

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of dguillett1
Sent: Tuesday, August 30, 2011 10:41 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 
2003

 

=sumproduct((a2:a22=1)*(b2:b22))

 

From: Amit Desai (MERU) 

Sent: Tuesday, August 30, 2011 12:03 PM

To: excel-macros@googlegroups.com 

Subject: RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 
2003

 

What about option for countifS?

 

Best Regards,

Amit Desai

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of dguillett1
Sent: Tuesday, August 30, 2011 10:04 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 
2003

 

=sumproduct((a2:a22=1)*b2:b22)

From: Amit Desai (MERU) 

Sent: Tuesday, August 30, 2011 11:24 AM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

 

Dear All,

 

Do we have any option for countifs & Sumifs formula in MS Excel 2003?

 

Best Regards,

Amit Desai

 

 




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
-- 
--
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

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

 




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailyt

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

[Kiran Kancherla]

Amit

=sumproduct((a2:a22=1)*(b2:b22<>"")) 
This is the easiest way to do this.


Sent on my BlackBerry® from Vodafone
Thanks & Regards.
Kiran

-Original Message-
From: "Amit Desai (MERU)" 
Sender: excel-macros@googlegroups.com
Date: Tue, 30 Aug 2011 22:48:06 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 
2003

But what if I need a count (& not sum)of numbers in a cell?

Best Regards,
Amit Desai

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of dguillett1
Sent: Tuesday, August 30, 2011 10:41 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 
2003

=sumproduct((a2:a22=1)*(b2:b22))

From: Amit Desai (MERU)
Sent: Tuesday, August 30, 2011 12:03 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 
2003

What about option for countifS?

Best Regards,
Amit Desai

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of dguillett1
Sent: Tuesday, August 30, 2011 10:04 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 
2003

=sumproduct((a2:a22=1)*b2:b22)
From: Amit Desai (MERU)
Sent: Tuesday, August 30, 2011 11:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

Dear All,

Do we have any option for countifs & Sumifs formula in MS Excel 2003?

Best Regards,
Amit Desai



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
--
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
--
--
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


Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
--

RE: $$Excel-Macros$$ How to load data into Combo box in user form

[Rajan_Verma]

See the attached Sheet..

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rakesh Joshi
Sent: Tuesday, August 30, 2011 9:29 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to load data into Combo box in user form

 

Go to Property of Combo box type the Range under the row source of
Combobox.:

On Tue, Aug 30, 2011 at 9:09 PM, Suryaprasad 
wrote:

Hi All,

 

Attached is the sheet where i need the list of the countries to be added to
the combo box

 

Note : The Combo box should be enabled once the data is entered in Text Box
given above of Combo box.

 

Please do the needfull.

 

Thanks

Prasad

-- 

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





 

-- 
Rakesh Joshi

-- 

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

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


Combo.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

[Amit Desai (MERU)]

But what if I need a count (& not sum)of numbers in a cell?

Best Regards,
Amit Desai

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of dguillett1
Sent: Tuesday, August 30, 2011 10:41 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 
2003

=sumproduct((a2:a22=1)*(b2:b22))

From: Amit Desai (MERU)
Sent: Tuesday, August 30, 2011 12:03 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 
2003

What about option for countifS?

Best Regards,
Amit Desai

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of dguillett1
Sent: Tuesday, August 30, 2011 10:04 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 
2003

=sumproduct((a2:a22=1)*b2:b22)
From: Amit Desai (MERU)
Sent: Tuesday, August 30, 2011 11:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

Dear All,

Do we have any option for countifs & Sumifs formula in MS Excel 2003?

Best Regards,
Amit Desai



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
--
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
--
--
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


Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
--
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 

Re: $$Excel-Macros$$ How to load data into Combo box in user form

[Mr Excellent]

Hi Rajan,

Thanks for the attachment, but my requirement is to add the list in the
Userform provided in excel sheet not on the excel spread sheet.

Note : The Combo box should be enabled once the data is entered in Text Box
given above of Combo box.

Please do the needfull.

Thanks
Prasad

On Tue, Aug 30, 2011 at 9:33 PM, Rajan_Verma wrote:

>  *See the attached *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rakesh Joshi
> *Sent:* Tuesday, August 30, 2011 9:29 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ How to load data into Combo box in user
> form
>
> ** **
>
> Go to Property of Combo box type the Range under the row source of
> Combobox.:
>
> On Tue, Aug 30, 2011 at 9:09 PM, Suryaprasad 
> wrote:
>
> Hi All,
>
>  
>
> Attached is the sheet where i need the list of the countries to be added to
> the combo box
>
>  
>
> Note : The Combo box should be enabled once the data is entered in Text Box
> given above of Combo box.
>
>  
>
> Please do the needfull.
>
>  
>
> Thanks
>
> Prasad
>
> --
>
> --
> 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
>
>
>
> 
>
> ** **
>
> --
> Rakesh Joshi
>
> --
>
> --
> 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
>
> --
>
> --
> 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
>

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

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

[dguillett1]

=sumproduct((a2:a22=1)*(b2:b22))

From: Amit Desai (MERU) 
Sent: Tuesday, August 30, 2011 12:03 PM
To: excel-macros@googlegroups.com 
Subject: RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 
2003

What about option for countifS?

 

Best Regards,

Amit Desai

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of dguillett1
Sent: Tuesday, August 30, 2011 10:04 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 
2003

 

=sumproduct((a2:a22=1)*b2:b22)

From: Amit Desai (MERU) 

Sent: Tuesday, August 30, 2011 11:24 AM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

 

Dear All,

 

Do we have any option for countifs & Sumifs formula in MS Excel 2003?

 

Best Regards,

Amit Desai

 

 




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
-- 
--
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

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




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
-- 
--
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

-- 
--
Some important links fo

RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

[Amit Desai (MERU)]

What about option for countifS?

Best Regards,
Amit Desai

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of dguillett1
Sent: Tuesday, August 30, 2011 10:04 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 
2003

=sumproduct((a2:a22=1)*b2:b22)
From: Amit Desai (MERU)
Sent: Tuesday, August 30, 2011 11:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

Dear All,

Do we have any option for countifs & Sumifs formula in MS Excel 2003?

Best Regards,
Amit Desai



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
--
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
--
--
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


Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

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

Re: $$Excel-Macros$$ Calculate Product Sold To Date by Product

[dguillett1]

  in d2 copied down
  =SUMIF($B$2:B2,B2,$C$2:C2) 


From: John A. Smith 
Sent: Tuesday, August 30, 2011 11:09 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Calculate Product Sold To Date by Product

Your help please.  I have a log of product sold and need to calculate the 
different product sold to date, like a running accumulation field specific to 
product listed in column B.

Please see my attached spreadsheet.  Thanking you in advance for all your great 
help.

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

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

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

[dguillett1]

=sumproduct((a2:a22=1)*b2:b22)
From: Amit Desai (MERU) 
Sent: Tuesday, August 30, 2011 11:24 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

Dear All,

 

Do we have any option for countifs & Sumifs formula in MS Excel 2003?

 

Best Regards,

Amit Desai

 




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
-- 
--
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

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

$$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

[Amit Desai (MERU)]

Dear All,

Do we have any option for countifs & Sumifs formula in MS Excel 2003?

Best Regards,
Amit Desai



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

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

$$Excel-Macros$$ Calculate Product Sold To Date by Product

[John A. Smith]

Your help please.  I have a log of product sold and need to calculate the
different product sold to date, like a running accumulation field specific
to product listed in column B.

Please see my attached spreadsheet.  Thanking you in advance for all your
great help.

John

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


Accumulated Balance by Date.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ How to load data into Combo box in user form

[Rajan_Verma]

See the attached 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rakesh Joshi
Sent: Tuesday, August 30, 2011 9:29 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to load data into Combo box in user form

 

Go to Property of Combo box type the Range under the row source of
Combobox.:

On Tue, Aug 30, 2011 at 9:09 PM, Suryaprasad 
wrote:

Hi All,

 

Attached is the sheet where i need the list of the countries to be added to
the combo box

 

Note : The Combo box should be enabled once the data is entered in Text Box
given above of Combo box.

 

Please do the needfull.

 

Thanks

Prasad

-- 

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





 

-- 
Rakesh Joshi

-- 

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

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


Combo.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ How to load data into Combo box in user form

[Rakesh Joshi]

Go to Property of Combo box type the Range under the row source of
Combobox.:

On Tue, Aug 30, 2011 at 9:09 PM, Suryaprasad wrote:

> Hi All,
>
> Attached is the sheet where i need the list of the countries to be added to
> the combo box
>
> Note : The Combo box should be enabled once the data is entered in Text Box
> given above of Combo box.
>
> Please do the needfull.
>
> Thanks
> Prasad
>
> --
>
> --
> 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
>



-- 
Rakesh Joshi

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

$$Excel-Macros$$ How to load data into Combo box in user form

[Suryaprasad]

Hi All,

Attached is the sheet where i need the list of the countries to be added to
the combo box

Note : The Combo box should be enabled once the data is entered in Text Box
given above of Combo box.

Please do the needfull.

Thanks
Prasad

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


Combo.xlsm
Description: Binary data

Re: $$Excel-Macros$$ User form

[NOORAIN ANSARI]

Dear  surya,

Please see attached sheet..

On Tue, Aug 30, 2011 at 9:00 PM, Suryaprasad wrote:

> Hi Venkat,
>
> Sorry for the wrong attachment, here is the updated one.
>
> What i need is when i open the spread sheet the form should POP
> automatically.
>
> Thanks
> Prasad.
>
>
> On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV  wrote:
>
>> Hi Surya,
>>
>> Your excel sheet is empty..Please check..
>>
>>  *Best Regards,*
>> *Venkat *
>> *Chennai*
>> *
>> *
>> *
>> *
>>
>>   On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad 
>> wrote:
>>
>>> Hi ,
>>>
>>> Please see my excel spread sheet i need the userform as POP see the chail
>>> mail
>>>
>>> Thanks
>>> Prasad
>>>   On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 wrote:
>>>
   What userform? Put this in the ThisWorkbook module

 Private Sub Workbook_Open()
 nameofyouruserformhere.Show
 End Sub

  *From:* Suryaprasad 
 *Sent:* Tuesday, August 30, 2011 7:42 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ User form

   Hi All,

 Need  a small help , i need to get a pop up of the user form when my
 excel is opened, see the attachment

 Thanks
 Prasad.
 --

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

 --

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

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



-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* 

-- 
-

Re: $$Excel-Macros$$ User form

[Suryaprasad]

Hi Venkat,

Sorry for the wrong attachment, here is the updated one.

What i need is when i open the spread sheet the form should POP
automatically.

Thanks
Prasad.


On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV  wrote:

> Hi Surya,
>
> Your excel sheet is empty..Please check..
>
>  *Best Regards,*
> *Venkat *
> *Chennai*
> *
> *
> *
> *
>
>   On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad 
> wrote:
>
>> Hi ,
>>
>> Please see my excel spread sheet i need the userform as POP see the chail
>> mail
>>
>> Thanks
>> Prasad
>>   On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 wrote:
>>
>>>   What userform? Put this in the ThisWorkbook module
>>>
>>> Private Sub Workbook_Open()
>>> nameofyouruserformhere.Show
>>> End Sub
>>>
>>>  *From:* Suryaprasad 
>>> *Sent:* Tuesday, August 30, 2011 7:42 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ User form
>>>
>>>   Hi All,
>>>
>>> Need  a small help , i need to get a pop up of the user form when my
>>> excel is opened, see the attachment
>>>
>>> Thanks
>>> Prasad.
>>> --
>>>
>>> --
>>> 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
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
>
>
> --
>
> --
> 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
>

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


User.xlsm
Description: Binary data

Re: $$Excel-Macros$$ help

[NOORAIN ANSARI]

Dear Vijay,

if your Word in one cell you can use...

=PROPER(Trim(SUBSTITUTE(D4," ","")))

On Tue, Aug 30, 2011 at 7:26 PM, vijayajith VA wrote:

> Hi,
>
>  i have four words and i need to combine using trim and proper functions.
>
> Please can you provide me formula
>
> Thank you
>
> --
>
> --
> 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
>



-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.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 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

Re: $$Excel-Macros$$ any short key to remove double add.

[Venkat CV]

Hi Kannan,

In Excel 2007(or)2010 version Having Advanced filter option you can get a
unique records by using   *Filter the list-List range-Criteria range-Unique
Records only *
*
*
*This Option will be used for removing duplicates and unique records viewing
Purpuse..*

*Best Regards,*
*Venkat *
*Chennai*

On Tue, Aug 30, 2011 at 5:57 PM, kannan excel wrote:

> Hi NOORAIN ANSARI,
>
> Pls tell wat is this.??
> if you feel free explain me.
>
> Regards
> V. Kannan
> Aircel Limited
> Chennai
>
> On Mon, Aug 29, 2011 at 3:38 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Anil,
>>
>> Use Alt+A Q for Advance filter..
>> Choose *Filter the list-List range-Criteria range-Unique Records only
>>
>> *
>>   On Mon, Aug 29, 2011 at 3:06 PM, anil kumar  wrote:
>>
>>> Dear all,
>>>
>>>
>>>   I am attach. file in this file has some add. and some add. are is
>>> double, triple, so when i use short key Alt + a,m to remove double, than i
>>> do not gate data in proper sequence. plz lead me.
>>>
>>>
>>>
>>> Thanks
>>> Anil
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> *http://noorain-ansari.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 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
>>
>
>  --
>
> --
> 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
>



-- 
*
*
*
*
*
*

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

Re: $$Excel-Macros$$ any short key to remove double add.

[kannan excel]

Hi NOORAIN ANSARI,

Pls tell wat is this.??
if you feel free explain me.

Regards
V. Kannan
Aircel Limited
Chennai

On Mon, Aug 29, 2011 at 3:38 PM, NOORAIN ANSARI wrote:

> Dear Anil,
>
> Use Alt+A Q for Advance filter..
> Choose *Filter the list-List range-Criteria range-Unique Records only
>
> *
>   On Mon, Aug 29, 2011 at 3:06 PM, anil kumar  wrote:
>
>> Dear all,
>>
>>
>>   I am attach. file in this file has some add. and some add. are is
>> double, triple, so when i use short key Alt + a,m to remove double, than i
>> do not gate data in proper sequence. plz lead me.
>>
>>
>>
>> Thanks
>> Anil
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.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 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
>

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

RE: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...

[Rajan_Verma]

Hi Bajrang,
You can use sumifs() Function for this I think, or attached a sample file to
better understand your Query,

Rajan. 

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of B Sharma
Sent: Tuesday, August 16, 2011 12:53 PM
To: MS EXCEL AND VBA MACROS
Cc: rajanverma1...@gmail.com
Subject: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...

Hello to Excel Experts and other users of this group.

I've been looking everywhere   about how to put several criteria in
different cell ranges in:

DSUM(database, field, criteria).

I have a very large database and using Dsum and I am using different
different criteria  in different different columns.

Normally you put for example A1:G2 and everything works fine. Now the
problem is that I have quite many criterias that are common for
several DSUM() and I would like to split the criterias into for
example A1:D2 and G1:G2.

I've triad DSUM(database, field, {A1:D2, G1:G2}) (cannot use arrays
with refernces..),
DSUM(database, field, A1:D2, G1:G2) (too many arguments..).. etc.

What can I do?

If anyone has an idea please let me know !!

B. Sharma

-- 

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

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

Re: $$Excel-Macros$$ Named Range to Dynamic with VBA

[dguillett1]

You  can put this in a regular sub or this worksheet double click event
Right click sheet tab>view code>insert this>double click any cell to name range

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As 
Boolean)
For Each N In ActiveWorkbook.Names
  If InStr(1, N.RefersTo, ActiveSheet.Name, vbTextCompare) > 0 Then
Set X = Intersect(ActiveCell, Range(N.RefersTo))
If Not X Is Nothing Then
 fc = Range(N).Cells(1, 1).Address
 mc = Range(N).EntireColumn.Address
 N.RefersTo = "=OFFSET(" & fc & ",,,COUNTA(" & mc & "))"
End If
  End If
Next N
End Sub

From: Daniel 
Sent: Tuesday, August 30, 2011 4:34 AM
To: excel-macros@googlegroups.com 
Subject: RE: $$Excel-Macros$$ Named Range to Dynamic with VBA

Hi,

 

Be cautious with this macro and keep a copy of your workbook. Look at the 
attached workbook in which there is an example of error.

 

Sub test()

Dim N As Name, Var As String, Tabl As Variant

For Each N In ActiveWorkbook.Names

If LCase(Left(N.RefersTo, 7)) <> "=offset" Then

Tabl = Split(Right(N.RefersTo, Len(N.RefersTo) - 1), ":")

Var = Range(Tabl(0)).Resize(, 1).EntireColumn.Address

N.RefersTo = "=OFFSET(" & Tabl(0) & ",,,COUNTA(" & Var & "))"

End If

Next N

End Sub

 

Regards.

 

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la 
part de Cab Boose
Envoyé : lundi 29 août 2011 23:39
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Named Range to Dynamic with VBA

 

Hi

 

I would like to select an already named range and using a command button 
convert it to dynamic named range by columns and rows.

 

Is this possible ? It would be a lot quicker than doing it manually each 
time.  I failed to make a lot dynamic when I set them up.

 

Appreciate your help, I am aged !! (67) and do part time work just a few hours 
a week for a small business.  Love Excel.

 

Thanks and regards

 

 

Charlie Harris

 

 

 

 

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

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

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

RE: $$Excel-Macros$$ help

[Rajan_Verma]

Use Concatenate 

=Concatenate(Proper(Trim(YourWord)), Proper(Trim(YourWord))

 

Or & Sign

 

Proper(Trim(YourWord)) & " " & Proper(Trim(YourWord)) 

 

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: Tuesday, August 30, 2011 7:27 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ help

 

Hi,

 

 i have four words and i need to combine using trim and proper functions.

 

Please can you provide me formula

 

Thank you

-- 

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

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

Fwd: $$Excel-Macros$$ User form

[Venkat CV]

Hi Surya,

Your excel sheet is empty..Please check..and resend it back...and
please Elaborate more about your query.

 *Best Regards,*
*Venkat *
*Chennai*
*
*
*
*

On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad wrote:

> Hi ,
>
> Please see my excel spread sheet i need the userform as POP see the chail
> mail
>
> Thanks
> Prasad
>   On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 wrote:
>
>>   What userform? Put this in the ThisWorkbook module
>>
>> Private Sub Workbook_Open()
>> nameofyouruserformhere.Show
>> End Sub
>>
>>  *From:* Suryaprasad 
>> *Sent:* Tuesday, August 30, 2011 7:42 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ User form
>>
>>   Hi All,
>>
>> Need  a small help , i need to get a pop up of the user form when my excel
>> is opened, see the attachment
>>
>> Thanks
>> Prasad.
>> --
>>
>> --
>> 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
>>
>> --
>>
>> --
>> 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
>>
>
> --
>
> --
> 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
>



-- 





-- 
*Best Regards,*
*Venkat *
*Chennai*
*
*
*
*

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

Re: $$Excel-Macros$$ help

[Venkat CV]

Hi vijay,

Please send some sample data...for your requirement..

 *Best Regards,*
*Venkat *
*Chennai*


On Tue, Aug 30, 2011 at 7:26 PM, vijayajith VA wrote:

> Hi,
>
>  i have four words and i need to combine using trim and proper functions.
>
> Please can you provide me formula
>
> Thank you
>
> --
>
> --
> 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
>



-- 
*
*
*
*

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

Re: $$Excel-Macros$$ User form

[Venkat CV]

Hi Surya,

Your excel sheet is empty..Please check..

 *Best Regards,*
*Venkat *
*Chennai*
*
*
*
*

On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad wrote:

> Hi ,
>
> Please see my excel spread sheet i need the userform as POP see the chail
> mail
>
> Thanks
> Prasad
>   On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 wrote:
>
>>   What userform? Put this in the ThisWorkbook module
>>
>> Private Sub Workbook_Open()
>> nameofyouruserformhere.Show
>> End Sub
>>
>>  *From:* Suryaprasad 
>> *Sent:* Tuesday, August 30, 2011 7:42 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ User form
>>
>>   Hi All,
>>
>> Need  a small help , i need to get a pop up of the user form when my excel
>> is opened, see the attachment
>>
>> Thanks
>> Prasad.
>> --
>>
>> --
>> 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
>>
>> --
>>
>> --
>> 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
>>
>
> --
>
> --
> 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
>



--

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

Re: $$Excel-Macros$$ User form

[Suryaprasad]

Hi ,

Please see my excel spread sheet i need the userform as POP see the chail
mail

Thanks
Prasad
On Tue, Aug 30, 2011 at 6:39 PM, dguillett1  wrote:

>   What userform? Put this in the ThisWorkbook module
>
> Private Sub Workbook_Open()
> nameofyouruserformhere.Show
> End Sub
>
>  *From:* Suryaprasad 
> *Sent:* Tuesday, August 30, 2011 7:42 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ User form
>
>   Hi All,
>
> Need  a small help , i need to get a pop up of the user form when my excel
> is opened, see the attachment
>
> Thanks
> Prasad.
> --
>
> --
> 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
>
> --
>
> --
> 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
>

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

Re: $$Excel-Macros$$ User form

[dguillett1]

What userform? Put this in the ThisWorkbook module

Private Sub Workbook_Open()
nameofyouruserformhere.Show 
End Sub 

From: Suryaprasad 
Sent: Tuesday, August 30, 2011 7:42 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ User form

Hi All,

Need  a small help , i need to get a pop up of the user form when my excel is 
opened, see the attachment

Thanks
Prasad.
-- 
--
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

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

Re: $$Excel-Macros$$ User form

[Venkat CV]

Hi Prasad,

Look attached below...

If you want to create some VBA Coding in background of userforms..You have
to save the file has a .XLS or

XLSM because XLSX wont support Macro Language..


*Best Regards,*
*Venkat *
*Chennai*

On Tue, Aug 30, 2011 at 6:12 PM, Suryaprasad wrote:

> Hi All,
>
> Need  a small help , i need to get a pop up of the user form when my excel
> is opened, see the attachment
>
> Thanks
> Prasad.
>
> --
>
> --
> 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
>



-- 
*
*
*
*

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


Auto_Open.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ User form

[Suryaprasad]

Hi All,

Need  a small help , i need to get a pop up of the user form when my excel
is opened, see the attachment

Thanks
Prasad.

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


New Microsoft Office Excel Worksheet (2).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Re: Need macro to split the files

[anu gomathi]

Hi,

Can u pls explain me the steps. Any way i need the summary in the detail
sheet.

Regards
Anu

On Tue, Aug 30, 2011 at 2:52 PM, Frederic LE GUEN - MVP Excel <
fleg...@gmail.com> wrote:

> Why don't you use a pivot table with the table option to split your
> document by Division and Regional lead ?
>
>
> On 30 août, 06:52, anu gomathi  wrote:
> > Hi Experts,
> >
> > I am very new to this forum.
> >
> > Attached the details report & the out put file. I need a macro to split
> the
> > workbook as per the below condition:
> >
> > The detail report file should be splitted based on the divisional lead &
> > regional lead.
> >
> > Condition 1: while splitting the file summary should be there in the
> summary
> > sheet. Better the formula would be useful instead of values.
> >
> > Condition2 : The Qtr code Q1 Fy12 details should come in the summary
> sheet &
> > rest all the qtr's should be in details sheet.
> >
> > Please help me in this.
> >
> > Thanks in advance.
> >
> > Regards
> >
> > Anu
> >
> >  Detail report.xls
> > 1506KAfficherTélécharger
> >
> >  Andy Huntrods-SI Report-010811.xls
> > 104KAfficherTélécharger
>
> --
>
> --
> 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
>

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

RE: $$Excel-Macros$$ Named Range to Dynamic with VBA

[Daniel]

Hi,

 

Be cautious with this macro and keep a copy of your workbook. Look at the
attached workbook in which there is an example of error.

 

Sub test()

Dim N As Name, Var As String, Tabl As Variant

For Each N In ActiveWorkbook.Names

If LCase(Left(N.RefersTo, 7)) <> "=offset" Then

Tabl = Split(Right(N.RefersTo, Len(N.RefersTo) - 1), ":")

Var = Range(Tabl(0)).Resize(, 1).EntireColumn.Address

N.RefersTo = "=OFFSET(" & Tabl(0) & ",,,COUNTA(" & Var & "))"

End If

Next N

End Sub

 

Regards.

 

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Cab Boose
Envoyé : lundi 29 août 2011 23:39
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Named Range to Dynamic with VBA

 

Hi

 

I would like to select an already named range and using a command button
convert it to dynamic named range by columns and rows.

 

Is this possible ? It would be a lot quicker than doing it manually each
time.  I failed to make a lot dynamic when I set them up.

 

Appreciate your help, I am aged !! (67) and do part time work just a few
hours a week for a small business.  Love Excel.

 

Thanks and regards

 

 

Charlie Harris

 

 

 

 

-- 

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

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


Error.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Excel and Sending Digital Data (DDE ?)

[lifescholar]

On Aug 30, 4:55 am, Cab Boose  wrote:
> Hi once again
>
> This is totally new subject.   I have model railroads.   I would like to
> control from Excel.    (there are some other software available but I would
> like to use Excel)
>
> I want to send from Excel to a bus wire digital information showing the loco
> number and direction of travel (fwd/rev) etc. Just for basics etc  Send a
> message by USB to say:
>
> Controller1  Engine 5  Fwd Direction 1/2 speed
>
> In practice there would be several sets of data for different locos.
>
> There is a digital receiver in loco.  (I have drawings of waveforms that it
> is sent over etc)
>
> I know there are lots of things to consider, but at this point I would like
> to know if anyone has done something similiar.  Is DDE the one to us (old
> apparantly) or something different.
>
> I will make up a spreadsheet to show selection of loco etc
>
> It may end up being too complex for me, but I would like to give it a try
> and get a ssample working turning on an LED etc
>
> Thanks
>
> Charlie Harris
> (into model trains)

This is beyond me, but the following might be a good starting point:

http://msdn.microsoft.com/en-us/windows/hardware/gg487341

You will need to declare the relevant API functions in VBA before you
can use them. See the following for more info:

http://msdn.microsoft.com/en-us/library/bb687915.aspx

This is a complex project, but should be possible in theory.

Regards
Steve

PS I am also a model railway enthusiast, so I'd be interested in how
you get on.

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

$$Excel-Macros$$ Re: Need macro to split the files

[Frederic LE GUEN - MVP Excel]

Why don't you use a pivot table with the table option to split your
document by Division and Regional lead ?


On 30 août, 06:52, anu gomathi  wrote:
> Hi Experts,
>
> I am very new to this forum.
>
> Attached the details report & the out put file. I need a macro to split the
> workbook as per the below condition:
>
> The detail report file should be splitted based on the divisional lead &
> regional lead.
>
> Condition 1: while splitting the file summary should be there in the summary
> sheet. Better the formula would be useful instead of values.
>
> Condition2 : The Qtr code Q1 Fy12 details should come in the summary sheet &
> rest all the qtr's should be in details sheet.
>
> Please help me in this.
>
> Thanks in advance.
>
> Regards
>
> Anu
>
>  Detail report.xls
> 1506KAfficherTélécharger
>
>  Andy Huntrods-SI Report-010811.xls
> 104KAfficherTélécharger

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

Re: $$Excel-Macros$$ xls to Pdf in VBA error

[Venkat CV]

Hi Noorian,

How it will automatically save PDF Format in 2003 Version...is it
available..

-- 
*Best Regards,*
*Venkat *
*Chennai*
*
*

On Tue, Aug 30, 2011 at 2:16 PM, NOORAIN ANSARI wrote:

> Dear Sajid,
>
> Please change blue color path as per your system..
> This code is working fine in my systems..
> *Once again.try..*
> **
> *Private Sub CommandButton1_Click()
> Dim wrknm As String
> wrknm = ActiveWorkbook.Name
> wrknm = Left(wrknm, InStr(1, wrknm, ".") - 1)*
> *ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
> "C:\Documents and Settings\Administrator\Desktop\" & wrknm & ".pdf",
> Quality:=xlQualityStandard, _
> IncludeDocProperties:=False, IgnorePrintAreas:=False,
> OpenAfterPublish:= _
> False
> End Sub
>
> *
>
> On Tue, Aug 30, 2011 at 2:06 PM, SAJID MEMON wrote:
>
>>  Dear sir, I have copy below code and paste in excel 2003 but it shows
>> some error and its not working in my all three systems. I have attached that
>> image in my attachment.
>> Please co-operate me for accomplish my project.
>> awaiting your reply
>>
>> sajid memon
>>
>>
>>
>>
>>  --
>> Date: Mon, 29 Aug 2011 20:01:33 +0530
>> Subject: Re: $$Excel-Macros$$ xls to Pdf in VBA
>> From: noorain.ans...@gmail.com
>> To: excel-macros@googlegroups.com
>>
>> Dear KBJ,
>> W/S...
>>
>> That converter is working fine on my system..
>>
>> press alt+F11 and Paste it code in Module and Press F5.
>>
>> I hope it will work fine..
>>
>> Sub exltopdf_converter()
>> Dim wrknm As String
>> wrknm = ActiveWorkbook.Name
>> wrknm = Left(wrknm, InStr(1, wrknm, ".") - 1)
>> ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
>> "C:\Documents and Settings\Administrator\Desktop\" & wrknm &
>> ".pdf", Quality:=xlQualityStandard, _
>> IncludeDocProperties:=False, IgnorePrintAreas:=False,
>> OpenAfterPublish:= _
>> False
>> end Sub
>> On Mon, Aug 29, 2011 at 3:35 PM, Advocate kbj  wrote:
>>
>> dear Noorain Ansari (Assalamulaikum)
>> as per your tryit.xls its not working. plz give me detail.
>> with advance Happy Eid Mubarak to all.
>>
>> sajid memon
>>
>>   On Sat, Aug 27, 2011 at 10:14 PM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>> Dear Sajid,
>>
>> As per your requirement Please try blow VBA code to Convert Excel file in
>> PDF.
>>
>> Change path as per ur conviniece..
>> See attached sheet
>>
>> *Private Sub CommandButton1_Click()
>> Dim wrknm As String
>> wrknm = ActiveWorkbook.Name
>> wrknm = Left(wrknm, InStr(1, wrknm, ".") - 1)*
>> *ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
>> "C:\Documents and Settings\Administrator\Desktop\" & wrknm &
>> ".pdf", Quality:=xlQualityStandard, _
>> IncludeDocProperties:=False, IgnorePrintAreas:=False,
>> OpenAfterPublish:= _
>> False
>> End Sub
>>
>> *
>> Thanks & regards,
>> Noorain Ansari
>> *http://noorain-ansari.blogspot.com/*
>>
>>  On Sat, Aug 27, 2011 at 4:28 PM, SAJID MEMON wrote:
>>
>>  Dear Experts,
>>
>> I want an active sheet with command button (EXCEL 2003) convert into pdf
>> file. when i click on command button
>>  it convert and should be open in pdf format.
>>  Is it possible in excel 2003 version, if Yes then please give me VBA
>> code for my query
>>
>> *i don't want to use any other converter software or online website.*
>> **
>> awaiting your positive responce
>>
>> sajid memon
>>
>> --
>>
>> --
>> 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
>>
>>
>>
>>
>> --
>>
>>
>> --
>>
>> --
>> 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
>>
>>
>>
>> --
>>
>> ---

Re: $$Excel-Macros$$ xls to Pdf in VBA error

[NOORAIN ANSARI]

Dear Sajid,

Please change blue color path as per your system..
This code is working fine in my systems..
*Once again.try..*
**
*Private Sub CommandButton1_Click()
Dim wrknm As String
wrknm = ActiveWorkbook.Name
wrknm = Left(wrknm, InStr(1, wrknm, ".") - 1)*
*ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Documents and Settings\Administrator\Desktop\" & wrknm & ".pdf",
Quality:=xlQualityStandard, _
IncludeDocProperties:=False, IgnorePrintAreas:=False,
OpenAfterPublish:= _
False
End Sub

*

On Tue, Aug 30, 2011 at 2:06 PM, SAJID MEMON  wrote:

>  Dear sir, I have copy below code and paste in excel 2003 but it shows
> some error and its not working in my all three systems. I have attached that
> image in my attachment.
> Please co-operate me for accomplish my project.
> awaiting your reply
>
> sajid memon
>
>
>
>
>  --
> Date: Mon, 29 Aug 2011 20:01:33 +0530
> Subject: Re: $$Excel-Macros$$ xls to Pdf in VBA
> From: noorain.ans...@gmail.com
> To: excel-macros@googlegroups.com
>
> Dear KBJ,
> W/S...
>
> That converter is working fine on my system..
>
> press alt+F11 and Paste it code in Module and Press F5.
>
> I hope it will work fine..
>
> Sub exltopdf_converter()
> Dim wrknm As String
> wrknm = ActiveWorkbook.Name
> wrknm = Left(wrknm, InStr(1, wrknm, ".") - 1)
> ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
> "C:\Documents and Settings\Administrator\Desktop\" & wrknm &
> ".pdf", Quality:=xlQualityStandard, _
> IncludeDocProperties:=False, IgnorePrintAreas:=False,
> OpenAfterPublish:= _
> False
> end Sub
> On Mon, Aug 29, 2011 at 3:35 PM, Advocate kbj  wrote:
>
> dear Noorain Ansari (Assalamulaikum)
> as per your tryit.xls its not working. plz give me detail.
> with advance Happy Eid Mubarak to all.
>
> sajid memon
>
>   On Sat, Aug 27, 2011 at 10:14 PM, NOORAIN ANSARI <
> noorain.ans...@gmail.com> wrote:
>
> Dear Sajid,
>
> As per your requirement Please try blow VBA code to Convert Excel file in
> PDF.
>
> Change path as per ur conviniece..
> See attached sheet
>
> *Private Sub CommandButton1_Click()
> Dim wrknm As String
> wrknm = ActiveWorkbook.Name
> wrknm = Left(wrknm, InStr(1, wrknm, ".") - 1)*
> *ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
> "C:\Documents and Settings\Administrator\Desktop\" & wrknm & ".pdf",
> Quality:=xlQualityStandard, _
> IncludeDocProperties:=False, IgnorePrintAreas:=False,
> OpenAfterPublish:= _
> False
> End Sub
>
> *
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*
>
>  On Sat, Aug 27, 2011 at 4:28 PM, SAJID MEMON wrote:
>
>  Dear Experts,
>
> I want an active sheet with command button (EXCEL 2003) convert into pdf
> file. when i click on command button
>  it convert and should be open in pdf format.
>  Is it possible in excel 2003 version, if Yes then please give me VBA code
> for my query
>
> *i don't want to use any other converter software or online website.*
> **
> awaiting your positive responce
>
> sajid memon
>
> --
>
> --
> 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
>
>
>
>
> --
>
>
> --
>
> --
> 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
>
>
>
> --
>
> --
> 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 ht

$$Excel-Macros$$ Fwd: Opening for SQl Developer in Chennai with Ramco Systems

[Venkat CV]

- Original message 
From:"Magna Infotech Pvt Ltd"< car...@magna.in >
Date: 30 Aug 11 12:28:42
Subject: Opening for SQl Developer in Chennai with Ramco Systems
To:

The sender of this email is registered with Naukri.com as Magna Infotech Pvt
Ltd Experience required for the Job: 3 - 7 yearsAnnual Salary of the
Job: 0.0 - 0.0 LacsJob Location: Chennai
Dear Candidate,Hi,

This is Arati from Magna InfoTech Pvt. Ltd, Hyderabad.


Let me take this opportunity to introduce Magna InfoTech Pvt. Ltd. We are
one of the most dynamic and fast growing IT Staffing in India. An ISO 2008
Certified Company Spread across 7 Different locations. Currently we have an
exciting opening with us at our client place Ramco Systems Chennai

Job Details


Skills


SQL Development exp

Exp :3-7 yrs

Location: Chennai


if interested please reply back with your updated resume and following
details:


Current Company:

Total Exp:

Relevant Exp:

Current CTC:

Expected CTC:

Notice Period: (less notice period will be prefferd)


(Please refer any of your friends who are interested and desperately looking
out for change)



Thanks & Warm Regards,


Arati C|IT Resource|

Desk- 040 39179092,

Email ID: car...@magna.in

www.magna.in| Magna InfotechIs this job relevant to you? Yes No Your
feedback would help us in sending you the most relevant job opportunities
Disclaimer: The sender of this email is registered with naukri.com as Magna
Infotech Pvt Ltd (psa...@magna.in, 6-2-47, 2nd Foor, Yeturi Towers Advocate
Colony,, A.C.Gaurds Hyderabad - 54, HYDERABAD, Andhra Pradesh - 54)
using Naukri.com services. The responsibility of checking the authenticity
of offers/correspondence lies with you.

If you consider the content of this email inappropriate or spam, you
may:Report abuse by forwarding this email to: compliance@naukri.comYou can
also Block this Company from searching your resume in the database.
Advisory: Please do not pay any money to anyone who promises to find you a
job. This could be in the form of a registration fee, or document processing
fee or visa charges or any other pretext. The money could be asked for
upfront or it could be asked after trust has been built after some
correspondence has been exchanged. Also please note that in case you get a
job offer or a letter of intent without having been through an interview
process it is probably a scam and you should contact
compliance@naukri.comfor advise. To be on the top of Employer's Resume
Search
Update Your Resume Now Your Resume has only 30 seconds to impress a
Recruiter. Get your resume written by Experts.
Call 1800-102-5557 now! (Toll-Free)
*Best Regards,*
*Venkat *
*Chennai*
*
*


-- 
*
*
*
*

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

$$Excel-Macros$$ Fwd:Job

[Venkat CV]

- Original message 
From:""Teamware Solutions (quantum leap consulting)""< sw...@twsol.com >
Date: 30 Aug 11 12:43:07
Subject: Urgent Requirment for MS SQL server 2005/2008Developers for TCS,
Kochi
To: 

The sender of this email is registered with Naukri.com as Teamware Solutions
(quantum leap consulting) Experience required for the Job: 4 - 8 yearsJob
Location: Ernakulam / Kochi / Cochin
Dear Candidate,Warm Greetings!!


We are Teamware Solutions, a professional IT services company head quartered
in Bangalore. Teamware is a division of Quantum Leap Consulting Pvt. Ltd.
and we specialize in contract staffing, placements and executive search. Our
clientele include some of the best names in the IT industry worldwide like
HP, Accenture, Deloitte, Cap Gemini, EDS, TCS, ATOS, to name a few.


Our offices in Bangalore, Chennai and Mumbai look after our client's
domestic requirements and our Singapore outfit, Teamware Solutions Pte Ltd.
takes care of requirements in the Asia-pacific region.


The choice of clients and our presence in national and international market
can assure you of our commitment in providing you the best of opportunities
and ending your search for a dream job.


Mandatory Skill: MS SQL server 2005/2008


Exp Level: 4 Yrs


Location: Kochi


Client : " TCS"


Note: Candidates who can join within short notice period & (10-14 days) from
the date of selection need to apply for this position.


Also mention the details given below.


Willingness to work on the direct payrolls of Teamware Solutions- Yes/No

Total Experience:

Relevant Experience:

Current CTC:

Expected CTC:

NTC:

Official Mail:

Date of Birth-

Educational Details-(Mention if regular or Correspondence):

Current Company:

Current Location:

Preferred Location:



If this mail is irrelevant to you kindly oblige and Ignore this Mail


Thanking You


Wishing you a nice day ahead !!!


Warm Regards,


Thanks & regards

Swati

Teamware Solution

201-203, First Floor , Oxford Chambers, Rustambagh Road

Off: Airport Road, Bangalore-560017

email-sw...@twsol.com

office-08040818510

website:www.teamwaresolutions.netIs this job relevant to you? Yes No Your
feedback would help us in sending you the most relevant job opportunities
Disclaimer: The sender of this email is registered with naukri.com as
Teamware Solutions (quantum leap consulting) (ad...@twsol.com, 305, 2nd
Floor, Oxford House Rustum Baugh, OFF OLD AIRPORT ROAD BANGALORE, BANGALORE,
Karnataka - 560017) using Naukri.com services. The responsibility of
checking the authenticity of offers/correspondence lies with you.

If you consider the content of this email inappropriate or spam, you
may:Report abuse by forwarding this email to: compliance@naukri.comYou can
also Block this Company from searching your resume in the database.
Advisory: Please do not pay any money to anyone who promises to find you a
job. This could be in the form of a registration fee, or document processing
fee or visa charges or any other pretext. The money could be asked for
upfront or it could be asked after trust has been built after some
correspondence has been exchanged. Also please note that in case you get a
job offer or a letter of intent without having been through an interview
process it is probably a scam and you should contact
compliance@naukri.comfor advise. To be on the top of Employer's Resume
Search
Update Your Resume Now Your Resume has only 30 seconds to impress a
Recruiter. Get your resume written by Experts.
Call 1800-102-5557 now! (Toll-Free)

-- 
*Best Regards,*
*Venkat *
*Chennai*
*
*
*
*

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

RE: $$Excel-Macros$$ Sumproduct using VBA

[Daniel]

Hello,

 

Use :

 

a = "SUMPRODUCT(--(" & rng1 & "=""" & "BEL" & """),--(" & rng2 & "=""" &
"AAO" & """),--(" & rng4 & "))"

 

HTH

 

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Chandra Shekar
Envoyé : lundi 29 août 2011 16:37
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Sumproduct using VBA

 

Hello,

 

Could you please let me know whats the error in using sumproduct function in
below code. I am getting error number 2015

 

Is there any other way to use sumproduct function using vba with multiple
condtions.

 

Thanks in advance.

 

Sub ABNAMROAdd()

Dim compnm As String
lastcl = ThisWorkbook.Worksheets("ABN AMRO").Cells(4,
Columns.Count).End(xlToLeft).Column
'WeekNum = Weeknumber(Date)
'WeekNum = CurWk

x = ThisWorkbook.Name
y = ThisWorkbook.Worksheets(12).Name
Z = "'[" & x & "]" & y & "'!"

 

lastrow = ThisWorkbook.Worksheets("AR").Cells(Rows.Count, 1).End(xlUp).Row

rng1 = Z & "A2:A" & lastrow
rng2 = Z & "C2:C" & lastrow
rng3 = Z & "D2:D" & lastrow
rng4 = Z & "E2:E" & lastrow
rng5 = Z & "H2:H" & lastrow

a = "SUMPRODUCT(--(" & rng1 & "=""" & "BEL" & """),--(" & rng2 & "=""" &
"AAO" & """),--(" & rng4 & """))"
cnt = Application.Evaluate(a)


End Sub

-- 

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

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

Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other

[NOORAIN ANSARI]

Dear Cab,

Process to add Add-Ins in Excel Ribbon

Excel Option->Add-Ins->Manage->Excel Add-Ins->Go->Ok

You can see below link..
http://www.lytebyte.com/2009/01/08/how-to-add-and-remove-excel-add-in-or-plugins/

-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* 

On Tue, Aug 30, 2011 at 1:23 PM, Cab Boose  wrote:

> Hi Noorain
>
> Thanks for that.  It does not show in the add-in at the moment.  Have
> opened Excel and then opened the file you sent.
> Is there a process that I should foolw ?
>
> Thankyou
>
> Charlie
>
>   On Tue, Aug 30, 2011 at 7:43 PM, NOORAIN ANSARI <
> noorain.ans...@gmail.com> wrote:
>
>> Dear Cab,
>>
>> Actually it is Add-In file when you click on this, it will be Show in
>> Add-in Menu bar when you need  it can be use..
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> *http://noorain-ansari.blogspot.com/*
>>
>>   On Tue, Aug 30, 2011 at 12:10 PM, Cab Boose  wrote:
>>
>>> Hi Noorain
>>>
>>>
>>>
>>>
>>>  On Tue, Aug 30, 2011 at 2:32 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Dear Cab,

  Question -1, you can use attached Add in to Compare two worksheets..
 Question -2, You can group both sheets to same entry on same time.

 Press ctrl+shift+Pg down..
   Thanks for your reply and attachment.


>>> However the attachment opens Excel but will not show the workbook.
>>>
>>> If you could check and resend for me that would be great.
>>> Thanks and regars
>>>
>>> Charlie Harris
>>>



 On Tue, Aug 30, 2011 at 3:04 AM, Cab Boose  wrote:

> Hi  OOPS
>
> This time attached.
>
> Thanks
>
> Charlie
>
>   On Tue, Aug 30, 2011 at 9:32 AM, Cab Boose wrote:
>
>> Hi and oops.
>>
>> Attached now.
>>
>>   On Mon, Aug 29, 2011 at 7:50 PM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>> Dear Cab,
>>>
>>> Attachment Missing.
>>>
>>>   On Mon, Aug 29, 2011 at 1:17 PM, Cab Boose wrote:
>>>
 Hi
  I have in attached workbook:
  Has two worksheets- 'ByGroups' and 'ByAssly"
  The two sheets should be the same, however they are in different
 order.
  First Question: Which is the best way to find the differences
 between the two sheets as at the moment so that corrections can be 
 made.
 Have searched google etc Looks like I need a match/vlookup ?? or 
 probably
 vba would be better ? Would like to see a separate sheet with the
 differences.
  Second Question: Once the sheets are sorted, I want to be able to
 have entries made onto the part # in each sheet at the same time. eg 
 if I
 have part # 27184 I want to enter 'InStock' number entered on both 
 sheets
 against that number. I think a user form could be used, but I do not 
 know
 how to get both sheets entered at the same time. The user form would 
 show
 the 5 column heading (on the RHS)
  Your comments and guidance would be appreciated.

 Thankyou

 Charlie Harris

 --

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

>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> *http://noorain-ansari.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 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 

Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other

[Cab Boose]

Hi Noorain

Thanks for that.  It does not show in the add-in at the moment.  Have opened
Excel and then opened the file you sent.
Is there a process that I should foolw ?

Thankyou

Charlie

On Tue, Aug 30, 2011 at 7:43 PM, NOORAIN ANSARI wrote:

> Dear Cab,
>
> Actually it is Add-In file when you click on this, it will be Show in
> Add-in Menu bar when you need  it can be use..
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*
>
> On Tue, Aug 30, 2011 at 12:10 PM, Cab Boose  wrote:
>
>> Hi Noorain
>>
>>
>>
>>
>>  On Tue, Aug 30, 2011 at 2:32 PM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>> Dear Cab,
>>>
>>>  Question -1, you can use attached Add in to Compare two worksheets..
>>> Question -2, You can group both sheets to same entry on same time.
>>>
>>> Press ctrl+shift+Pg down..
>>>   Thanks for your reply and attachment.
>>>
>>>
>> However the attachment opens Excel but will not show the workbook.
>>
>> If you could check and resend for me that would be great.
>> Thanks and regars
>>
>> Charlie Harris
>>
>>>
>>>
>>>
>>> On Tue, Aug 30, 2011 at 3:04 AM, Cab Boose  wrote:
>>>
 Hi  OOPS

 This time attached.

 Thanks

 Charlie

   On Tue, Aug 30, 2011 at 9:32 AM, Cab Boose  wrote:

> Hi and oops.
>
> Attached now.
>
>   On Mon, Aug 29, 2011 at 7:50 PM, NOORAIN ANSARI <
> noorain.ans...@gmail.com> wrote:
>
>> Dear Cab,
>>
>> Attachment Missing.
>>
>>   On Mon, Aug 29, 2011 at 1:17 PM, Cab Boose wrote:
>>
>>> Hi
>>>  I have in attached workbook:
>>>  Has two worksheets- 'ByGroups' and 'ByAssly"
>>>  The two sheets should be the same, however they are in different
>>> order.
>>>  First Question: Which is the best way to find the differences
>>> between the two sheets as at the moment so that corrections can be made.
>>> Have searched google etc Looks like I need a match/vlookup ?? or 
>>> probably
>>> vba would be better ? Would like to see a separate sheet with the
>>> differences.
>>>  Second Question: Once the sheets are sorted, I want to be able to
>>> have entries made onto the part # in each sheet at the same time. eg if 
>>> I
>>> have part # 27184 I want to enter 'InStock' number entered on both 
>>> sheets
>>> against that number. I think a user form could be used, but I do not 
>>> know
>>> how to get both sheets entered at the same time. The user form would 
>>> show
>>> the 5 column heading (on the RHS)
>>>  Your comments and guidance would be appreciated.
>>>
>>> Thankyou
>>>
>>> Charlie Harris
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> *http://noorain-ansari.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 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
>>
>
>
 --

 --
 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://excelda

Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other

[NOORAIN ANSARI]

Dear Cab,

Actually it is Add-In file when you click on this, it will be Show in Add-in
Menu bar when you need  it can be use..


-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* 

On Tue, Aug 30, 2011 at 12:10 PM, Cab Boose  wrote:

> Hi Noorain
>
>
>
>
>  On Tue, Aug 30, 2011 at 2:32 PM, NOORAIN ANSARI  > wrote:
>
>> Dear Cab,
>>
>>  Question -1, you can use attached Add in to Compare two worksheets..
>> Question -2, You can group both sheets to same entry on same time.
>>
>> Press ctrl+shift+Pg down..
>>   Thanks for your reply and attachment.
>>
>>
> However the attachment opens Excel but will not show the workbook.
>
> If you could check and resend for me that would be great.
> Thanks and regars
>
> Charlie Harris
>
>>
>>
>>
>> On Tue, Aug 30, 2011 at 3:04 AM, Cab Boose  wrote:
>>
>>> Hi  OOPS
>>>
>>> This time attached.
>>>
>>> Thanks
>>>
>>> Charlie
>>>
>>>   On Tue, Aug 30, 2011 at 9:32 AM, Cab Boose  wrote:
>>>
 Hi and oops.

 Attached now.

   On Mon, Aug 29, 2011 at 7:50 PM, NOORAIN ANSARI <
 noorain.ans...@gmail.com> wrote:

> Dear Cab,
>
> Attachment Missing.
>
>   On Mon, Aug 29, 2011 at 1:17 PM, Cab Boose wrote:
>
>> Hi
>>  I have in attached workbook:
>>  Has two worksheets- 'ByGroups' and 'ByAssly"
>>  The two sheets should be the same, however they are in different
>> order.
>>  First Question: Which is the best way to find the differences
>> between the two sheets as at the moment so that corrections can be made.
>> Have searched google etc Looks like I need a match/vlookup ?? or probably
>> vba would be better ? Would like to see a separate sheet with the
>> differences.
>>  Second Question: Once the sheets are sorted, I want to be able to
>> have entries made onto the part # in each sheet at the same time. eg if I
>> have part # 27184 I want to enter 'InStock' number entered on both sheets
>> against that number. I think a user form could be used, but I do not know
>> how to get both sheets entered at the same time. The user form would show
>> the 5 column heading (on the RHS)
>>  Your comments and guidance would be appreciated.
>>
>> Thankyou
>>
>> Charlie Harris
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.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 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
>


>>> --
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> *http://noorain-ansari.blogspot.com/*
>>
>> --
>>
>> ---