from:"Harmeet Singh"

Re: $$Excel-Macros$$ Re: Ashish Koul : Most helpful Member

2011-03-02 Thread Harmeet Singh

congrats buddy 

Warm Regards,

Harmeet Singh
IT Analyst
McKinsey  Company
http://www.facebook.com/Harmeeet


On Wed, Mar 2, 2011 at 11:06 PM, DILIPandey dilipan...@gmail.com wrote:

 Congrats Ashish...!!

 Best Regards,
 DILIPandey

 On Mar 1, 8:38 pm, Ayush jainayus...@gmail.com wrote:
  Hello Everyone,
 
  Ashish Koul has been selected as *'Most Helpful Member'* for the month of
  Feb 2011.
  He has posted 97 posts (13% of total posts) in February 2011 and helped
 many
  people through his expertise. He has been consistent contributor to this
  excel forum and achieved this recognition consistently from last three
  months.This is really amazing.
 
  Ashish, You are not only helping on excel queries but inspiring many
 people
  to support voluntarily.
 
  *Many Many Thanks Ashish for wonderful support to group.
  *
 
  *About Ashish Koul*
  Ashish resides in Delhi, India and currently working  with CSC. He is
  automation expert and his role is to automate tasks using VBA Macros and
  Advanced Excel. His favorite pass time is solving Excel Queries,
 Listening
  Music  Traveling.
 
  Regards
  Ayush Jain
  Group Manager

 --

 --
 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: Reqd : Add in to convert Numbet to text in Excel 2007

2010-12-07 Thread Harmeet Singh

http://code.google.com/p/openexcel/downloads/list

http://code.google.com/p/openexcel/downloads/list
Warm Regards,

Harmeet Singh
IT Analyst
McKinsey  Company
http://www.facebook.com/Harmeeet


On Tue, Dec 7, 2010 at 9:27 PM, OpenExcel.com ashishj...@openexcel.comwrote:

 Hi Radhe,

 It seems you don't know about 'Open Excel'. Download and you can do
 many things other than this.

 
 Thanks  Regards
 Ashish Jain
 (Microsoft Certified Application Specialist)
 (Microsoft Certified Professional)
 http://www.excelitems.com
 http://www.openexcel.com
 

 On Dec 7, 2:13 pm, Radhe Sham radhe2...@gmail.com wrote:
  Hi Group ,
 
  The addin  for converting a number to text which was working in Excel
 2003
  does not seem to work in Excel 2007
 
  Can anyone kindly help with an add in for Excel 2007 for converting
 number
  to text please
 
  Thanks and regards
  Radhe

 --

 --
 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/pages/discussexcelcom/160307843985936?v=wallref=ts


-- 
--
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/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ Own Formule in Pivot Table

2010-12-03 Thread Harmeet Singh

Hi Dave,

Thanks for the correction and sorry for being so dumb :D.

Warm Regards,

Harmeet Singh
IT Analyst
McKinsey  Company
http://www.facebook.com/Harmeeet


On Fri, Dec 3, 2010 at 1:16 PM, Dave Bonallack davebonall...@hotmail.comwrote:

  Hi,
 Harmet, your formula is using relative values for the SUM(B2:B8) section,
 and as a result, has created errors while copying down.
 Formula in D2 should look like this:
 *=B2/SUM($B$2:$B$8)*
 Then copy down.
 Regards - Dave.

 --
 From: harmeet.hew...@gmail.com
 Date: Fri, 3 Dec 2010 11:36:59 +1100
 Subject: Re: $$Excel-Macros$$ Own Formule in Pivot Table
 To: excel-macros@googlegroups.com
 CC: sunscel...@gmail.com


 here you go

 Warm Regards,

 Harmeet Singh
 IT Analyst
 McKinsey  Company
 http://www.facebook.com/Harmeeet


 On Thu, Dec 2, 2010 at 11:43 PM, Ramkesh Maurya sunscel...@gmail.comwrote:

 Hi All,

 Please tell me how i can insert my own formule in Excel. e.g 2 is 5.71% of
 35 the Grand Total, in next column I want to sum the percentage of 2( 
 i.ee5.71) + percentage of 3 (i.e. How much 3 is fraction of 35 ?)

 *Item* *Quantity* *Cumuletive Sum*  A 2 5.71% B 3   C 4   D 5   E 6
 F 7   G 8 35
 Waiting for reply--

 Ramkesh
 9990260398


 --

 --
 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/pages/discussexcelcom/160307843985936?v=wallref=ts



 --

 --
 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/pages/discussexcelcom/160307843985936?v=wallref=ts

 --

 --
 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/pages/discussexcelcom/160307843985936?v=wallref=ts


-- 
--
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/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ Own Formule in Pivot Table

2010-12-02 Thread Harmeet Singh

here you go

Warm Regards,

Harmeet Singh
IT Analyst
McKinsey  Company
http://www.facebook.com/Harmeeet


On Thu, Dec 2, 2010 at 11:43 PM, Ramkesh Maurya sunscel...@gmail.comwrote:

 Hi All,

 Please tell me how i can insert my own formule in Excel. e.g 2 is 5.71% of
 35 the Grand Total, in next column I want to sum the percentage of 2( 
 i.ee5.71) + percentage of 3 (i.e. How much 3 is fraction of 35 ?)

 *Item* *Quantity* *Cumuletive Sum*  A 2 5.71% B 3   C 4   D 5   E 6
 F 7   G 8 35
 Waiting for reply--

 Ramkesh
 9990260398

  --

 --
 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/pages/discussexcelcom/160307843985936?v=wallref=ts


-- 
--
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/pages/discussexcelcom/160307843985936?v=wallref=ts


Book3.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

2010-10-03 Thread Harmeet Singh

U deserve this bro.keep rocking

Warm Regards,

Harmeet Singh
IT Analyst
McKinsey Company
http://www.facebook.com/Harmeeet

On Mon, Oct 4, 2010 at 7:04 AM, hanumant shinde
hanumant_5...@yahoo.co.inwrote:

congrats ayush. this gropu really rocks

--
*From:* Iqbal Merchant iqbalmerch...@gmail.com

*To:* excel-macros@googlegroups.com
*Sent:* Sun, 3 October, 2010 5:46:14 PM

*Subject:* Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 2010

Congrate, i feel i have made the right decision by becoming member of this
group.

On Sun, Oct 3, 2010 at 5:10 PM, Dave Bonallack
davebonall...@hotmail.comwrote:

And from me too, Ayush, congratulations! Very good service you provide
here. Lots of work and time behind the scenes. Thank-you.
Dave.

--
From: shubhangidesa...@gmail.com
Date: Sun, 3 Oct 2010 16:46:13 +0530
Subject: Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 2010
To: excel-macros@googlegroups.com

Congratulations Mr Ayush

We r proud to have u here...

On Sun, Oct 3, 2010 at 3:56 PM, ashish koul koul.ash...@gmail.comwrote:

congrats ayush.

On Sun, Oct 3, 2010 at 3:47 PM, Ayush jainayus...@gmail.com wrote:

Dear Group,

I am proud to announce that I am awarded Microsoft Most Valuable
Professional MVP on October 01, 2010 for providing technical expertise
in Excel technical communities for past one year.

http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx

This is a prestigious award from Microsoft given every Quarter to the
people who share their deep knowledge, real-world experience, and
impartial, objective feedback to help people enhance the way they use
technology.

My deep thanks to each group member for all your support and
contribution to this group.

Best regards,
Ayush Jain
Microsoft MVP

--
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/pages/discussexcelcom/160307843985936?v=wallref=ts

--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com http://akoul.blogspot.com/
*akoul*.wordpress.com http://akoul.wordpress.com/
My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830

P Before printing, think about the environment.

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/pages/discussexcelcom/160307843985936?v=wallref=ts

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/pages/discussexcelcom/160307843985936?v=wallref=ts

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/pages/discussexcelcom/160307843985936?v=wallref=ts

--
Thanks
Regards

Iqbal Merchant
+919833567656

Re: $$Excel-Macros$$ Unique id to name

2010-08-19 Thread Harmeet Singh

This should help.


Warm Regards,

Harmeet Singh
IT Analyst
McKinsey  Company
http://www.facebook.com/Harmeeet


On Thu, Aug 19, 2010 at 7:18 PM, None n8dine4ma...@yahoo.com wrote:

 Unfortunately a puvot table won't work here as I need the formula on each
 line in the worksheet.  Otherwise your suggestion would be a great one.

  --
 *From:* Soni.Rajender soni.rajen...@gmail.com
 *To:* MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
 *Sent:* Wed, August 18, 2010 8:13:21 PM
 *Subject:* Re: $$Excel-Macros$$ Unique id to name

 Hi

 I would suggest you to use pivot for this type of data analysis. You
 can take the count of name in pivot which is what you want.

 Regards
 Rajender Soni | 750 322 55 50

 On Aug 19, 7:34 am, Dave Bonallack davebonall...@hotmail.com wrote:
  Hi,
 
  You can use COUNTIF, which will return 1 if the id has been used only
 once, or greater than 1 if used multiple times.
 
  Regards - Dave.
 
  Date: Wed, 18 Aug 2010 15:54:49 -0700
  From: n8dine4ma...@yahoo.com
  Subject: $$Excel-Macros$$ Unique id to name
  To: excel-macros@googlegroups.com
 
  I have a file that has 2 columns. The first contains an alpha numeric id
 and the second contains the name.  Is there a way to find out if the id is
 associated to more than one name? 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 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
 
  
  HELP US GROW !!
 
  We reach over 7000 subscribers worldwide and receive many nice notes
 about the learning and support from the group.Let friends and co-workers
 know they can subscribe to group athttp://
 groups.google.com/group/excel-macros/subscribe

 --

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

 
 HELP US GROW !!

 We reach over 7000 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe

  --

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

 
 HELP US GROW !!

 We reach over 7000 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


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


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Book2.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Thank you Dave Bonallack !!

2010-08-03 Thread Harmeet Singh

I Second that Ayush...Dave Rocks.Cheers


Warm Regards,

Harmeet Singh
IT Analyst
McKinsey  Company
http://www.facebook.com/Harmeeet


On Sat, Jul 31, 2010 at 2:29 PM, Ayush jainayus...@gmail.com wrote:

 Dear Group,

 In the recent group survey conducted, I asked one question that How
 the top posters should be rewarded in the group ... and most of you
 replied that we should announce the name of top poster every month...

 So the time has come to announce the Top Poster of July 2010 and i.e.

 Our own  Excel and Macros Expert  DAVE BONALLACK.
 He is not only top poster of the month but is the top poster of the
 group with 461 posts.

 Dave, you are the asset of the group and we feel very proud for your
 association with this group. Your voluntary support is very helpful
 ( and life saver for some :) ) .

 We wish you all the best for your assignments and expect long
 association with the group.

 Thank you Dave :)

 I have published the name of monthly top poster on Home Page...
 Keep posting !!

 Regards,
 Ayush Jain
 Group Manager

 P.S. If you have any feedback for group, please fill the survey
 formhttp://www.surveymonkey.com/s/L8BTDNQ

 --

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

 
 HELP US GROW !!

 We reach over 7000 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


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


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ How to ADD product of two columns in a single cell

2010-07-22 Thread Harmeet Singh

Hi There,

See attached file.



Warm Regards,

Harmeet Singh
IT Analyst
McKinsey  Company
http://www.facebook.com/Harmeeet


On Thu, Jul 22, 2010 at 11:42 AM, Rave Patwal ravepat...@gmail.com wrote:

 Please help to add the product of two columns e.g.

 Column1Column2

 23 119
 8954
 63   32

 Want to add (r1c1*r1c2+r2c1*r2c2+r3c1*r3c2)

 Thanks Ravi
 --

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

 
 HELP US GROW !!

 We reach over 7000 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


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


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Book4.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Extract Nth word from string

2010-07-21 Thread Harmeet Singh

I hope this would be helpful for sum1..See attached file.



Warm Regards,

Harmeet Singh
IT Analyst
McKinsey  Company
http://www.facebook.com/Harmeeet

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


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


tp.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Interview questions

2010-07-09 Thread Harmeet Singh

this would help

http://www.coolinterview.com/type.asp?iType=220

http://www.coolinterview.com/type.asp?iType=220
Warm Regards,

Harmeet Singh
IT Analyst
McKinsey  Company
http://www.facebook.com/Harmeeet


On Fri, Jul 9, 2010 at 5:09 PM, Soni.Rajender soni.rajen...@gmail.comwrote:

 Hi

 Questions depends from company to company, however normally asked
 topics are: vlookup, date, if condition, pivot table


 Regards
 Rajender Soni

 On Jul 9, 11:27 am, ALAM aftab.ala...@gmail.com wrote:
  hi!
 
   starting from into..
 
then 1. Lookup (a,b,c)
 2. validations
 3. More VBA
 4. Reports sheets (day/wk/month/year)
 5. filter
 6. list
 7. subtotal
 
  AFTAB  ALI
 
  On 7/9/10, saggi realsa...@gmail.com wrote:
 
 
 
 
 
 
 
   I m not sure how many year experience you have in MIS
   If its executive level interview then prepare Vlookup with ISNA,
   Conditional Formatting, Sumif n Counif formulas and Pivot Table
 
   --
  
 ------
   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
 
   
   HELP US GROW !!
 
   We reach over 7000 subscribers worldwide and receive many nice notes
 about the learning and support from the group.Let friends and co-workers
 know they can subscribe to group athttp://
 groups.google.com/group/excel-macros/subscribe
 
  --
  RegardsThanks,
 
  AFTAB  ALI
  9310903589- Hide quoted text -
 
  - Show quoted text -

 --

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

 
 HELP US GROW !!

 We reach over 7000 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


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


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ IN THE SENTENCE REQUIRE ONE CELL VALUE

2010-06-15 Thread Harmeet Singh

this should help. see attached file


Warm Regards,

Harmeet Singh




On Tue, Jun 15, 2010 at 6:43 PM, big smile bigsmile...@gmail.com wrote:

 Hellow Friends


 Can it possible that

 in cell lets ex. in B1  I write -

 The gross total is Rs. ---[ Cell value of A1 ].

 In between any sentence i want the cell value from any other cell.

 can it possible in between the cell also.

 For ex. -- The gross total is Rs. [ c1]  the gross weight is Rs. [ c2]

 where c1  c2 is the cell value

 Thanks

 Good Day
 From Big Smile
 Savla

 --

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

 
 HELP US GROW !!

 We reach over 7000 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


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


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


eg.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Excel Sheet Renameing Macro Reqired

2010-06-01 Thread Harmeet Singh

*Here you go*
*use mentioned code*
*
*
*Sub ren()*
*
*
*mo = InputBox(Enter Month number.)*
*
*
*For i = 1 To Application.Worksheets.Count*
*
*
*Sheets(i).Name = Left(Sheets(i).Name, 3)  mo  Right(Sheets(i).Name,
3)*
*Next i*
*
*
*End Sub*



Warm Regards,

Harmeet Singh

http://www.facebook.com/libraharry


On Tue, Jun 1, 2010 at 3:07 PM, Venkatesan c venkat1@gmail.com wrote:

  Dear Group,

 I have attached here file for help required.

 I am having 31 sheets the sheet names contains like 31.05.10,30.05.10,etc .
 want to change the sheet names Like 31.06.10,30.06.10,etc by using macros
 automatically

 is there anything macros please assist me

  Best Regards,
 *

 Venkat
 *

 --

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

 
 HELP US GROW !!

 We reach over 7000 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


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


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Post VBA Jobs for Our Group Members

2010-05-21 Thread Harmeet Singh

There is one vacant position for Tech Lead at McKinsey Gurgaon.
Interested people can apply.

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Fri, May 21, 2010 at 7:08 PM, naniram 06n...@gmail.com wrote:

 Yes Shyam,  this is a great helpful for those who are looking Job on
 VBA
 and thanks for all moderators who are helping people a lot.

 regards,
 Naniram

 On May 21, 12:45 pm, rf1234 rf1234 rfhyd1...@gmail.com wrote:
  Dear All,
  We are here in this beautiful group,where every one is giving the
  Helping Hand to Others.
  Really Appreciated,I want to add just little,Some persons will at very
  great position,they
  can help To Give More Efforts.
 
  Please post the job requirements,so that members of our group can be
 benefited.
 
  This is a Request to Moderator to Let us Post all job requirements in
  1 place
 
  --
 
  Thanks Regards
  Shyam
  Software Engineer
 
 ''''''
  When one door of happiness closes, another opens;
   but often we look so long at the closed door that we do not see the
   one which has been opened for us.
  - Helen Keller
 
 ''''''
  Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
  aber oft schauen wir so lange auf die geschlossene Tür,
   dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
 
 ''''''
 
  --
 
 ------
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
  2. Join our 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
 
  
  HELP US GROW !!
 
  We reach over 6,800 subscribers worldwide and receive many nice notes
 about the learning and support from the group.Let friends and co-workers
 know they can subscribe to group athttp://
 groups.google.com/group/excel-macros/subscribe

 --

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

 
 HELP US GROW !!

 We reach over 6,800 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


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


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


JD EAS Tech Lead_GUR_19042010.pdf
Description: Adobe PDF document

Re: $$Excel-Macros$$ Need formula to get the desired cell content.

2010-05-21 Thread Harmeet Singh

   Below Code may help u
Do
   ActiveCell.Offset(1, 0).Select
Loop Until Rows(ActiveCell.Row).Hidden = False

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Fri, May 21, 2010 at 6:46 PM, Vinu vinu1sm...@gmail.com wrote:

 Hello,
 I have 2 sheets.  In one sheet I have a dump data where I will filter based
 on requiremets(only first colounm  i.e, country is only one filter - not
 multi filter).  In the second sheet I used subtotal formula to get some
 fields SUM.  For eg. In sheet1 I have country names coloumns.  whenever I
 filter on any country I should get that country name in the 2nd sheet. Is
 there any way to get this though formula without usig VBA or Pivot.
 (how to tell Excel to pick up the content of the next visible line/row cell
 of headig - it will give you my desired result).

 Attached the workbook.

 Thanks in advance.



 Vinod Kumar
 Bangalore


  --

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

 
 HELP US GROW !!

 We reach over 6,800 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


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


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Permutations and combinations

2010-04-15 Thread Harmeet Singh

For that use FACT formula...
=fact(5)


Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Thu, Apr 15, 2010 at 4:55 PM, Dilip Pandey dilipan...@gmail.com wrote:

 Dear Michael,

 So do you want only two numbers to sum up - at a time
 1+19

 or you want scenarios like below:-
 5+5+5+5 - means more than two digits.  ?

 --
 Thanks  Regards,

 DILIP KUMAR PANDEY
  MBA-HR,B.Com(Hons),BCA
 Mobile: +91 9810929744
 dilipan...@gmail.com
 dilipan...@yahoo.com
 New Delhi - 62, India


 On Thu, Apr 15, 2010 at 12:51 AM, MD18358 michael.e.dray...@citi.comwrote:

 Hi All:

 I don't want the number of Permutations I want to see the
 permutations to a calculated sum.

 For example:  How many different ways can I get 20 by looking at the
 number 1 through 19.
 My answer should look like:

 1+19
 2+18
 3+17
 4+16
 ...etc

 Any ideas???

 As always, Thanks
  c

 --


 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our Facebook Group @
 http://www.facebook.com/group.php?gid=287779555678
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 HELP US GROW !!

 We reach over 6,800 subscribers worldwide and receive many nice notes
 about the learning and support from the group.Let friends and co-workers
 know they can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe




  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our Facebook Group @
 http://www.facebook.com/group.php?gid=287779555678
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 HELP US GROW !!

 We reach over 6,800 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


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


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using remove me as the subject.

Re: $$Excel-Macros$$ Plz Help me urgent

2010-04-06 Thread Harmeet Singh

Good one  guyz nice to see such creative formulas, here is my share of
knowledge.

Kindly check out the index match function without adding additional column.


Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Tue, Apr 6, 2010 at 4:59 PM, Born to Win cs4...@gmail.com wrote:

 your welcome.

 Thanks,
 Chandrabhan Singh
 9911255330



 On Tue, Apr 6, 2010 at 3:57 PM, Anil Saxena anilsaxena170...@gmail.comwrote:

 Thanks Lot Chandrabhan Singh Ji



 On Tue, Apr 6, 2010 at 2:24 PM, Born to Win cs4...@gmail.com wrote:

 Dear Mr. Saxena,

 Please find Attached file.

 Thanks,
 Chandrabhan Singh
 9911255330



 On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena 
 anilsaxena170...@gmail.comwrote:



 Hi Dilip
 plz do the needful it is urgent

 I want the same ans match with ID and Questions ?

 Plz Sir show the Formula also




 Regards

 Anil Saxena

  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our Facebook Group @
 http://www.facebook.com/group.php?gid=287779555678
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 HELP US GROW !!

 We reach over 6,800 subscribers worldwide and receive many nice notes
 about the learning and support from the group.Let friends and co-workers
 know they can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our Facebook Group @
 http://www.facebook.com/group.php?gid=287779555678
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 HELP US GROW !!

 We reach over 6,800 subscribers worldwide and receive many nice notes
 about the learning and support from the group.Let friends and co-workers
 know they can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe




  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our Facebook Group @
 http://www.facebook.com/group.php?gid=287779555678
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 HELP US GROW !!

 We reach over 6,800 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using remove me as the subject.


Harmeet_index match with transpose.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ 12 secret shortcuts of Excel

2010-04-02 Thread Harmeet Singh

Congrats everyone for completing 3 years.
I know all of us would like to thank the Creators of this group Ayush ans
Ashish for making our life easier.

Ayush, the Ebook is simply awesome.

Finally, thanks to all the members for keeping this group alive.

Now, lets make it imortal ;)


Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Fri, Apr 2, 2010 at 8:56 PM, ayush jain jainayus...@gmail.com wrote:

 Dear Members,

 Thanks for all your contribution to the group.

 The group has successfully completed three years. On this occasion, I would
 like to launch an eBook on excel shortcuts written by me recently.
 * Through this eBook I want to show some powerful shortcuts so you become
 more productive and efficient at work.*

 I hope this eBook will help you. Please let me know your feedback.

 Please share this *free eBook* with your friends and colleagues and help
 spreading the word. Thanks.

 Keep Posting!!

 Best regards,
 Ayush Jain
 Group Manager
 http://discussexcel.com/

 P.S. The book is also available in files section of group.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our Facebook Group @
 http://www.facebook.com/group.php?gid=287779555678
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 HELP US GROW !!

 We reach over 6,800 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using remove me as the subject.

Re: $$Excel-Macros$$ Need urgent Help.

2010-04-02 Thread Harmeet Singh

Hi,

PFA file for solution

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Fri, Apr 2, 2010 at 3:45 PM, Baby Patel smritipatel2...@gmail.comwrote:

 Hi All,

 Can anyone help me providing the quick guide on excel formulas.

 I know  muchbut want to prepre for an interview.

 Also can you please help me with below problem
 there are three columns as follows

 post code  value 1 value2Value3
 WQ1 2GX  2000   3000
 WQ15sx500 6000
 AQ2 3CX   30005000
 WQ1 2GX  3000   4000


 I wnat a formula to displat the sum of value for both the columns and
 display it in value 3 for the postcodes which are sAME


 THANKS
 BABY





 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our Facebook Group @
 http://www.facebook.com/group.php?gid=287779555678
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 HELP US GROW !!

 We reach over 6,800 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using remove me as the subject.


Book2.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Please help In seperating alphabets and numbers from a cell

2010-03-31 Thread Harmeet Singh

Thanks Dave
Its my pleasure to get appreciation from a legend (DAVE) :)

God bless u

Thanks Regards,

Harmeet Singh

Sent via BlackBerry Wireless

On Wed, Mar 31, 2010 at 7:52 AM, Dave Bonallack
davebonall...@hotmail.comwrote:

Hi Harmet,
MUCH shorter than mine! Very good.
Does need to be entered with Ctrl+Shift+Enter
Regards - Dave.

--
From: harmeet.hew...@gmail.com
Date: Wed, 31 Mar 2010 05:56:49 +0530
Subject: Re: $$Excel-Macros$$ Please help In seperating alphabets and
numbers from a cell

To: excel-macros@googlegroups.com

*found one more method.*
*PFA file*

Thanks Regards,

Harmeet Singh

Sent via BlackBerry Wireless

On Wed, Mar 31, 2010 at 5:29 AM, Dave Bonallack davebonall...@hotmail.com
wrote:

Hi,
I've thought about it some more and have come up with a rediculously long
formula that does the job.

=MID(MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A10123456789)),100),1,MIN(SEARCH({a,b,c,d,e,f,g,h,I,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z},MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A10123456789)),100)abcdefghijklmnopqrstuvwxyz))-1)

This can be considerably shortened with one or two helper columns.

I've attached a workbook.

Regards - Dave.

--
Date: Tue, 30 Mar 2010 13:55:06 +0530
Subject: $$Excel-Macros$$ Please help In seperating alphabets and numbers
from a cell
From: abhidha.di...@gmail.com
To: excel-macros@googlegroups.com

Dear All

I am seeking for the reply of one queryy
how to seperate alphats and no.
eg: jdsdnc2123asdd
iofruif68732fnvv

thnks in advance

regards
Abhidha

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @
http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about
the learning and support from the group.Let friends and co-workers know they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe

To unsubscribe from this group, send email to excel-macros+
unsubscribegooglegroups.com or reply to this email with the words REMOVE
ME as the subject.

--
Meet local singles online. Browse profiles for
FREE!http://clk.atdmt.com/NMN/go/150855801/direct/01/

--
--

Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @
http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

HELP US GROW !!

To post to this group, send email to excel-macros@googlegroups.com

HELP US GROW !!

--
Download a free gift for your PC. Get personal with
Windows.http://experience.windows.com

To post to this group, send email to excel-macros

Re: $$Excel-Macros$$ Please help In seperating alphabets and numbers from a cell

2010-03-30 Thread Harmeet Singh

*found one more method.*
*PFA file*

Thanks Regards,

Harmeet Singh

Sent via BlackBerry Wireless

On Wed, Mar 31, 2010 at 5:29 AM, Dave Bonallack
davebonall...@hotmail.comwrote:

Hi,
I've thought about it some more and have come up with a rediculously long
formula that does the job.

This can be considerably shortened with one or two helper columns.

I've attached a workbook.

Regards - Dave.

--
Date: Tue, 30 Mar 2010 13:55:06 +0530
Subject: $$Excel-Macros$$ Please help In seperating alphabets and numbers
from a cell
From: abhidha.di...@gmail.com
To: excel-macros@googlegroups.com

Dear All

I am seeking for the reply of one queryy
how to seperate alphats and no.
eg: jdsdnc2123asdd
iofruif68732fnvv

thnks in advance

regards
Abhidha

To post to this group, send email to excel-macros@googlegroups.com

HELP US GROW !!

To unsubscribe from this group, send email to excel-macros+
unsubscribegooglegroups.com or reply to this email with the words REMOVE
ME as the subject.

--
Meet local singles online. Browse profiles for
FREE!http://clk.atdmt.com/NMN/go/150855801/direct/01/

To post to this group, send email to excel-macros@googlegroups.com

HELP US GROW !!

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using remove me as the subject.

Book1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Gift for you all...........

2010-02-13 Thread Harmeet Singh

*Thank you guyz.*
*
*
*I am **overwhelmed with your response*
*
*

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Sat, Feb 13, 2010 at 10:00 PM, Dhananjay Pinjan dppin...@gmail.comwrote:

 Thank you very much!!1


 On 2/11/10, Harmeet Singh harmeet.hew...@gmail.com wrote:

 *Hi Guyzzz*
 *
 *
 *I found a great tool on internet.*
 *You can control Window Media Player using this Excel based tool.*
 *If you have tools like these, kindly share with the group.*
 *
 *
 *Enjoy and keep up the good work.*



 Thanks  Regards,

 Harmeet Singh

 Sent via BlackBerry Wireless


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 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
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com
 
 HELP US GROW !!

 We reach over 6,700 subscribers worldwide and receive many nice notes
 about the learning and support from the group.Let friends and co-workers
 know they can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our Facebook Group @
 http://www.facebook.com/group.php?gid=287779555678

 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 HELP US GROW !!

 We reach over 6,800 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ how to use fillcolor for an condition

2010-01-15 Thread Harmeet Singh

Attached file would help...

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Fri, Jan 15, 2010 at 3:06 PM, Ashok Renga ashokrenga2...@gmail.comwrote:




 when a100 ,i need fill the box with green color


 similarly when a100,i need to fill the box with red colour



 can anyhelp on thisss



 thanks
 ashok

 --

 --
 Some important links for excel users:
 1. Follow us in TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 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
 If you find any spam message in the group, please send an email to:
 Ayush Jain  @ jainayus...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


eg.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Help with pivot table

2010-01-13 Thread Harmeet Singh

*Hope this helps*

[image:
?ui=2view=attth=126281972feb624dattid=0.1disp=attdrealattid=ii_126281972feb624dzw]
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Wed, Jan 13, 2010 at 5:40 PM, Sir Digby Chicken Ceasar 
petercros...@googlemail.com wrote:

 Hi

 Sorry for off topic as this has nothingto do with VBA or MACROS.

 Please could someone tell me how to change the source data range on a
 pivot table in excel 2007?

 I've set up a pivot table which sources data from a list but I've now
 added more to the list and don't want to have to re-make the table.

 In excel 2003 you just had to right click and go back through the
 pivot table wizard to get to the source data section then you could
 change it just buy hi-lighting the area. It doesn't let you do that in
 this version and I was wondering if there is a way or will I just have
 to bite the bullet and start over?

 TIA

 --

 --
 Some important links for excel users:
 1. Follow us in TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 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
 If you find any spam message in the group, please send an email to:
 Ayush Jain  @ jainayus...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


$48227F61F167D79E.png-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ HAPPY NEW YEAR

2009-12-31 Thread Harmeet Singh

thanx ayush, wish u and the group member the same..

*Excel group rock *

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Thu, Dec 31, 2009 at 4:47 PM, Ayush jainayus...@gmail.com wrote:

 Dear Group members,

 Wish you all a very very Happy New Year. May our resolutions come
 true, you'll become more healthy and wealthy this year.

 May this Group achieve new heights and helps more and more excel and
 macro users.

 Best Regards
 Ayush Jain/Ashish Jain
 Group Owners

 --

 --
 Some important links for excel users:
 1. Follow us in TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 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
 If you find any spam message in the group, please send an email to:
 Ayush Jain  @ jainayus...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Locking/Freezing a range of cells

2009-12-22 Thread Harmeet Singh

Hi Vinod,

Attaching a sample file.
If this is what u want, u might wanna read my previous reply again else team
would surely help u.

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Wed, Dec 23, 2009 at 2:53 AM, Vinod N nvino...@gmail.com wrote:

 Hi Harmeet and Praveen,

 Thanks for the your kind reply.. However, as i mentioned in my mail, the
 excel will be shared among many folks, who will be updating it
 simultaneously...

 As of now, I have already locked the formulas as mentioned by Praveen...
 This solution is available in one of the Excel blogs...

 There were many instance where my team inadvertently ended up
 deleting/altering the formulas which had an impact on the output of the
 file...

 Is there any better alternative than the responses of the Harmeet and
 Parveen?

 Thanks
 Vinod




 On Mon, Dec 21, 2009 at 11:36 AM, Harmeet Singh 
 harmeet.hew...@gmail.comwrote:

 to protect selected cells , follow mention steps:


1. Select all cells.
2. goto format cellsprotection then uncheck locked button.
3. Select cells which u wanna protect.goto format cellsprotection
then uncheck locked button.
4. goto format cellsprotection then check locked button.
5. goto tool protection protect sheet then uncheck SELECT LOCKED
CELLS.

 pppf.i m being so patient today..lol

 let me know if it works for u..HAND


 Thanks  Regards,

 Harmeet Singh

 Sent via BlackBerry Wireless


 On Sun, Dec 20, 2009 at 9:00 PM, Vinod N nvino...@gmail.com wrote:

 Hi Excel Gurus,

 I have an shared excel file saved in the shared folder...

 I want to allow users to use from Range A21:K3020. I tried protecting the
 worksheet but there are many limitation. Is there other way of locking other
 that protect worksheet...

 Please help...

 --
 Thanks and Regards

 Vinod N

 --

 --
 Some important links for excel users:
 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 2. Excel tutorials at http://www.excel-macros.blogspot.com
 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com or
 Ashish Jain @ 26may.1...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes
 about the learning and support from the group. Our goal is to have 10,000
 subscribers by the end of 2009. Let friends and co-workers know they can
 subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe





 --
 Thanks and Regards

 Vinod N

 --

 --
 Some important links for excel users:
 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 2. Excel tutorials at http://www.excel-macros.blogspot.com
 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com or
 Ashish Jain @ 26may.1...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes about
 the learning and support from the group. Our goal is to have 10,000
 subscribers by the end of 2009. Let friends and co-workers know they can
 subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

eg.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric values

2009-12-22 Thread Harmeet Singh

*Nice solution Dave.. :)*
*
*
*Vinod,*
*I hope that would help you.
*

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Wed, Dec 23, 2009 at 12:40 PM, Dave Bonallack
davebonall...@hotmail.comwrote:

  Hi Vinod,
 The attached shows how to create an instantly updated unique list from a
 list with duplicates, using a single line ov VBA. It doesn't matter what
 kind of data is in the original list, or how long it is, or whether data is
 added later. The second line of code alphabetizes the unique list and
 removes any blanks that may have been present in the original list.
 Hope you find this useful.
 Regards - Dave.

 --
 Date: Wed, 23 Dec 2009 03:28:52 +0530
 Subject: $$Excel-Macros$$ GetUnique_Collection - to capture numeric values
 From: nvino...@gmail.com
 To: excel-macros@googlegroups.com


 Hi Excel Gurus,

 The following macros complies a unique list from the Range(c21:c3020) and
 populated in Cell J3. However, it does not capture numerical values in the
 said range.

 Please help in modifiying the following macro where it can populate numeric
 as well as alphanumeric unique list


  Sub GetUnique_Collection()

 'Using the Collection object
 Dim SourceRng As Range
 Dim UniqColl As New Collection
 Set SourceRng = Range(c21:c3020)
 On Error Resume Next
 For Each cell In SourceRng.Cells
 UniqColl.Add cell.Value, cell.Value
 Next
 On Error GoTo 0
 ReDim UniqArray(1 To UniqColl.Count)
 For i = 1 To UniqColl.Count
 UniqArray(i) = UniqColl(i)
 Next
 'Optional sort routine can be inserted here
 Range(j3).Resize(UniqColl.Count, 1).Value =
 WorksheetFunction.Transpose(UniqArray)
 End Sub

 --
 Thanks and Regards

 Vinod N

 --

 --
 Some important links for excel users:
 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 2. Excel tutorials at http://www.excel-macros.blogspot.com
 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com or
 Ashish Jain @ 26may.1...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes about
 the learning and support from the group. Our goal is to have 10,000
 subscribers by the end of 2009. Let friends and co-workers know they can
 subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe
 --
 Check out Domain Radar NOW! A world FIRST in property search has 
 arrived!http://clk.atdmt.com/NMN/go/157631292/direct/01/

 --

 --
 Some important links for excel users:
 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 2. Excel tutorials at http://www.excel-macros.blogspot.com
 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com or
 Ashish Jain @ 26may.1...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes about
 the learning and support from the group. Our goal is to have 10,000
 subscribers by the end of 2009. Let friends and co-workers know they can
 subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Locking/Freezing a range of cells

2009-12-20 Thread Harmeet Singh

to protect selected cells , follow mention steps:


   1. Select all cells.
   2. goto format cellsprotection then uncheck locked button.
   3. Select cells which u wanna protect.goto format cellsprotection
   then uncheck locked button.
   4. goto format cellsprotection then check locked button.
   5. goto tool protection protect sheet then uncheck SELECT LOCKED CELLS.

pppf.i m being so patient today..lol

let me know if it works for u..HAND


Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Sun, Dec 20, 2009 at 9:00 PM, Vinod N nvino...@gmail.com wrote:

 Hi Excel Gurus,

 I have an shared excel file saved in the shared folder...

 I want to allow users to use from Range A21:K3020. I tried protecting the
 worksheet but there are many limitation. Is there other way of locking other
 that protect worksheet...

 Please help...

 --
 Thanks and Regards

 Vinod N

 --

 --
 Some important links for excel users:
 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 2. Excel tutorials at http://www.excel-macros.blogspot.com
 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com or
 Ashish Jain @ 26may.1...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes about
 the learning and support from the group. Our goal is to have 10,000
 subscribers by the end of 2009. Let friends and co-workers know they can
 subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Fwd: $$Excel-Macros$$ Running Mecro automatically

2009-10-12 Thread Harmeet Singh

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


-- Forwarded message --
From: Harmeet Singh harmeet.hew...@gmail.com
Date: Mon, Oct 12, 2009 at 7:28 PM
Subject: Re: $$Excel-Macros$$ Running Mecro automatically
To: Manish Pansari pansari.man...@gmail.com


Here u go

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Mon, Oct 12, 2009 at 1:43 PM, Manish Pansari pansari.man...@gmail.comwrote:

 Thanks Harmeet,

 But I am not be able to do it. Can you pls send me a sample mecro file for
 the same.

 Thanks in advance buddy !! ! :)

 -
 Manish Pansari

 On Mon, Oct 12, 2009 at 2:24 PM, Harmeet Singh 
 harmeet.hew...@gmail.comwrote:

 *Below code will help*
 *
 *
 *Sub waitt()*
 *For i = 1 To 5 'will run 5 times*
 *'ur code*
 *Application.Wait Now + TimeValue(00:00:05) '''will wait for 5 seconds*
 *Next*
 *End Sub*

 Thanks  Regards,

 Harmeet Singh

 Sent via BlackBerry Wireless


 On Sun, Oct 11, 2009 at 2:29 PM, Manish Pansari pansari.man...@gmail.com
  wrote:


 Hello Friends,

 I want to run a macro continuously after every five minutes. Is there
 any option, by using that I can set macro run time and can run macro
 automatically?

 Thanks,
 Manish

 




--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Book1.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Plz Help

2009-10-11 Thread Harmeet Singh

*Tried to solve the issue in one column, i hope this helps :)**see attached
file*
*
*

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Sun, Oct 11, 2009 at 9:30 AM, Prashant Bhawar
prashant.aca...@gmail.comwrote:


 Plz help here i attached a problem file with required ans. plz help me
 --
 Warm Regard

 Prashant Bhawar

 ( CA  Final )

 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



PROBLEM.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Converting Date to uppercase

2009-10-11 Thread Harmeet Singh

*Enter date in cell A1 then **Use formula-
 =UPPER(TEXT(A1,dd-mmm-))**I hope this will solve the issue.*

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Sun, Oct 11, 2009 at 7:37 AM, Praveen Khunte praveen.khu...@gmail.comwrote:


 I have a requirement where date needs to be in uppercase. Please reply
 how to convert a cell which is displays today's date to uppercase. For
 example 11 Oct 2009 to 11 OCT 2009. Using Upper function didn't help
 me.

 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: PUZZLE Use functions only

2009-10-04 Thread Harmeet Singh

*Had to create an UDF...see attached file.not sure if it can be done
using formula in one cell.*

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Sat, Oct 3, 2009 at 10:41 PM, Sandeep sandymau...@gmail.com wrote:

  Reverse a text or number or mixed value entered in a cell using functions
 only not VBA.

 e.g.
 Say A1 = ABC351D

 Then the answer in cell A2 should be D153BCA

 The entered value may be text or number anything but result should be
 reversed.

 Regards
 Sandeep

 



--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



rt.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Converting data into date

2009-09-29 Thread Harmeet Singh

Hope below code helps:
*Cells(1, 1).Value = Format(23-Mar-2009, /mm/dd)*
*
*
*
*Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Mon, Sep 28, 2009 at 10:39 PM, Duncan - UK duncan...@googlemail.comwrote:


 Hi there,

 Fairly new to VBA.

 I am trying to convert a column (header is date) into dates.

 For some reason using the below does not seem to work:

  Selection.NumberFormat = /mm/dd

 Any idea?

 Thanks.

 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Access To Excel

2009-09-28 Thread Harmeet Singh

*attached file would help u**
*Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Mon, Sep 28, 2009 at 5:29 PM, Jack j...@jackcwood.co.uk wrote:


 How can I create an import  from ms access to excel  where a user does
 not have access application ??
 spent ages trying to work it out ?
 Anyone have an idea ?

 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

attachment: b.png

$$Excel-Macros$$ Re: Access To Excel

2009-09-28 Thread Harmeet Singh

Please check on ur system after uninstalling ms access.
I would have checked, but using MSaccess for some urgent deliverable. :)


Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Mon, Sep 28, 2009 at 7:26 PM, Jack j...@jackcwood.co.uk wrote:

 Thanks Harmeet

 But will the end user be able to refresh the query even when they do
 not have
 ms access installed on their PC.

 Cheers

 Jack

 On Sep 28, 2:33 pm, Harmeet Singh harmeet.hew...@gmail.com wrote:
  *attached file would help u**
  *Thanks  Regards,
 
  Harmeet Singh
 
  Sent via BlackBerry Wireless
 
 
 
  On Mon, Sep 28, 2009 at 5:29 PM, Jack j...@jackcwood.co.uk wrote:
 
   How can I create an import  from ms access to excel  where a user does
   not have access application ??
   spent ages trying to work it out ?
   Anyone have an idea ?
 
 
 
   b.png
  25KViewDownload- Hide quoted text -
 
  - Show quoted text -

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: how to change decimal ccoordinates into DDMMSS fromat

2009-09-27 Thread Harmeet Singh

*See attached file*

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Fri, Sep 25, 2009 at 4:32 PM, Mahesh mahender.bi...@gmail.com wrote:

 Dear friends,

 Need your help.

 i want to convert decimal coordinates into DDMMSS.

 9.73877=   09 44 20

 --
 With Love,
 Mahesh Bisht

 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



fdfd.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Need to color the duplicates

2009-09-23 Thread Harmeet Singh

Hi Sonia,

If you open the VBE window, u will see a for each loop, that is changing the
cell color for all the selected cells.

Let me know if more clarification is required. :)

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Wed, Sep 23, 2009 at 1:34 PM, Sonia Singla sonia...@gmail.com wrote:

 Hi harmeet

 One thing more is, its working only when cells contain numerical data but
 what about when cells contain text.

 Sonia

 On Wed, Sep 23, 2009 at 9:53 AM, Sonia Singla sonia...@gmail.com wrote:

 Hi harmeet

 Thanks yar but can u explain me how is it working.

 Sonia

   On Tue, Sep 22, 2009 at 4:32 PM, Harmeet Singh 
 harmeet.hew...@gmail.com wrote:

 *Hi Sonia,* *
 *
 *Thanks for appreciation.*
 *
 *
 *Please note that, the macro provided by me will work for N x N matrix.*
 *
 *
 *Fro reference I have attached the macro file.*
 *
 *
 *You just need to click on the button when the file opens.*
 *
 *
  *Thanks  Regards,

 **Harmeet** Singh

 Sent via **BlackBerry** Wireless

 *
   On Tue, Sep 22, 2009 at 1:29 PM, Sonia Singla sonia...@gmail.comwrote:

 Hi Harmeet

 thanks for your reply. I have already made a macro if the data is in nX1
 but i was unable to make a macro if we have a data in nXm matrix.
 For example please see the attached file.

 Thanks and regard
 Sonia

   On Mon, Sep 21, 2009 at 7:05 PM, Harmeet Singh 
 harmeet.hew...@gmail.com wrote:

 *Updated one..*
  *
 *
 Thanks  Regards,

 Harmeet Singh

 Sent via BlackBerry Wireless


 On Mon, Sep 21, 2009 at 6:40 PM, Sonia Singla sonia...@gmail.comwrote:

 Hi

 I have the data in an array say in nXm. I want to make a macro color
 the cells with the same color having the same next.

 for example cells having 2 should have color red, cells having 5
 should have color blue etc.

 Thanks
 Sonia

 







--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: forgot password

2009-09-23 Thread Harmeet Singh

can u send that file..
i will try to recover passowrd..

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Wed, Sep 23, 2009 at 8:27 PM, manish manish_karandi...@yahoo.com wrote:


 ive forgot password to the new project  macro i have created in VB
 excel. how to recover that macro password. can someone please tell me
 the method to find it.
 regards
 manish

 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Need to color the duplicates

2009-09-21 Thread Harmeet Singh

*See attached file and let me if it helps..*
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Mon, Sep 21, 2009 at 6:40 PM, Sonia Singla sonia...@gmail.com wrote:

 Hi

 I have the data in an array say in nXm. I want to make a macro color the
 cells with the same color having the same next.

 for example cells having 2 should have color red, cells having 5 should
 have color blue etc.

 Thanks
 Sonia

 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



cellcolor.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Need to color the duplicates

2009-09-21 Thread Harmeet Singh

*opps gave u wrong file*
*please check attached file (updated)*


Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Mon, Sep 21, 2009 at 6:56 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:

 *See attached file and let me if it helps..*
 Thanks  Regards,

 Harmeet Singh

 Sent via BlackBerry Wireless


 On Mon, Sep 21, 2009 at 6:40 PM, Sonia Singla sonia...@gmail.com wrote:

 Hi

 I have the data in an array say in nXm. I want to make a macro color the
 cells with the same color having the same next.

 for example cells having 2 should have color red, cells having 5 should
 have color blue etc.

 Thanks
 Sonia




 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



cellcolor.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Vlookup and If formula

2009-09-17 Thread Harmeet Singh

Open below page from ur new id and join the group:
http://groups.google.com.sg/group/excel-macros

http://groups.google.com.sg/group/excel-macros
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Thu, Sep 17, 2009 at 4:25 PM, VELMURUGAN 
velmurugan.vellpand...@tessolve.com wrote:


 Hi
I wish to change my email id. Kindly suggest me how can i get the mail
 from our group to my new id instead of this.

 Thanks
 Velmurugan

 - Original Message -
 From: Jitu 7jit...@gmail.com
 To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
 Sent: Thursday, September 17, 2009 2:38 PM
 Subject: $$Excel-Macros$$ Re: Vlookup and If formula



 Great thought sir,

 I will definitely follow your advice.

 Thanks

 Jitheesh Janardhan


 --
 DISCLAIMER:

 This message and any attachments are solely for the intended recipient
 and may contain confidential or privileged information. If you are not
 the intended recipient, any disclosure, copying, use, or distribution of
 the information included in this message and any attachments is
 prohibited. If you have received this communication in error, please
 notify us by reply e-mail and immediately and permanently delete this
 message and any attachments. Thank you.


 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Vlookup and If formula

2009-09-16 Thread Harmeet Singh

Thanks Jiju, no need of cake, ur one line of gratitude is more than enough
to make my day.
But one suggestion from me, always go for the toughest solutions as* Smooth
roads never make good drivers.*
*
*
Happy learning...
* *Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Wed, Sep 16, 2009 at 3:01 PM, Jitu 7jit...@gmail.com wrote:


 Hi prashant,

 Thankyou for your suggestion.

 I think next time, I have to use pivot tables rather than a formula.

 I'm just at a beginner and recreating such complex formulas like
 harmeetji's would be tough for me.

 Thankyou guys-


 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: AUTO UPDATE

2009-09-16 Thread Harmeet Singh

Please provide a sample file with example...
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Wed, Sep 16, 2009 at 3:27 PM, Shimmy morur...@gmail.com wrote:


 Hi, I have data in sheet1 showing Name, gender, Place of residence and
 period of employment as respective columns. The problem is I havae
 only entered up to 30 entries as rows. In sheet two, I have my
 commands for COUNTS for gender and the other commands; At the end of
 my projects  I must have 100 entries in the sheet1. I would like to
 know if there is a command that I can use to auto update my commands
 as enter the data, that is, the counts should automatically be updated
 as I enter the data.

 Please help, I am still knew in EXCEL usage

 I hope that you attend to my  plight

 Regards
 Shimmy

 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Help Needed for Debit Credit entries

2009-09-16 Thread Harmeet Singh

*please provide a sample file*
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Wed, Sep 16, 2009 at 7:44 PM, Deep pradeep170...@gmail.com wrote:

 Dear Freinds,
   I am attaching one file which contains debit  credit
 amounts in same column. But previous column have D or C written which
 represents the amount is Debit or Credit [D for debit  C for Credit]
   I want to nullify {neutralise} if debit  credit
 amount is same. For example


  00630033275492006033020060330OWN CHQ XFER DP

  C
  1000
  00630033275492006033020060330WDL TFR
  TRF TO 0099514300813
  D
  1000


 That means this two rows get seperated or colour change or get delected of
 represented as Zero Value. This all work I have to do manually by searing
 each an every entry.

 *The aim of this work is to find out those entries which do not have
 corresponding debit entries or viceversa.*

 Is some solution is there in excel programing.

 If possible, please provide me. Thanks a lot in advance.


 Pradeep Agarwal
 pradeep170...@gmail.com
 pradeep.agra...@licindia.com


 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Count of Colored Cells

2009-09-15 Thread Harmeet Singh

*See attached file**found very nice function in vba...*
*hope this helps*

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Tue, Sep 15, 2009 at 1:55 PM, Dave Bonallack
davebonall...@hotmail.comwrote:

  Hi Pooja
 Not possible in 2003 usinf formulas. Have to use VBA.
 And if the cells are colored as a result of conditional formatting, it's
 even trickier.
 Regards - Dave.

 --
 Date: Tue, 15 Sep 2009 11:15:43 +0530
 Subject: $$Excel-Macros$$ Count of Colored Cells
 From: vatspoojav...@gmail.com
 To: excel-macros@googlegroups.com

 Hi Friends,

 I have a query regarding counting of Colored cells. I want to know, is it
 possible to count the no. of cells filled with a particular color with the
 help of a formula. If yes then please guide me and help me in resolving
 this.

 Attached is a file which has an example, how I want to count the cells.

 --
 Best Regards
 Pooja Sharma




 --
 Find out how here Use Messenger in your Hotmail 
 inboxhttp://windowslive.ninemsn.com.au/article.aspx?id=823454
 



--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



color count.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: CODING

2009-09-14 Thread Harmeet Singh

*See below attached pic.**mentioned few steps, that would help u.
*

[image: 1.png]


Harmeet Singh

Sent via BlackBerry Wireless


On Mon, Sep 14, 2009 at 1:15 PM, Shimmy morur...@gmail.com wrote:


 Hi

 I am a new user of excel and have this problem:
 I have created a database in excel by entering codes. i.e. I entered
 Male as 1 and Female as 2.
 I woukd like to know if there is a command that I can use to convert
 the codes back to the words i.e to male and female

 Please, I tried but did not get the solution. If there is anyone that
 can help me kindly do so.

 Regards
 Shimmy

 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

inline: 1.png

$$Excel-Macros$$ Re: Userform for 10 secs

2009-09-11 Thread Harmeet Singh

Below code may help u

*Sub um()*
*If Application.Wait(Now + TimeValue(0:00:10)) Then*
*MsgBox Time expired  ' or write Unload Me here*
*End If*
*End Sub*


Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Fri, Sep 11, 2009 at 10:23 AM, suresh k brave.sur...@gmail.com wrote:

 Hi,

 I have created Userform which will open when the excel sheet opens, but how
 to keep it only for 10 secs.
 After 10 seconds it should close automatically.

 Any macro code for that??


 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Need to sort spreadsheet based on values in Column A

2009-09-10 Thread Harmeet Singh

Its fine.just have a chill pill...LOLz

Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Thu, Sep 10, 2009 at 11:00 PM, rad...@progressivetel.com 
rad...@progressivetel.com wrote:


 My most humble of apologies... this is correct... I confused myself... many
 apologies and many thanks!

 Lee

 Original Message:
 -
 From: Harmeet Singh harmeet.hew...@gmail.com
 Date: Thu, 10 Sep 2009 02:10:25 +0530
 To: excel-macros@googlegroups.com
 Subject: $$Excel-Macros$$ Re: Need to sort spreadsheet based on values in
 Column A


 *See attached file*

 On Wed, Sep 9, 2009 at 11:08 PM, rad...@progressivetel.com 
 rad...@progressivetel.com wrote:

  All you wise and mighty Excel gurus... I have the attached spreadsheet. I
  will be scanning in the values (via a barcode scanner) into column A.
 What
  I then need is a macro that will leave the Column A values in the order
  that they appear, but then sort columns B,C and D to match the value in
  Column C to that of Column A. The number of rows may vary, so it would be
  nice to have something that an amateur like myself could modify (or that
  would work with any number of rows).
 
  Thanks in advance!
 
  
  mail2web.com - Microsoft® Exchange solutions from a leading provider -
  http://link.mail2web.com/Business/Exchange
 
 
  
 


 --
 Thanks  Regards,

 Harmeet Singh

 Sent via BlackBerry Wireless




 
 mail2web.com – Enhanced email for the mobile individual based on
 Microsoft®
 Exchange - http://link.mail2web.com/Personal/EnhancedEmail



 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Need to sort spreadsheet based on values in Column A

2009-09-09 Thread Harmeet Singh

*See attached file*

On Wed, Sep 9, 2009 at 11:08 PM, rad...@progressivetel.com 
rad...@progressivetel.com wrote:

 All you wise and mighty Excel gurus... I have the attached spreadsheet. I
 will be scanning in the values (via a barcode scanner) into column A.  What
 I then need is a macro that will leave the Column A values in the order
 that they appear, but then sort columns B,C and D to match the value in
 Column C to that of Column A. The number of rows may vary, so it would be
 nice to have something that an amateur like myself could modify (or that
 would work with any number of rows).

 Thanks in advance!

 
 mail2web.com - Microsoft® Exchange solutions from a leading provider -
 http://link.mail2web.com/Business/Exchange


 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Book1.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Puzzle #1 - Generate the Sample Pattern (VBA)

2009-09-08 Thread Harmeet Singh

Hi Sandeep,
I couldn't find any macro in the file.
Please check

On Tue, Sep 8, 2009 at 6:47 PM, Sandeep sandymau...@gmail.com wrote:

  Hi Ashish,
 Check the result.

 Regards
 Sandeep

 - Original Message -
 *From:* Ashish Jain 26may.1...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Sunday, September 06, 2009 10:06 AM
 *Subject:* $$Excel-Macros$$ Puzzle #1 - Generate the Sample Pattern (VBA)

 Hi All,

 This is challenge for all excel users. Solve these puzzles and sharpen your
 excel acumen. So, here goes the first puzzle of Excel Macros Google Group
 in attached file.

 --
 Regards
 Ashish Jain
 (Excel Macros - Google Group Manager)
 http://www.excelitems.com
 (Developer of OpenXL)
 http://www.openexcel.com

 Excel,VBA,VSTO Trainer
 +91..40.48.43
 --
 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Query

2009-09-08 Thread Harmeet Singh

Follow below steps:

   1. *Select table where blank cells exist.*
   2. *Press F5*
   3. *Click on Special and then Blanks.*
   4. *Enter 0 and press Ctrl+Enter simultaneously.*

U r done.



On Tue, Sep 8, 2009 at 3:10 PM, Ankur Satija ankursat...@gmail.com wrote:

 How to put zero ('0') in Blank Cells  scattered in a table?

  -
 Ankur Satija, Consultant


 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Filter problem

2009-09-08 Thread Harmeet Singh

Hi Prashant,Unfortunately, excel can show you first 100 unique entries only
in auto filter (It is hard coded in Excel)

Workaround can be pivot table.



On Tue, Sep 8, 2009 at 11:56 AM, Prashant Pednekar prashant...@gmail.comwrote:

 Dear all

 Thanks for the knowlege enrichment of excel by you all...

 I am facing problem with Filter. While filtering data I am not able to see
 the data after specific cell.
 See the filter range.bmp.
 In the file i am not able to see the rows after value 3264.( see Book
 master 2. worksheet in filter problem file)

 But If I am using custom filter for values above 3260 and the rows all rows
 after 3260 can be views.( see Book master 3. worksheet in filter problem
 file)

 My problem How I can see the values after 3264 in book master 2 worksheet ?


 Thanks for your time .

 Waiting for your reply.

 Prashant.

 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: hi thanks for the help

2009-09-07 Thread Harmeet Singh

Just added some lines to Daniel's code.
See attached file...

On Mon, Sep 7, 2009 at 11:34 AM, ashish koul koul.ash...@gmail.com wrote:

 hi

 can you please give ma  codes which will remove the unwated or_ at the
 end of emailds in attachment


 thanks

 ashish


 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



example (2).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: hi thanks for the help

2009-09-07 Thread Harmeet Singh

*Sorry, attached wrong file**try the attached file.*

On Mon, Sep 7, 2009 at 2:27 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:

 Just added some lines to Daniel's code.
 See attached file...


 On Mon, Sep 7, 2009 at 11:34 AM, ashish koul koul.ash...@gmail.comwrote:

 hi

 can you please give ma  codes which will remove the unwated or_ at the
 end of emailds in attachment


 thanks

 ashish


 



 --
 Thanks  Regards,

 Harmeet Singh

 Sent via BlackBerry Wireless




-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Example (1).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: help plz

2009-09-07 Thread Harmeet Singh

then use this file...

On Mon, Sep 7, 2009 at 3:54 PM, ashish koul koul.ash...@gmail.com wrote:

 hi


 thanks harmeet

 but in this case it only works with emailids ending with .com wht if iit
 ends with .net or .org or .in






 On Mon, Sep 7, 2009 at 6:12 AM, Daniel dcolarde...@free.fr wrote:

  Hi.



 Can you attach a sample file to your reply ?



 Daniel



 *From:* excel-macros@googlegroups.com [mailto:
 excel-mac...@googlegroups.com] *On Behalf Of *ashish koul
 *Sent:* dimanche 6 septembre 2009 18:00
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Re: help plz



 hi thanks

 i went through the site i am able to clean and trim but in below case i am
 not abe to find the solution

 ashish k...@gmail.com.   result should be ashishk...@gmail.com
 koulashish   @gmail.com...result should be koulash...@gmail.com
 koul.ashish  @gmail.com result should be koul.ash...@gmail.com
   thanks


 ashish








 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



tt(1).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Puzzle #1 - Generate the Sample Pattern (VBA)

2009-09-06 Thread Harmeet Singh

Thanks Ashish, but don't forget u will be sending more like this. correct?
 :)

On Sun, Sep 6, 2009 at 4:15 PM, Ashish Jain 26may.1...@gmail.com wrote:


 Hi Harmeet,

 That's fantastic. and good that you protected the code. I want
 everyone to try, so that their logic and vba skills can be sharpened.
 Well Done Harry.


 --
 Regards
 Ashish Jain
 (Excel Macros - Google Group Manager)
 http://www.excelitems.com
 (Developer of OpenXL)
 http://www.openexcel.com

 Excel,VBA,VSTO Trainer
 +91..40.48.43
 --
 On Sep 6, 12:55 pm, Harmeet Singh harmeet.hew...@gmail.com wrote:
  *Hey **Ashish**,**Thanks a lot for this interesting puzzle.*
  *Looking forward for more innovative puzzles.*
  *
  *
  *Solution is attachedLet me know if I have done it
  appropriately.*
 
 
 
  On Sun, Sep 6, 2009 at 10:06 AM, Ashish Jain 26may.1...@gmail.com
 wrote:
   Hi All,
 
   This is challenge for all excel users. Solve these puzzles and sharpen
 your
   excel acumen. So, here goes the first puzzle of Excel Macros Google
 Group
   in attached file.
 
  
 --
   Regards
   Ashish Jain
   (Excel Macros - Google Group Manager)
  http://www.excelitems.com
   (Developer of OpenXL)
  http://www.openexcel.com
 
   Excel,VBA,VSTO Trainer
   +91..40.48.43
  
 --
 
  --
  Thanks  Regards,
 
  Harmeet Singh
 
  Sent via BlackBerry Wireless
 
   Puzzle #1.xls
  109KViewDownload
 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: How to create new file with name and content from excel

2009-09-06 Thread Harmeet Singh

*Created a tool.**See attached file..*

On Sun, Sep 6, 2009 at 11:10 PM, mykijune kings...@elp.rr.com wrote:


 How can I create multiple new files using data from excel? For
 example:

 A1=ProductName1 B2=Productdescription1
 A2=ProductName2 B2=Productdescription2

 Etc..

 To:

 productname1.txt (containing productdescription1)
 productname2.txt (containing productdescription2)


 in specified folder products for example.
 Etc..

 Thanks.

 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



export.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: How to create new file with name and content from excel

2009-09-06 Thread Harmeet Singh

*Created a tool.
*See attached file..

On Sun, Sep 6, 2009 at 11:10 PM, mykijune kings...@elp.rr.com wrote:


 How can I create multiple new files using data from excel? For
 example:

 A1=ProductName1 B2=Productdescription1
 A2=ProductName2 B2=Productdescription2

 Etc..

 To:

 productname1.txt (containing productdescription1)
 productname2.txt (containing productdescription2)


 in specified folder products for example.
 Etc..

 Thanks.

 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



export.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: excel macros -non numeric value

2009-09-02 Thread Harmeet Singh

*see attached file*

On Wed, Sep 2, 2009 at 1:37 PM, ymusafi ymus...@gmail.com wrote:


 Hi All
 I want to create a macro that is doing somthing if the cell value has
 non numeric  value
 meaning:
 if cell.value=???then
 I just need to know what to put instead of the question marks
 Thanks!

 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Book2.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: compare two list

2009-08-28 Thread Harmeet Singh

*Check attached file.*

2009/8/28 Sandeep sandymau...@gmail.com

  Hi Manoj,
 Find the attached solution

 Regards
 Sandeep

 - Original Message -
 *From:* Manoj Kukrej manoj...@ocimumbio.com
 *To:* dilipan...@gmail.com
 *Cc:* excel-macros@googlegroups.com
 *Sent:* Friday, August 28, 2009 12:55 PM
 *Subject:* $$Excel-Macros$$ compare two list

  Hi Dilip ,



 I want to compare two range ,-for finding the common  uncommon  (nos or
 text in it) presently I am using conditional formatting  using countif fn



 Pls tell me how I check it through other methods



 Regards



 Manoj



 *From:* excel-macros@googlegroups.com [mailto:
 excel-mac...@googlegroups.com] *On Behalf Of *Dilip Pandey
 *Sent:* Friday, August 28, 2009 10:05 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Re: Advanced conditional formatting



 Hi Liuxin,



 This is because, when you use absolute reference ($ref$), conditional
 formatting logics on the entire row is checking if that particular reference
 is meeting the logics or not.  Moreover, when you apply that logic towards
 right direction to cover entire row, the logic still checks only that
 particular reference, which is still meeting up with the criteria defined
 and hence, entire row gets colored.



 For more details, refer to the attachement which I just forwarded to Suresh
 and Group.



 Let me know in case of any queries.  Thanks



 --
 DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
 Mobile: +91 9810929744
 dilipan...@gmail.com
 dilipan...@yahoo.com
 New Delhi - 110062





 On 8/27/09, *liuxin9...@gmail.com* liuxin9...@gmail.com wrote:


 I have a question.
 When I use the relative reference in the formula, there is only one
 cell colored.
 While if I use the absolute reference, the complete row is colored,
 why?

 On 8月27日, 下午10时53分, Dilip Pandey dilipan...@gmail.com wrote:
  Dear Suresh,  I think you forgot to attach the file.  Please re-attach
 and
  send.  Thanks.
  --
  DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
  Mobile: +91 9810929744
  dilipan...@gmail.com
  dilipan...@yahoo.com
  New Delhi - 110062
 
 
 
  On Thu, Aug 27, 2009 at 8:17 PM, suresh k brave.sur...@gmail.com
 wrote:
   Hi Dilip,
 
   Can you check this attachment. Its having three options TRUE, FALSE
 and
   Not available. In this case is it possible to highlight entire rows in
   different color based on the result.
 
   On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey dilipan...@gmail.com
 wrote:
 
   Hi Suresh.
 
   Attached file has the scenario and the explanation for your query.
 Thanks
 
   --
   DILIP KUMAR PANDEY
 MBA-HR,B COM(Hons.),BCA
   Mobile: +91 9810929744
   dilipan...@gmail.com
   dilipan...@yahoo.com
   New Delhi - 110062
 
   On Thu, Aug 27, 2009 at 4:51 PM, suresh k brave.sur...@gmail.com
 wrote:
 
   Hi Guyz,
 
   Whenever we use conditional formatting it will be applied for current
   cell only.
 
   Is there anyway that if the condition is true the entire row should
 be
   colored???
 
   Regards,
   Suresh
 br

 --
 This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
 solely for the use of the addressee(s). If you are not the intended
 recipient, please notify the sender by e-mail and delete the original
 message. Further, you are not to copy, disclose, or distribute this e-mail
 or its contents to any other person and any such actions that are unlawful.
 This e-mail may contain viruses. Ocimum Biosolutions has taken every
 reasonable precaution to minimize this risk, but is not liable for any
 damage you may sustain as a result of any virus in this e-mail. You should
 carry out your own virus checks before opening the e-mail or attachment.
 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Book2.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: compare two list

2009-08-28 Thread Harmeet Singh

*See attached file...*

On Fri, Aug 28, 2009 at 3:08 PM, Manoj Kukrej manoj...@ocimumbio.comwrote:

  Hi All ,



 similar Items are @ different rows just like in attached file



 I want to compare two range ,-for finding the common  uncommon  (nos or
 text in it) presently I am using conditional formatting  using countif fn



 Pls tell me how I check it through other methods



 Regards



 Manoj



 --
 This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
 solely for the use of the addressee(s). If you are not the intended
 recipient, please notify the sender by e-mail and delete the original
 message. Further, you are not to copy, disclose, or distribute this e-mail
 or its contents to any other person and any such actions that are unlawful.
 This e-mail may contain viruses. Ocimum Biosolutions has taken every
 reasonable precaution to minimize this risk, but is not liable for any
 damage you may sustain as a result of any virus in this e-mail. You should
 carry out your own virus checks before opening the e-mail or attachment.

 




-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Book2.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: IF condition formula

2009-08-25 Thread Harmeet Singh

I think Dilip has already provided the solution.


plese refer to attached file.




On Tue, Aug 25, 2009 at 5:53 PM, suresh k brave.sur...@gmail.com wrote:


 Can anyone provide me the formula for below query.

Report Date Total Logged Time at Work Hrs 7/2/2009 8.86 7/2/2009 9.03
 7/2/2009 7.92 7/2/2009 9.02 7/3/2009 9.05
 Answer should be 26.91. Excluding the value less than 8.00 hrs and it
 should calculate only for one day(7/2/2009).

 I have tried if condition, and not able to give both the conditions.

 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Total Logged Time - bY DILipandey.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Urgent:: Need code to run batch script thru Excel

2009-08-24 Thread Harmeet Singh

try below code:
Sub Runbf()
Dim obf
obf = Shell(D:\Documents and Settings\Harmeet
Singh\Desktop\IP_Address.bat, 1)
End Sub



On Mon, Aug 24, 2009 at 4:52 PM, bharghav r bhargha...@gmail.com wrote:


  Hi all,



 I am in need of a macro which will run  a batch script.


 Is there any alternative to call a batch file other than the below code.
 The below code is not reliable


 Public Sub runBat()
   Dim RetVal
   RetVal = Shell(cmd.exe /c %PLANNING_HOME%\bin\pum.bat)
End Sub


 Kindly tweak if necessary n make it working guyz...



 Thanks and Regards

 Bharghav R

 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Add multiple comments

2009-08-05 Thread Harmeet Singh

see attached file

On Wed, Aug 5, 2009 at 3:27 PM, mageshwaran jayaraman
macwa...@yahoo.co.inwrote:

   If till now, no body has replied then try this
 Before deleting the entries, in a new cell put the comments in text.
 then use '' key eg..if ur numerical entry is in B2 and comment in F2, then
 in G2 put formula =B2F2

 Send me your excel file or sample one and I'd solve it with formula.

 Thanx 'n' rgds,
 Mageshwaran J.
 --
 *From:* Jaspal Rehal rehal.jas...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Tuesday, 4 August, 2009 10:48:23 PM
 *Subject:* $$Excel-Macros$$ Add multiple comments


 Hi,

 I have to delete so many cell entries in my daily job and input those
 cell entries in the comments with some text. Any shortcut for the same
 would be helpful ...

 Rg

  --
 Yahoo! recommends that you upgrade to the new and safer Internet Explorer
 8http://in.rd.yahoo.com/tagline_ie8_1/*http://downloads.yahoo.com/in/internetexplorer/
 .
 




-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



test(1).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: One paste for many cells

2009-08-05 Thread Harmeet Singh

Before pasting ur values press F2 then paste the text which u copied from
notepad.

I hope this will help

On Wed, Aug 5, 2009 at 1:42 PM, Vivien Parlat poc...@gmail.com wrote:


 Hello,

 When I write the following string in notepad:

 A tab B newline
 C tab D

 and copy/paste it to Excel, it fills 4 cells.
 I tried to set the value of a range in a macro to a string containing
 an equivalent content (a  vbTab  b  vbNewLine  c  vbTab 
 d)
 But this does not work.

 Could someone give me the magic lines to do that in programmatically ?

 Thank you in advance

 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: $$Excel-Macros$$

2009-08-05 Thread Harmeet Singh

Try to use shortcut key.*Shift + Space Bar*

On Tue, Aug 4, 2009 at 2:29 PM, Sheyn Lee sheyn...@gmail.com wrote:

 Dear All,
 Is there any option that when I select a cell in the sheet, the whole row
 corresponding to that cell is highlighted.
 In the attached example I have selected cell C7.  Required: the whole row 7
 should be highligted.
 Thanks and regards,
 Sheyn

 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Overflow error in Excel 2007 VBA

2009-07-30 Thread Harmeet Singh

Couldn't figure out why but workaround is:


Sub Test
Dim a As Long
Dim b As Long
Dim c As Long
Dim d As Long
Dim e As Long
a = 4
b = 7 * 100
c = *a* * 1 '  Why do I get an overflow error here?
d = 100
e = a + b + c + d
End Sub

On Thu, Jul 30, 2009 at 8:20 AM, Cliff ragsdal...@gmail.com wrote:



 I can't figure out why  I am getting an overflow error on the line
 indicated below.  Any suggestions?


 Sub Test

 Dim a As Long
 Dim b As Long
 Dim c As Long
 Dim d As Long
 Dim e As Long

 a = 4
 b = 7 * 100
 c = 4 * 1 '  Why do I get an overflow error here?
 d = 100
 e = a + b + c + d

 End Sub

 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: To Unprotect Sheet

2009-07-28 Thread Harmeet Singh

use this code



Sub PasswordBreaker()


  Dim i As Integer, j As Integer, k As Integer
  Dim l As Integer, m As Integer, n As Integer
  Dim i1 As Integer, i2 As Integer, i3 As Integer
  Dim i4 As Integer, i5 As Integer, i6 As Integer
  On Error Resume Next
  For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
  For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
  For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
  For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126


 ActiveSheet.Unprotect Chr(i)  Chr(j)  Chr(k)  _
  Chr(l)  Chr(m)  Chr(i1)  Chr(i2)  Chr(i3)  _
  Chr(i4)  Chr(i5)  Chr(i6)  Chr(n)
  If ActiveSheet.ProtectContents = False Then
  MsgBox One usable password is   Chr(i)  Chr(j)  _
  Chr(k)  Chr(l)  Chr(m)  Chr(i1)  Chr(i2)  _
  Chr(i3)  Chr(i4)  Chr(i5)  Chr(i6)  Chr(n)
   ActiveWorkbook.Sheets(1).Select
   Range(a1).FormulaR1C1 = Chr(i)  Chr(j)  _
  Chr(k)  Chr(l)  Chr(m)  Chr(i1)  Chr(i2)  _
  Chr(i3)  Chr(i4)  Chr(i5)  Chr(i6)  Chr(n)
   Exit Sub
  End If
  Next: Next: Next: Next: Next: Next
  Next: Next: Next: Next: Next: Next

End Sub








On Tue, Jul 28, 2009 at 8:05 PM, Shiv Pratap s.bhadori...@yahoo.com wrote:

  Hi Harmeet,

 It shows that password remover is expired

 Shiv Pratap

  --
 *From:* Harmeet Singh harmeet.hew...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Tuesday, July 28, 2009 7:47:09 PM
 *Subject:* $$Excel-Macros$$ Re: To Unprotect Sheet

 Use attached Addin



 On Tue, Jul 28, 2009 at 6:37 PM, Shiv Pratap 
 s..bhadori...@gmail.coms.bhadori...@gmail.com
  wrote:

 Hi All,

 I have a excel file, I forget password of a sheet
 please help to unprotect this particolar Chart Sheet.


 Shiv Pratap
 9911761521




 --
 Thanks  Regards,

 Harmeet Singh

 Sent via BlackBerry Wireless


 




-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Password recovery

2009-06-30 Thread Harmeet Singh

send me the file

On Tue, Jun 30, 2009 at 1:45 AM, hanumant shinde haney5...@gmail.comwrote:

 hi guys can somebody pleass tell me how to recover VBA password. i
 tried password recovery tool by microsoft but i have free version which
 gives only 4 char password.so can somebody tell me hw to recover password
 plss

 thanx in advance

 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: BEST EXCEL TIPWEEK # 26Submit your TIP here only

2009-06-23 Thread Harmeet Singh

HI,

Name  - Harmeet
Tip - Calculate formula using F9
Detail :
Lets say you have a formula :
=IF(MONTH(B1)9,YEAR(B1)+1,YEAR(B1))
in order to calculate partial formula you need to select desired formula
like this:
=IF(MONTH(B1)9,YEAR(B1)+1,YEAR(B1))
Then press F9, it will convert the formula to value.
Then press Ctrl+Z to revert the change (If required)

Benefit - For long formulae user can verify the result for subformula of
main formula.

For explanation see attached screenshot.




On Sun, Jun 21, 2009 at 8:49 PM, Ayush jainayus...@gmail.com wrote:


 Dear Members,

 Thanks for your great response in the Week 25 competition. It was
 again great learning for the members of the group.
 Let us begin week # 26 quiz with the more spirit. This is last chance
 for you to be eligible for June month competition.The winner of week #
 25 will be declared soon. Keep watching this Space..

 Last Date of Submission of tips : 28th June 2009.

 PLEASE NOTE THAT THE TIPS SUBMITTED IN THIS POST WILL ONLY BE
 CONSIDERED FOR PRIZES.
 DO NOT START NEW THREADS OR POST FOR SUBMISSION OF TIPS.

 You need to submit your name, Subject  the details of tips and
 tricks.
 DO let me know if you need any clarifications.

 Let me begin by submitting the first tip for this week competition.

 ---
 Name : Ayush Jain
 Subject : Format Painter
 Detail : The little format painter is the most useful button in
 Excel. It looks like a paintbrush and is grouped with the
 cut,copy,paste buttons. Basically highlight a cell with the formating
 that you want, click the button, and then highlight cell(s) that you
 want to just paste the format. HUGE time saver!

 Who is next 
 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

attachment: tip2.png

$$Excel-Macros$$ Re: BEST EXCEL TIPWEEK # 26Submit your TIP here only

2009-06-23 Thread Harmeet Singh

HI,

Name  - Harmeet
Tip - Calculate formula using F9
Detail :
Lets say you have a formula :
=IF(MONTH(B1)9,YEAR(B1)+1,YEAR(B1))
in order to calculate partial formula you need to select desired formula
like this:
=IF(MONTH(B1)9,YEAR(B1)+1,YEAR(B1))
Then press F9, it will convert the formula to value.
Then press Ctrl+Z to revert the change (If required)

Benefit - For long formulae user can verify the result for subformula of
main formula.

For explanation see attached screenshot.

On Tue, Jun 23, 2009 at 10:43 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:

 HI,

 Name  - Harmeet
 Tip - Calculate formula using F9
 Detail :
 Lets say you have a formula :
 =IF(MONTH(B1)9,YEAR(B1)+1,YEAR(B1))
 in order to calculate partial formula you need to select desired formula
 like this:
 =IF(MONTH(B1)9,YEAR(B1)+1,YEAR(B1))
 Then press F9, it will convert the formula to value.
 Then press Ctrl+Z to revert the change (If required)

 Benefit - For long formulae user can verify the result for subformula of
 main formula.

 For explanation see attached screenshot.




 On Sun, Jun 21, 2009 at 8:49 PM, Ayush jainayus...@gmail.com wrote:


 Dear Members,

 Thanks for your great response in the Week 25 competition. It was
 again great learning for the members of the group.
 Let us begin week # 26 quiz with the more spirit. This is last chance
 for you to be eligible for June month competition.The winner of week #
 25 will be declared soon. Keep watching this Space..

 Last Date of Submission of tips : 28th June 2009.

 PLEASE NOTE THAT THE TIPS SUBMITTED IN THIS POST WILL ONLY BE
 CONSIDERED FOR PRIZES.
 DO NOT START NEW THREADS OR POST FOR SUBMISSION OF TIPS.

 You need to submit your name, Subject  the details of tips and
 tricks.
 DO let me know if you need any clarifications.

 Let me begin by submitting the first tip for this week competition.

 ---
 Name : Ayush Jain
 Subject : Format Painter
 Detail : The little format painter is the most useful button in
 Excel. It looks like a paintbrush and is grouped with the
 cut,copy,paste buttons. Basically highlight a cell with the formating
 that you want, click the button, and then highlight cell(s) that you
 want to just paste the format. HUGE time saver!

 Who is next 




 --
 Thanks  Regards,

 Harmeet Singh

 Sent via BlackBerry Wireless

 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

attachment: tip2.png

$$Excel-Macros$$ Re: Concatenate cells and separate values with commas

2009-06-22 Thread Harmeet Singh

Pleas see attached file

On Mon, Jun 22, 2009 at 9:01 PM, Adam Lazzarato adam.lazzar...@gmail.comwrote:


 I have a 1400 row .csv file of emails.

 A1 : abc...@hotmail.com
 B1 : def...@yahoo.com
 C1: ghi...@gmail.com
 etc...

 How would I go about concatenating the emails and separating them with
 commas so I recieve:

 abc...@hotmail.com,def...@yahoo.com,ghi...@gmail.com ETC

 I am a rookie with hardcore excel functions, so thanks in advance for
 your patience.

 Thanks,
 Adam

 



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



dsadsad.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Best Excel Tip Award of Week # 24 goes to HARMEET SINGH

2009-06-17 Thread Harmeet Singh

Hi Ayush,

Thanks a lot
This is the charm of Excel Group that is attracting good talent.
Hope to help you all in future too with my knowledge.

Watch out for more  [?]

Regards,
Harmeet

On Wed, Jun 17, 2009 at 8:18 PM, Ayush jainayus...@gmail.com wrote:

 Hello Everyone,

 I am happy to inform you that the award of best excel Tip of Week # 24
 goes to Harmeet Singh. The tip submitted by Harmeet is as follows :

 Subject : Hidden text in Formula
 Tip : =2018+1056-4*120+N(My Salary + Bonus - 4 weekly loan
 repayments)
 BY using *N() *formula You can enter hidden text in your formula.


 It was very different, useful and unique tip among all the tips by the
 participants. I encourage you all to submit such great tips which will
 help all members in big way and let you win the prize.

 CONGRATULATIONS HARMEET !!
 You are now nominated for monthly award  your name is published on
 home page of this group.

 CHEERS !!!

 The competition of week # 25 is already started  you can submit your
 tip in the thread mentioned below

 http://groups.google.com/group/excel-macros/browse_thread/thread/8f60d8d55837f5c9#

 Please participate and win wonderful prizes.

 KEEP POSTING 

 Thanks and best regards,
 Ayush Jain




-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

inline: 332.gif

$$Excel-Macros$$ Re: Best Excel Tip Award of Week # 24 goes to HARMEET SINGH

2009-06-17 Thread Harmeet Singh

Hey Dave,
You know wat.
u made my day with ur comments
Thnx!!!

On Thu, Jun 18, 2009 at 4:21 AM, Dave Bonallack
davebonall...@hotmail.comwrote:

 Good choice Ayush. I also thought it was very good.
 It's the Worksheet-Function equivalent of putting comments after an
 apostrophe in VBA.
 Regards - Dave.

  Date: Wed, 17 Jun 2009 07:48:06 -0700
  Subject: $$Excel-Macros$$ Best Excel Tip Award of Week # 24 goes to
 HARMEET SINGH
  From: jainayus...@gmail.com
  To: excel-macros@googlegroups.com
  CC: harmeet.hew...@gmail.com
 
 
  Hello Everyone,
 
  I am happy to inform you that the award of best excel Tip of Week # 24
  goes to Harmeet Singh. The tip submitted by Harmeet is as follows :
 
  Subject : Hidden text in Formula
  Tip : =2018+1056-4*120+N(My Salary + Bonus - 4 weekly loan
  repayments)
  BY using *N() *formula You can enter hidden text in your formula.
 
 
  It was very different, useful and unique tip among all the tips by the
  participants. I encourage you all to submit such great tips which will
  help all members in big way and let you win the prize.
 
  CONGRATULATIONS HARMEET !!
  You are now nominated for monthly award  your name is published on
  home page of this group.
 
  CHEERS !!!
 
  The competition of week # 25 is already started  you can submit your
  tip in the thread mentioned below
 
 http://groups.google.com/group/excel-macros/browse_thread/thread/8f60d8d55837f5c9#
 
  Please participate and win wonderful prizes.
 
  KEEP POSTING 
 
  Thanks and best regards,
  Ayush Jain
  



-- 
Thanks  Regards,

Harmeet Singh

Sent via BlackBerry Wireless

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: BEST EXCEL TIP WEEK # 24 Submit TIP and Win PRIZE

2009-06-08 Thread Harmeet Singh

HI All,

Name : Harmeet
Subject : Enter Date
Tip : Press Ctrl+;

Regards,
Harmeet

On Fri, Jun 5, 2009 at 9:11 PM, Ayush jainayus...@gmail.com wrote:


 Hello Everyone,

 Please submit your tip in this post for Week # 24. I am looking for
 your overwhelming response in this competition.You just need to submit
 your name along with the tip and subject. The tip can be shortcut,
 trick, hidden secret, etc.

 Last Submission Date-13th June 2009.
 Winner Declaration Date -14th June 2009.

 Example :

 Name : Ayush Jain
 Subject : the Great 'F4'
 Tip : The 'F4' is easily the most useful shortcut key in Excel.
 Basically it repeats your last command.
 So say you changed the color of a font in a cell. Now click in a new
 cell and hit 'F4' and it will change the font in the new cell to the
 same color.Wonderful, right? Well what's great about this is that it
 works for nearly everything else in Excel too.Highlight a row, right-
 click and choose 'Delete'. Now highlight another row and hit 'F4'. It
 deletes that row.Whatever you did last, Excel will attempt to repeat
 the same command until you do something else. This works great for
 things that require you to go to the menus or right-click and make
 choices or click buttons that bring up more dialogs. It can be huge
 time saver once you get used to using it. As the help says, it doesn't
 work in every situation but most times 'F4' works great.


 SO, WHAT ARE YOU WAITING FOR ? JUST SUBMIT A TIP  WIN PRIZES. Invite
 your friends too for participation in the contest. The more
 participation means more learning.

 Thanks again,
 Ayush Jain
 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: BEST EXCEL TIP WEEK # 24 Submit TIP and Win PRIZE

2009-06-08 Thread Harmeet Singh

HI All,

Name : Harmeet
Subject : Select Active Column
Tip : Press Ctrl+Space bar

Regards,
Harmeet
On Fri, Jun 5, 2009 at 9:11 PM, Ayush jainayus...@gmail.com wrote:


 Hello Everyone,

 Please submit your tip in this post for Week # 24. I am looking for
 your overwhelming response in this competition.You just need to submit
 your name along with the tip and subject. The tip can be shortcut,
 trick, hidden secret, etc.

 Last Submission Date-13th June 2009.
 Winner Declaration Date -14th June 2009.

 Example :

 Name : Ayush Jain
 Subject : the Great 'F4'
 Tip : The 'F4' is easily the most useful shortcut key in Excel.
 Basically it repeats your last command.
 So say you changed the color of a font in a cell. Now click in a new
 cell and hit 'F4' and it will change the font in the new cell to the
 same color.Wonderful, right? Well what's great about this is that it
 works for nearly everything else in Excel too.Highlight a row, right-
 click and choose 'Delete'. Now highlight another row and hit 'F4'. It
 deletes that row.Whatever you did last, Excel will attempt to repeat
 the same command until you do something else. This works great for
 things that require you to go to the menus or right-click and make
 choices or click buttons that bring up more dialogs. It can be huge
 time saver once you get used to using it. As the help says, it doesn't
 work in every situation but most times 'F4' works great.


 SO, WHAT ARE YOU WAITING FOR ? JUST SUBMIT A TIP  WIN PRIZES. Invite
 your friends too for participation in the contest. The more
 participation means more learning.

 Thanks again,
 Ayush Jain
 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: BEST EXCEL TIP WEEK # 24 Submit TIP and Win PRIZE

2009-06-08 Thread Harmeet Singh

HI All,

Name : Harmeet
Subject : Hidden text in Formula
Tip : *=2018+1056-4*120+N(My Salary + Bonus - 4 weekly loan
repayments)
*
BY using *N() *formula You can enter hidden text in your formula.

Try it.

Regards,
Harmeet




On Fri, Jun 5, 2009 at 9:11 PM, Ayush jainayus...@gmail.com wrote:


 Hello Everyone,

 Please submit your tip in this post for Week # 24. I am looking for
 your overwhelming response in this competition.You just need to submit
 your name along with the tip and subject. The tip can be shortcut,
 trick, hidden secret, etc.

 Last Submission Date-13th June 2009.
 Winner Declaration Date -14th June 2009.

 Example :

 Name : Ayush Jain
 Subject : the Great 'F4'
 Tip : The 'F4' is easily the most useful shortcut key in Excel.
 Basically it repeats your last command.
 So say you changed the color of a font in a cell. Now click in a new
 cell and hit 'F4' and it will change the font in the new cell to the
 same color.Wonderful, right? Well what's great about this is that it
 works for nearly everything else in Excel too.Highlight a row, right-
 click and choose 'Delete'. Now highlight another row and hit 'F4'. It
 deletes that row.Whatever you did last, Excel will attempt to repeat
 the same command until you do something else. This works great for
 things that require you to go to the menus or right-click and make
 choices or click buttons that bring up more dialogs. It can be huge
 time saver once you get used to using it. As the help says, it doesn't
 work in every situation but most times 'F4' works great.


 SO, WHAT ARE YOU WAITING FOR ? JUST SUBMIT A TIP  WIN PRIZES. Invite
 your friends too for participation in the contest. The more
 participation means more learning.

 Thanks again,
 Ayush Jain
 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: BEST EXCEL TIP WEEK # 24 Submit TIP and Win PRIZE

2009-06-08 Thread Harmeet Singh

HI All,

Name : Harmeet
Subject : Enter Time
Tip :

CTRL SHIFT :   Enters the time
CTRL SHIFT   Creates an outline box around whatever you select
CTRL SHIFT _  Removes the outline box around whatever has an
outline
CTRL SHIFT *   Highlights all the text surrounding the cell
filled with data or numbers
CTRL SHIFT !   Applies the number format to selected cells
CTRL SHIFT % Applies the percentage format to the selected cells
CTRL SHIFT #  Applies the date format to the selected cells
CTRL SHIFT @ Applies the time format to the selected cells
CTRL SHIFT (   Unhide columns that are selected
CTRL SHIFT )  - Unhide rows that are selected
CTRL K    Insert a hyperlink

Regards,
Harmeet
On Fri, Jun 5, 2009 at 9:11 PM, Ayush jainayus...@gmail.com wrote:


 Hello Everyone,

 Please submit your tip in this post for Week # 24. I am looking for
 your overwhelming response in this competition.You just need to submit
 your name along with the tip and subject. The tip can be shortcut,
 trick, hidden secret, etc.

 Last Submission Date-13th June 2009.
 Winner Declaration Date -14th June 2009.

 Example :

 Name : Ayush Jain
 Subject : the Great 'F4'
 Tip : The 'F4' is easily the most useful shortcut key in Excel.
 Basically it repeats your last command.
 So say you changed the color of a font in a cell. Now click in a new
 cell and hit 'F4' and it will change the font in the new cell to the
 same color.Wonderful, right? Well what's great about this is that it
 works for nearly everything else in Excel too.Highlight a row, right-
 click and choose 'Delete'. Now highlight another row and hit 'F4'. It
 deletes that row.Whatever you did last, Excel will attempt to repeat
 the same command until you do something else. This works great for
 things that require you to go to the menus or right-click and make
 choices or click buttons that bring up more dialogs. It can be huge
 time saver once you get used to using it. As the help says, it doesn't
 work in every situation but most times 'F4' works great.


 SO, WHAT ARE YOU WAITING FOR ? JUST SUBMIT A TIP  WIN PRIZES. Invite
 your friends too for participation in the contest. The more
 participation means more learning.

 Thanks again,
 Ayush Jain
 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: hi

2009-05-27 Thread Harmeet Singh

try below code:

ActiveWorkbook.SaveAs c:\dhartikumar -   Format(Date, dd-mmm-) 
.xls

On Wed, May 27, 2009 at 5:52 PM, Dhartikumar Sahu dhartiku...@gmail.comwrote:

 hi all

 can anybody help me for saving the file with current date. (e.g.
 dhartikumar - 27 May 2009)
 in  macro code.

 Thanks  Regards
 Dhartikumar


 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: VBA code to search for worksheet with matching date

2009-05-19 Thread Harmeet Singh

send the file please

On Tue, May 19, 2009 at 8:14 PM, Doug dsrmccl...@gmail.com wrote:


 Hello,
  I have a workbook with a separate page for each date. The date is
 always in cell B2. On the first page of the workbook I want to enter
 the date into a cell named IDO_Date and click on a button to go to
 the worksheet for that date. Can someone please show me the easiest
 code to assign to the button to do this?

 Thanks.

 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Fwd: VBA help needed

2009-05-18 Thread Harmeet Singh

-- Forwarded message --
From: Nihar Turakhia turakhia.ni...@gmail.com
Date: Mon, May 18, 2009 at 12:47 AM
Subject: VBA help needed
To: harmeet.hew...@gmail.com

 Harmeet,

I've just started learning vba and stuck rightnow with something. Any help
will be greatly appreciated.

I receive  the daily settlement data from external source for different
commodity products in excel

So I  was thinking if I can write a macro which would grab that
settlement data from that cell for each day and put in new row. ( so all the
data would be in one column )

So there will be a settlement data for 4/1/2009 in cell B1

Tomorrow when i open my book, new settlement data for 4/2/2009 in cell
B2

and next day as 4/3/2009 in cell B3

Only thing I would like to avoid is that if I open the workbook twice
in a same day the macro should not populate new cell instead overwrite
the previous cell which has todays date in it.

-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: how to set default userform when open workbook

2009-05-17 Thread Harmeet Singh

See attched screenshot.


On Sun, May 17, 2009 at 7:49 AM, Dhartikumar Sahu dhartiku...@gmail.comwrote:

 hi grroup

  can somebody help me how to set default userform when open file. whithout
 click.


 Thanks
 Dhartikumar

 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

attachment: g.png

$$Excel-Macros$$ Re: Condtional Formatting - Query

2009-05-11 Thread Harmeet Singh

See attached file

On Mon, May 11, 2009 at 8:30 PM, Fabio Lemos flnle...@gmail.com wrote:

 If you have to format a list you should remove the anchor ($) for the
 rows...

 Lets say you want to format based on column A and you have many rows.

 Select the entyre range and set a conditional format using the formula:

 =$A1=Friday

 so, each line will be formated depending of the content of its column A
 cell.

 Regards.

 2009/5/11 Dave Bonallack davebonall...@hotmail.com

 Hi,
 If your 'Given Cell' is A1:

 Select the row you want to format
 In the Conditional Format window, select 'Formula is'
 In the formula thingy, put:
 =$A$1=Friday
 Set the formatting you want.
 Click ok.

 Hope this helps.
 Regards - Dave.

  Date: Sun, 10 May 2009 19:43:56 -0700
  Subject: $$Excel-Macros$$ Condtional Formatting - Query
  From: kishore.maro...@gmail.com
  To: excel-macros@googlegroups.com
 
 
  Hello,
 
  I want to use conditional formatting for the below issue:
 
  eg: If say given cell of a row has value Friday then i want that
  entire row to be in Blue in color.
 
  Is the above function possble using conditiona formatting or mix of
  standard excel features, wihout using macros
 
  Thanks
  balla
 
 




 --
 Fabio L Lemos

 email: flnle...@gmail.com


 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



Book1.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Password

2009-05-11 Thread Harmeet Singh

open attached file and after that open ur file.
press ALT+F8.
run macro PasswordBreaker

Cheers

On Mon, May 11, 2009 at 6:44 PM, Joe Wilson jhwilson1...@gmail.com wrote:

 Hi everyone.  How can I find out the password of a protected sheet?

 I can't actually break it, but I just need to unlock it to fix something
 and then re-protect it.

 Any ideas?

 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



Unprotect sheet.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Nth Row

2009-05-11 Thread Harmeet Singh

   1. Open the file that i have sent u.
   2. Open ur file.
   3. Select data tab.
   4. Press ALT+F8
   5. Run macro HHH
   6. a sheet will be created named Data and desired data will copied into
   it.
   7. First Delete sheet name data whenever u run this macro.
   8.



On Sun, May 10, 2009 at 10:01 PM, pseudonym nicolasmit...@hotmail.comwrote:


 All,

 I need some help. I am on a tight deadline, I have a handful of excel
 spreadsheets with several thousand records in each.

 For each spreadsheet I need to select the row of data that occurs
 every fifty rows, and copy it to a new workbook. So, dataset A; I need
 to copy Row 51, 101, 151, 201 etc.

 Having never needed to use VBA or Macros, I may need quite detailed
 instructions.


 Thanks.

 




 --
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



cos.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Need help

2009-05-09 Thread Harmeet Singh

Addressing the group

On Sat, May 9, 2009 at 11:35 PM, shariq khan shariqcoo...@gmail.com wrote:

 Hi Harmeet,


 Actually I got your ID from macro group and saw some of your macro codes,
 they was really very good.

  I need your help ,

 I want 2 merge the 100 excel files placed in a folder (this module is
 completed). But I need no maintain the accuracy of data, so come across the
 scenario, if all excel sheet having the same column heading(Variables ) but
 in the different Oder. so my macro will merge the wrong data .

  So, I need to rearrange the columns in specify format..But this specify
 format is also dynamic

 For example :- my first excel sheet having columns name like this
 Name Sex Age Location..

 Another excel sheet having same kind of data in different column positions
 Name Age Location Sex ……..
 Now I need to arrange the second sheet by using the macro .as per the
 first sheet….

  So I can merge the files ………by using my “Merge.xls” macro

 waiting for your responses






-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: anybody knows a bit about SQL?

2009-05-06 Thread Harmeet Singh

Use and operator as:

WHERE table.Cal LIKE 2009%
  AND table.Cal = 'Jan1'

I hope that solves the issue.




On Wed, May 6, 2009 at 8:13 PM, Yu vincent2...@gmail.com wrote:


 Hi Dear members,

I need to extract some data from Database. For instance, I have
 such an column in a table. I wanna extract Jan1 ,Feb2 and records
 starting with 2009


   Jan1
   Feb2
   20081001
   20091092
   20091093
  20091094
   20091095

 I know how to extract records starting with 2009.
 here is what I do


   SELECT * FROM table WHERE table.Cal LIKE 2009%  ,but what about
 Jan1 and Feb2?


  thanks!

 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: filling cells with colours

2009-05-06 Thread Harmeet Singh

Instead of vba use conditional formatting, would be better.
if u need help in conditional formatting for ur query then lemme know.

On Wed, May 6, 2009 at 5:04 PM, xxx lavanyaredd...@gmail.com wrote:


 I need help in writing this macro

 if the cell content is empty fill it with Red
 if cell content contains Y then fill it with Yellow
 if no Y and any content then fill it with Green

 thanks...its urgent

 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Part Numbers

2009-04-30 Thread Harmeet Singh

On Fri, May 1, 2009 at 3:50 AM, DittoDan dbovin...@ovonic.com wrote:


 Greetings, I am new to this list. If this question was recently asked,
 please point me to it and forgive me for asking it so soon.

 I want to make an Excel table to do a task. I want a drop down (I know
 how to use Data valadation with a list) where a user will pick a word
 in the drop down, and in another cell, an alpha-numeric part number
 will be the result.

 I have 20 or so part numbers, so a simple IF formula will not work,
 or if I could use it, it would very hard to make them over and over,
 and hard to edit.

 Here is sample:

 Drop down: Result:
 BHSCSAES18
 SHCS AES14
 FHSCSAES16
 HHCS AEB02
 Shoulder Soc. Cap ScrewAES20
 Soc. Cap Set Screw   AES32
 SAE Flat Washer   AEW24
 Std. Lock Washer  AEW07
 HI Collar Lock WasherAEW10
 Hex Nut AEN04
 Hex Jam Nut  AEN05
 DowelAEP05
 Roll Pin AEP23

 Can this be done in Excel without a macro, API, VBA?

 I have been reading the help file for hours.

 Thanks for any help you may give me.

 Dan
 Rochester Hills, Michigan

 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



Book1.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP

2009-04-27 Thread Harmeet Singh

It was a nice query...

See attached file it has the solution...

On Mon, Apr 27, 2009 at 7:01 PM, Fabio Lemos flnle...@gmail.com wrote:

 Hi,
 You can use:

 =IF(C8C7,1,0)

 regards!

 2009/4/27 Mayank Patel mkpat...@gmail.com

 Dear Friends

 Please suggest the formula.
 sample file is attached.

 Thanks to all in Advance



 Regards
 Mayank Patel
 ITC LTD
 9822978041
 9422749110





 --
 Fabio L Lemos

 email: flnle...@gmail.com


 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



OUTLET_DATA(1).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Solver

2009-04-27 Thread Harmeet Singh

I think u need to be more specific.
Sorry, I couldn't get ur query.




On Mon, Apr 27, 2009 at 6:20 PM, H Upadhyay harishcupadh...@gmail.comwrote:

 Dear All,

 Need ur help, pls suggest how can i create code for Solver

 Regards
 Harishh Upadhyay
 9773284902

 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Macro to open Sharepoint documents?

2009-04-27 Thread Harmeet Singh

Hi All,

Using attached tool you can open all the files from a given location.

Warren, u can have reference from it.

Thanks.

On Mon, Apr 27, 2009 at 6:28 PM, Ashish Jain 26may.1...@gmail.com wrote:


 Hi Gremlin,

 You're doing right, except using the Chdir.
 There is No need of it. You may directly use Workbooks.Open ..

 Regards
 Ashish Jain
 www.excelitems.com
 Developer of OpenXL

 

 On Apr 14, 3:50 am, CF_Gremlin warren.oto...@gmail.com wrote:
  I have a status report spreadsheet saved onto my desktop that links to
  15 other excel spreedsheets on a Sharepoint location.
 
  I tried to record the macro and that would open those 15 excel
  spreadsheets from Sharepoint.  However when I attempt to run the macro
  I get a Run-time error '76' Path not found.
 
  Here is what I have so far but it always errors out on the change
  directory command
 
  Sub Macro1()
  '
  ' Macro1 Macro
  '
  '
  ChDir https://projects.company.com/software/Notes;
  Workbooks.Open Filename:= _
  https://projects.company.com/software/Notes/Issues%20Tracking
  %20List.xls
 
  End Sub
 
  Is it possible to write a macro that can open documents that are not
  stored on your desktop, but rather in an information portal site?
 
  Any info or suggestions are appreciated
 
  Regards
 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



Copy of 2003 Janand.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

2009-04-27 Thread Harmeet Singh

Hi Ashish,

I must say, Its a killer tool. Keep up the good work buddy.

U r simply Awesome.

What do u all say.?

On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain 26may.1...@gmail.com wrote:


 If you want to do any or all of the following. Visit
 http://www.excelitems.com
 and Download Open XL.

 1. Run Charts Slideshow
 2. Calculate Business Working Days

 3. Sort Worksheets
 4. Merge Worksheets
 5. Superhide a worksheet

 6. Copy Multiple Selections
 7. Learn VBA/VSTO

 8. Copy Worksheets to MS Word
 9. Invert the Selection

 10. Remove all Empty Rows
 11. Delete Blank Sheets

 and run such 125 utilities from single addin. Open XL is a freeware
 addin.
 Download, Install and Use.

 This is definitely gonna save your lots of hours. Enjoy Excel !

 Regards
 Ashish Jain
 www.excelitems.com
 Developer of Open XL
 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: How to create Folder and documents with help of macro

2009-04-27 Thread Harmeet Singh

To create folder use ---MkDir C:\HHH
To get the file path use --  filepath=application.getopenfilename

On Mon, Apr 27, 2009 at 5:19 PM, Mathan mathan4s...@gmail.com wrote:

 *Hi All,*
 **
 *1. How to create a folder and other documents with macro in desktop.. ?*
 *2. How to get a files as input file through a user form?*
 **
 *pls give me examples.*

 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Index and Offset Formula Help

2009-04-23 Thread Harmeet Singh

See attached file

On Thu, Apr 23, 2009 at 3:38 PM, mathew darryl matt.attitud...@gmail.comwrote:

 hi i need to find the difference between   8:45:28 PM 10:41:00 PMi want it
 to be a logical function like if the difference is more than say one hour is
 want it to get yes or else no




 On Thu, Apr 23, 2009 at 11:44 AM, Suryaprasad.bv suryaprasad...@gmail.com
  wrote:

 where is it attached..?


 On Thu, Apr 23, 2009 at 2:57 AM, Fabio_XL_Master flnle...@gmail.comwrote:


 Hi,

 other possible solution is attached. Using offset and Array formula.


 Fabio





 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



time.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Index and Offset Formula Help

2009-04-23 Thread Harmeet Singh

one more solution is attached

On Thu, Apr 23, 2009 at 7:22 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:

 See attached file


 On Thu, Apr 23, 2009 at 3:38 PM, mathew darryl 
 matt.attitud...@gmail.comwrote:

 hi i need to find the difference between   8:45:28 PM 10:41:00 PMi want
 it to be a logical function like if the difference is more than say one hour
 is want it to get yes or else no




 On Thu, Apr 23, 2009 at 11:44 AM, Suryaprasad.bv suryaprasad.bv@
 gmail.com wrote:

 where is it attached..?


 On Thu, Apr 23, 2009 at 2:57 AM, Fabio_XL_Master flnle...@gmail.comwrote:


 Hi,

 other possible solution is attached. Using offset and Array formula.


 Fabio





 



 --
 Thanks  Regards,

 Harmeet Singh




-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



time.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: making rows into colums

2009-04-23 Thread Harmeet Singh

On Thu, Apr 23, 2009 at 12:09 PM, Sergio Abadesso 
groups.abade...@googlemail.com wrote:

 Hi gabo,

 it is possible to let look like the data of the upper example like yours
 below.

 Take a look in the Excel help by searching for Pivot Table

 Regards,

 Sergio

 2009/4/23 gabo gabo22...@yahoo.com


 I have a spreadsheet where I need to combine some rows into columns.
 Listed below is an example of the spreadsheet.

  Cust Id  Name   Item Qty

  1  Joe  table   1
  1  Joe Chair2
  2  Sam   table1
  3  Steve lamp 1
  3  Steve table 1

 Is there a way to make the above spreadsheet look like the one below
 where it can be used with a Word merge?

 Cust Id  NameTable Chair  Lamp

  1   Joe   1  2
  2   Sam 1
  3   Steve1   1



 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



gabo(1).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Show the start and end of groups of cells

2009-04-21 Thread Harmeet Singh

Solution attached

On Tue, Apr 21, 2009 at 9:26 PM, Geo gco...@gmail.com wrote:


 I have data like this:

 part#   location
 1   1B-1-A-01
 5   1B-1-A-01
 6   1B-1-A-01
 14  1B-1-A-02
 12  1B-1-A-02
 15  1B-1-A-03
 83  1B-1-A-03
 16  1B-1-A-03
 22  1B-1-A-03

 In column C, I would like to see this:

 part#   locationStart/End
 1   1B-1-A-01   start
 5   1B-1-A-01
 6   1B-1-A-01   end
 14  1B-1-A-02   start
 12  1B-1-A-02   end
 15  1B-1-A-03   start
 83  1B-1-A-03
 16  1B-1-A-03
 22  1B-1-A-03   end

 So for each beginning of the location, I need C to say 'start' and at
 the end of this group of data, I'd like it to say 'end'.

 Thanks ofr your help.


 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



Book1.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Any way to divide the cell for ex. by 1000 in its place

2009-04-20 Thread Harmeet Singh

See attached file.



On Sun, Apr 19, 2009 at 10:09 PM, Mayank Patel mkpat...@gmail.com wrote:

 Thanks Ashish
 is there any other way than Macro

 I appreciate ur help.

 Regards
 Mayank Patel
 ITC LTD
 9822978041
 9422749110


   On Sun, Apr 19, 2009 at 9:08 PM, Ashish Jain 26may.1...@gmail.comwrote:


 Hi Mayank,

 Try this VBA code.
 1. Select the cells and run the code below:
 2. Code:
 Sub Divideby1000()
 Dim myCell as Range
 For each myCell in Selection.cells\
 myCell.Value = myCell.value/1000
 Next
 End Sub


 For more tips, tricks, downloads and problem solutions: visit --
 http://www.excelitems.com
 
 Regards
 *Ashish **Jain*
 Analyst, CSC
 Microsoft Certified Application (Excel) Specialist
 Excel and VBA Trainer
 Author - www.excelitems.com
 +91--40-48-43

 -----

 -----

 On Apr 2, 9:22 pm, Mayank Patel mkpat...@gmail.com wrote:
  Hi friends
  can anyone tell is thr any way to divide the cell in place.
  i am having the large scattered data which i want to divide by 1000.
  Please Suggest
 
  Rgds
 
  Mayank
 
 
 
  On Thu, Apr 2, 2009 at 3:04 PM, Aindril De aind...@gmail.com wrote:
   Hi Mahesh
 
  http://office.microsoft.com/en-us/excel/HA102223271033.aspx
 
   The above link will give you the answer.
 
   Regards,
   Andy
 
   On Thu, Apr 2, 2009 at 12:38 AM, mahesh parab mahes...@gmail.com
 wrote:
 
   Dear All
 
   Any knw macro in excel which can speak the cell content. or any user
   define function is there. if any one have
   example sheet please mail it to me.
 
  --
  Regards
  Mayank Patel
  ITC LTD
  9822978041
  9422749110



 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---



ddfs.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: copy paste columns macro

2009-04-20 Thread Harmeet Singh

lastrow = Range(a1).End(xlDown).Row

try this one as well

On Sat, Apr 18, 2009 at 10:37 PM, Tom Jeffries tjeff...@gmail.com wrote:

 Try:
 LastRow = ActiveSheet.Cells.Find(What:=*, SearchDirection:=xlPrevious,
 SearchOrder:=xlByRows).Row

 On Fri, Apr 17, 2009 at 8:01 PM, boney shwet...@gmail.com wrote:


 I have two sheets A and B . I need to copy the columns ( A through an
 unknown number of columns ) from sheet A into sheet B starting from
 Row 52 . Issue I have is

 -- Find the last row of the column (since its variable with each
 column )
 -- A simpler way to do this .

 Here is what I have so far

Dim temp As String
temp = Some file name of sheet A
temp 1 = Some file name of sheet B

   Workbooks.Open fileName:=temp

ThisWorkbook.Activate

i = 1
j = 1

`finding last cell to which I need to select in sheet A
LRow = fileName.Cells(Rows.Count, j).End(xlUp).Row

' While loop to go thru each cell in colum 1 of sheet A and copy
 it to column of sheet B starting from cell (A,52)
Do Until i  6000

 Worksheets(temp1's name).Cells(i + 51, j).Value = temp.Cells(i,
 j).Value

 i = i + 1

Loop




 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: select case error

2009-04-20 Thread Harmeet Singh

try the below code


Sub dsf()
Select Case Crit_Value
  Case Crit_Value = 0
   Cells(25, 1).Value = No Order
   Case Crit_Value  0
   Cells(25, 1).Value = Error Crit_value  0
   Case Crit_Value  Init_Inven
   Cells(25, 1).Value = No order inventory on handCrit value
   Order_Amt = Desire_Inven - Init_Inven
   Cells(30, 1).Value = Number of units to order
   Cells(30, 2).Value = Order_Amt
   Cells(31, 1).Value = Optimal starting inventory
   Cells(31, 2).Value = Desire_Inven
   Cells(32, 1).Value = Critical value for determining if an order shoould
be placed
   Cells(32, 2).Value = Crit_Value
   End Select
End Sub




On Sat, Apr 18, 2009 at 1:33 AM, larry laurence.tha...@navy.mil wrote:


 Any idea why the second case triggers run time error 1004, application
 defined or object defined error. this should be standard cell input.

 Thanks for the help.

 Select Case Crit_Value
   Case Crit_Value = 0
Cells(25, 1).Text = No Order
Case Crit_Value  0
Cells(25, 1).Text = Error Crit_value  0
Case Crit_Value  Init_Inven
Cells(25, 1).Text = No order inventory on handCrit value
Order_Amt = Desire_Inven - Init_Inven
Cells(30, 1).Text = Number of units to order
Cells(30, 2).Value = Order_Amt
Cells(31, 1).Text = Optimal starting inventory
Cells(31, 2).Value = Desire_Inven
Cells(32, 1).Text = Critical value for determining if an order
 shoould be placed
Cells(32, 2).Value = Crit_Value
End Select

 



-- 
Thanks  Regards,

Harmeet Singh

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

1 2 >

1 - 100 of 137 matches

Mail list logo