Re: $$Excel-Macros$$ Pls Help..

[karan 1237]

*Thnx..

*
ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı



On Thu, Feb 24, 2011 at 10:15 AM, Rohan Young  wrote:

>
>
> To post to this group, send email to excel-macros@googlegroups.com
>
>
>
>
> 2011/2/23 кαяαηη yα∂αν 
>
>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Pls Help...

[karan 1237]

*Hi.. Experts & Excel guru

I need ur help.. pls help me..


Thnx
Karan



*
ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı

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


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


Saupin's_SuggestedCareer_List().xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Please Help

[karan 1237]

  *
LIST1* *LIST1* *LIST1* *RESULT*  BACK SIDE FRONT BACK, SIDE, FRONT  FRONT
SIDE FRONT FRONT, SIDE  BACK FRONT BACK BACK, FRONT  FRONT FRONT FRONT FRONT
*Hi Experts,

I want like this. Please help.

Thnx in Advance.


*
ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı

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


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

Re: $$Excel-Macros$$ Please Help

[karan 1237]

*Thank you so much. I am very grateful to you.

*
ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı



On Sun, May 8, 2011 at 6:59 AM, STDEV(i)  wrote:

>
> try to use this UDF (user defined function)
> Function UniqueList(Dat As Range)
>' List of UnSorted Unique Values  '
>'-'
>Dim Cel As Range, vArr(), n As Long, Tx As String
>Tx = ", "
>For Each Cel In Dat
>   If InStr(1, Tx, ", " & Cel & ", ") = 0 Then
>  Tx = Tx & Cel & ", "
>   End If
>Next Cel
>If Len(Tx) > 0 Then Tx = Left(Tx, Len(Tx) - 2)
>If Len(Tx) > 0 Then Tx = Right(Tx, Len(Tx) - 2)
>UniqueList = Tx
> End Function
>
>
>
> On Sat, May 7, 2011 at 3:50 PM, karan 1237  wrote:
>
>>   *
>> LIST1* *LIST1* *LIST1* *RESULT*  BACK SIDE FRONT BACK, SIDE, FRONT  FRONT
>> SIDE FRONT FRONT, SIDE  BACK FRONT BACK BACK, FRONT  FRONT FRONT FRONT
>> FRONT
>> *Hi Experts,
>>
>> I want like this. Please help.
>>
>> Thnx in Advance.
>>
>>
>> *
>> ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Please help to make my project good.

[karan 1237]

Respected Sirs/Mam,

I need your help making my project good.  Please find attachment. I will be
very obliged if someone can help me as earlier as possible.

--
Basically I have to do that when I click on drop down list & select another
career i.e. Building and Construction so In sub career list data should
comes from the Building and construction's sheet and If I select another
career i.e. Catering and Hospitality so data should comes from its list
(Catering and Hospitality) and scroll bar should work with the same. I have
16 careers so please tell me how can I do this.


Thnx in Advance

ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı

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


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

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

[karan 1237]

Thnx for this vishal but I dnt wnt to prtect sheet as you think I want to
protect sheet in different way. I hope you'v seen that excel file which I'v
attached. I made a combo box  & I want to protect it like : I chose a name
from combobox like Dharmendra mishra & now I want that when I choose name it
ask for a password (in input box) for each each person. Each person should
have their own password (which I want to create). For this my main purpose
is that no one can see other's leaves. If he has password so he can see
otherwise nopes. That's it.. If you can do this so please help me

*---
кαяαηη*



On Wed, Jun 1, 2011 at 8:05 PM, Vishal Gupta wrote:

> *Dear кαяαηη,*
> *Greetings for the day!!!*
> *to protect your sheet or workbook go to review pane in office 2007, then
> protect sheet, then limit of protection. by doing this u can protect ur
> project with a password.*
>
> **
> Regards
> Vishal Gupta
>
>
>
> On Wed, Jun 1, 2011 at 3:58 PM, karan 1237  wrote:
>
>>
>> Hello Expert
>>
>> I need your help to to create conditions & password protection in my
>> project. I'v attached the file & my problems in attached file. Pls see &
>> Help.
>>
>>
>> Thnx in advance
>> *
>> кαяαηη*
>>
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

[karan 1237]

Thnx a lot Rajan but I want one more thing that is it possible to make input
box character like dis *. If it is possible so please help.


Thnx
*---
кαяαηη*



On Thu, Jun 2, 2011 at 11:59 AM, Rajan_Verma wrote:

>  HI Karan
>
> See it help
>
>
>
> Rajan
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Vishal Gupta
> *Sent:* Wednesday, June 01, 2011 8:05 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !!!
>
>
>
> *Dear кαяαηη,*
>
> *Greetings for the day!!!*
>
> *to protect your sheet or workbook go to review pane in office 2007, then
> protect sheet, then limit of protection. by doing this u can protect ur
> project with a password.*
>
>
>
> Regards
>
> Vishal Gupta
>
>
>
>   On Wed, Jun 1, 2011 at 3:58 PM, karan 1237  wrote:
>
>
>
> Hello Expert
>
>
> I need your help to to create conditions & password protection in my
> project. I'v attached the file & my problems in attached file. Pls see &
> Help.
>
>
> Thnx in advance
>
> *
> кαяαηη*
>
>
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

[karan 1237]

Thnx a lot Rajan. You are most helpful persongreat... :)


*---
кαяαηη*



On Thu, Jun 2, 2011 at 5:37 PM, Rajan_Verma wrote:

>  Hi Karan,
>
> I think it has been Complete Now….
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *karan 1237
> *Sent:* Thursday, June 02, 2011 4:21 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !!!
>
>
>
> Thnx a lot Rajan but I want one more thing that is it possible to make
> input box character like dis *. If it is possible so please help.
>
>
> Thnx
>
> *---
> кαяαηη*
>
>
>
>  On Thu, Jun 2, 2011 at 11:59 AM, Rajan_Verma 
> wrote:
>
> HI Karan
>
> See it help
>
>
>
> Rajan
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Vishal Gupta
> *Sent:* Wednesday, June 01, 2011 8:05 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !!!
>
>
>
> *Dear кαяαηη,*
>
> *Greetings for the day!!!*
>
> *to protect your sheet or workbook go to review pane in office 2007, then
> protect sheet, then limit of protection. by doing this u can protect ur
> project with a password.*
>
>
>
> Regards
>
> Vishal Gupta
>
>
>
> On Wed, Jun 1, 2011 at 3:58 PM, karan 1237  wrote:
>
>
>
> Hello Expert
>
>
> I need your help to to create conditions & password protection in my
> project. I'v attached the file & my problems in attached file. Pls see &
> Help.
>
>
> Thnx in advance
>
> *
> кαяαηη*
>
>
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
> --
>
> --
> 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 po

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

[karan 1237]

Sorry dear but I'm unable to understand. Can you please explain it?


Thnx
*---
кαяαηη*



On Fri, Jun 3, 2011 at 12:25 AM, abdelrahman noaman <
abdelrahman.go...@gmail.com> wrote:

> Hi All It is very esey just go to excel option and disabl the macro and
> check dont trust all vba cod and passwrod request will not work than sheet
> will open and go to refrance pswlist and you will show all pass and than go
> to vba auditor and show code and user form
> thx and best wishes
> gomaa.
>
>
> On 2 June 2011 14:24, karan 1237  wrote:
>
>> Thnx a lot Rajan. You are most helpful persongreat... :)
>>
>>
>> *---
>> кαяαηη*
>>
>>
>>
>> On Thu, Jun 2, 2011 at 5:37 PM, Rajan_Verma wrote:
>>
>>>  Hi Karan,
>>>
>>> I think it has been Complete Now….
>>>
>>>
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *karan 1237
>>> *Sent:* Thursday, June 02, 2011 4:21 PM
>>>
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !!!
>>>
>>>
>>>
>>> Thnx a lot Rajan but I want one more thing that is it possible to make
>>> input box character like dis *. If it is possible so please help.
>>>
>>>
>>> Thnx
>>>
>>> *---
>>> кαяαηη*
>>>
>>>
>>>
>>>  On Thu, Jun 2, 2011 at 11:59 AM, Rajan_Verma 
>>> wrote:
>>>
>>> HI Karan
>>>
>>> See it help
>>>
>>>
>>>
>>> Rajan
>>>
>>>
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *Vishal Gupta
>>> *Sent:* Wednesday, June 01, 2011 8:05 PM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !!!
>>>
>>>
>>>
>>> *Dear кαяαηη,*
>>>
>>> *Greetings for the day!!!*
>>>
>>> *to protect your sheet or workbook go to review pane in office 2007,
>>> then protect sheet, then limit of protection. by doing this u can protect ur
>>> project with a password.*
>>>
>>>
>>>
>>> Regards
>>>
>>> Vishal Gupta
>>>
>>>
>>>
>>> On Wed, Jun 1, 2011 at 3:58 PM, karan 1237  wrote:
>>>
>>>
>>>
>>> Hello Expert
>>>
>>>
>>> I need your help to to create conditions & password protection in my
>>> project. I'v attached the file & my problems in attached file. Pls see &
>>> Help.
>>>
>>>
>>> Thnx in advance
>>>
>>> *
>>> кαяαηη*
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>>
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><>

$$Excel-Macros$$ Automatically Hyperlink

[karan 1237]

Hello Experts,

I need your assistance. I'v a workbook which has 4 sheet. I want to create a
automatically hyperlink (through formulae) when I change content of cell a2,
hyperlink automatically should change...Please help me.

Thnx

*---
кαяαηη*

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


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

Re: $$Excel-Macros$$ Automatically Hyperlink

[karan 1237]

Thnx again to all of you for solving my problem. You all are great!


*---
кαяαηη*



On Tue, Jun 7, 2011 at 4:39 PM, mohd saber  wrote:

> Hi Karan,
>
> please find attached file with the result.
>
> i have included one formula in the same sheet for your reference.
>
> thanks,
> saber
>
> On Tue, Jun 7, 2011 at 1:40 PM, karan 1237  wrote:
>
>> Hello Experts,
>>
>> I need your assistance. I'v a workbook which has 4 sheet. I want to create
>> a automatically hyperlink (through formulae) when I change content of cell
>> a2, hyperlink automatically should change...Please help me.
>>
>> Thnx
>>
>> *---H
>> кαяαηη*
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Congratulations Ashish Koul....!!!

[karan 1237]

First of all Congratulations Ashish Sir Ji for MVP Award. I already knew
that you'll definitely got this award. Thnx for your co operation & helps.
You solved our problems very well & gave us good knowledge of excel. I got
inspiration from you.

Last but not least I thank to Ayush Sir who has created this group.


Thnx

Karan Singh
karanxel.blogspot.com

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

[karan 1237]

It's great...!!!
*---
кαяαηη*



On Wed, Jul 6, 2011 at 3:49 PM, NOORAIN ANSARI wrote:

> Dear Jai,
>
> Please try it without helping column..
>
> =VLOOKUP(B7&"*",Sheet1!B7:C12,2,)
>
>
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*
>
>
> On Wed, Jul 6, 2011 at 2:19 PM, Jai  wrote:
>
>> --
>>
>> --
>>
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Need a book

[karan 1237]

Hi Group Users,

I need your help, I need a book of excel *"101 secrets of a microsoft excel
addict".* I you have full version of this book please send me.

Thnx
Karan

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Need a book

[karan 1237]

Hi Group Users,

I need your help, I need a book of excel *"101 secrets of a microsoft excel
addict".* If you have full version of this book please send me.

Thnx
Karan

-- 
--
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$$ Need a book

[karan 1237]

Thnx for replying yar but it's not full version. Please send another link
*---
кαяαηη*



On Tue, Jul 12, 2011 at 4:53 PM, Rajan_Verma wrote:

>  http://www.exceltip.com/download/F1eBookSample.pdf**
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *karan 1237
> *Sent:* Tuesday, July 12, 2011 2:32 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Need a book
>
> ** **
>
> ** **
>
> Hi Group Users,
>
>
> I need your help, I need a book of excel *"101 secrets of a microsoft
> excel addict".* If you have full version of this book please send me.
>
> Thnx
> Karan
>
>  ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Numbering

[karan 1237]

Hey ankur,

I want to ask something

Sub test()
Sheet1.Range("A2:A15").Clear
Dim i, j As Long
Range("a1").Value = InputBox("put your value")
For i = 1 To Sheets(1).Cells(1, 1).Value
Cells(i + 1, 1).Value = i

Next i
End Sub

In this code what is "i" & "j" ?

*

Kαяαη*



On Mon, Jul 11, 2011 at 1:37 PM, ankur  wrote:

> *hi kalyan
> as per ur requirementfind the solution...tell me if it helps u ..
>
> *Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
>
> On Mon, Jul 11, 2011 at 9:49 AM, santosh bahuguna <
> santoshbahug...@gmail.com> wrote:
>
>>
>> Please find the attached file and let me know if is this you are looking
>> for
>>
>>
>> Regards
>> Santosh Bahuguna
>>
>> On Sat, Jul 9, 2011 at 1:42 PM, karunanithi ramaswamy 
>> wrote:
>>
>>> Mr Santhosh,
>>>   your formula put 1 in A2,1 IN A3,2 IN A4,AGAIN 1 IN A5,3 IN A6.
>>>  i.e., REQUIRED NUMBERING  FILLED IN EVEN CELLS, AND ODD CELLS HAVE 1
>>> AM I RIGHT?
>>> R.KARUNANITHI
>>>
>>> --- On *Sat, 7/9/11, santosh bahuguna *wrote:
>>>
>>>
>>> From: santosh bahuguna 
>>>
>>> Subject: Re: $$Excel-Macros$$ Numbering
>>> To: excel-macros@googlegroups.com
>>> Date: Saturday, July 9, 2011, 3:59 AM
>>>
>>>
>>> Use Simple formula
>>>
>>> =COUNTIF(A$1:A1,A1)
>>>
>>>
>>> Please let me know if you looking for this only
>>>
>>>
>>> Regards
>>> Santosh Bahuguna
>>>
>>>
>>>
>>> On Fri, Jul 8, 2011 at 8:33 AM, Rajan_Verma 
>>> http://mc/compose?to=rajanverma1...@gmail.com>
>>> > wrote:
>>>
>>>  *Hi
>>> Try this*
>>>
>>> * *
>>>
>>> *Private Sub Worksheet_Change(ByVal Target As Range)*
>>>
>>> *On Error GoTo Err:*
>>>
>>> *If Target = Range("A1") Then*
>>>
>>> *For i = 1 To Range("A1").Value*
>>>
>>> *Range("A" & i + 1).Value = i*
>>>
>>> *Next*
>>>
>>> *End If*
>>>
>>> *Err:*
>>>
>>> *End Sub*
>>>
>>> * *
>>>
>>> *From:* 
>>> excel-macros@googlegroups.com[mailto:
>>> excel-macros@googlegroups.com]
>>> *On Behalf Of *NOORAIN ANSARI
>>> *Sent:* Friday, July 08, 2011 5:38 PM
>>> *To:* 
>>> excel-macros@googlegroups.com
>>> *Cc:* Kal xcel
>>> *Subject:* Re: $$Excel-Macros$$ Numbering
>>>
>>> ** **
>>>
>>> kalyan babu.
>>>
>>> Please try it..also
>>>
>>>  
>>>
>>> =IF(A2="","",COUNTA($A$2:A2))
>>>
>>> On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel 
>>> http://mc/compose?to=kalx...@gmail.com>>
>>> wrote:
>>>
>>> Dear Experts,
>>>
>>>  
>>>
>>> I want the formula for below mention query...
>>>
>>>  
>>>
>>> user will put 100 in A1, from A2 autometically numbering will start like
>>> this
>>>
>>>  
>>>
>>> A21
>>>
>>> A32
>>>
>>> A43
>>>
>>> .
>>>
>>> .
>>>
>>> .
>>>
>>> .
>>>
>>>  
>>>
>>> till 100
>>>
>>>  
>>>
>>> What will be the formula??
>>>
>>>  
>>>
>>> Please help
>>>
>>>  
>>>
>>> Thanks in advance
>>>
>>>  
>>>
>>> Kalyan Chatterjee
>>>
>>>  
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to 
>>> excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>>
>>>
>>>
>>> -- 
>>>
>>> Thanks & regards,
>>>
>>> Noorain Ansari
>>>
>>> *http://noorain-ansari.blogspot.com/*
>>> 
>>>
>>> ** **
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to 
>>> excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>> --
>>>
>>> --
>

$$Excel-Macros$$ Need a Macro

[karan 1237]

Hello Friends,

I need your help to make macro. I need a macro which work like format
painter for different format not only one format.
*
---
Kαяαη*

-- 
--
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$$ Need a Macro

[karan 1237]

It's working...Thank you so much...

*
Kαяαη*



On Fri, Jul 15, 2011 at 12:33 PM, NOORAIN ANSARI
wrote:

>
> http://www.excelforum.com/excel-programming/353482-macro-to-create-format-painter.html
>
>
> On Fri, Jul 15, 2011 at 12:29 PM, karan 1237  wrote:
>
>> Hello Friends,
>>
>> I need your help to make macro. I need a macro which work like format
>> painter for different format not only one format.
>>  *
>> ---
>> Kαяαη*
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Merge Vertically

[karan 1237]

Hello Friends,

Once again I need your help. There is option for merge across in excel but
is there any macro to merge vertically. It will merge selected range in
vertically.


Thnx
Karan

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


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

Re: $$Excel-Macros$$ Merge Vertically

[karan 1237]

 *
Hey friend,

I facing this problem. I want to merge all columns in one time.

Kαяαη*



On Fri, Jul 15, 2011 at 2:56 PM, NOORAIN ANSARI wrote:

> Dear Karan,
>
> Please try it
>
> Sub mergecell()
> With Selection
> .HorizontalAlignment = xlGeneral
> .MergeCells = True
> End With
> End Sub
>
> On Fri, Jul 15, 2011 at 12:56 PM, karan 1237  wrote:
>
>> Hello Friends,
>>
>> Once again I need your help. There is option for merge across in excel but
>> is there any macro to merge vertically. It will merge selected range in
>> vertically.
>>
>>
>> Thnx
>> Karan
>>
>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Difference between Array formula and Normal Formula...

[karan 1237]

Hello friends,

Please find attachment of array & simple formulae.


Thnx
Karan
www.karanxel.blogspot.com


*

Kαяαη*



On Tue, Jul 26, 2011 at 12:27 PM, Venkat CV  wrote:

> Dear All,
>
> any one Explain Difference between Array formula and Normal Formula...
>
> With Examples..&Use of Array formulas ...
>
> *Best Regards,*
> *Venkat*
> *Chennai*
> *
> *
> *
> *
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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


Array & Simple Formulae.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

[karan 1237]

I knewcongrats Rajan..!!!

You are great...!!!


~~~
Karan
www.karanxel.blogspot.com
**



On Thu, Aug 4, 2011 at 9:50 AM, Dilip Pandey  wrote:

> Congratulations Rajan...!!
>
> Regards,
> DILIPandey
>
> On 8/3/11, Ayush Jain  wrote:
> >>
> >>   Hello Everyone,
> >>>
> >>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> >>> July'11
> >>> He has posted 170 posts in July 2011 and helped many people through his
> >>> expertise. He has been consistent contributor to this excel forum and
> but
> >>> achived this recognition for the first time.
> >>>
> >>He has also created a record of highest number of posts by any
> > individual in a month.
> >
> >>
> >>>
> >>Thanks to Ashish, Dilip, Venkat, Sunny(XLS S), Noorain, and other
> folks
> >> for helping excel enthusiasts !! keep it up !!
> >>
> >
> >   We as a group made a record of 1350+ posts in a month. Thanks
> > everyone...Thats really awesome. :)
> >
> >>
> >>Keep posting.
> >>
> >>
> >>>  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
> >
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>   MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Transpose Data from cell to columns

[karan 1237]

Dear All,

I'v to transpose data from a cell to columns. Please solve my query.


Thnx in advance
Kaяan

 

 
 

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


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

Re: $$Excel-Macros$$ Transpose Data from cell to columns

[karan 1237]

Dear Noorain thanks for replying, but still my query has not solved. I want
to transpose data from cell to columns, I don't want to do Text to columns.
Please see attached file.


Kaяan

<http://www.facebook.com/singhkarann> <http://twitter.com/#%21/karan1237>
<https://plus.google.com/43524614789164919/posts>
<http://www.myspace.com/singhkaran> <http://www.linkedin.com/in/singhkarann>
<http://karanxel.blogspot.com/> <http://karanxel.wordpress.com/>




On Tue, Sep 13, 2011 at 4:14 PM, NOORAIN ANSARI wrote:

> **Dear Karan,
>
> Please see attached Sheet
> **
> **
> *Sub cell_Transpose()
> Dim i, j, z, x, d As Long
> Dim k As Boolean
> Dim st As Long
> Dim abc, xyz As String
> On Error GoTo errh
> Range("A65356").Select
> Selection.End(xlUp).Select
> z = ActiveCell.Row
> For x = 1 To z
> d = 1
> st = 2
> Range("a" & x).Select
> abc = ActiveCell.Value
> For i = st To Len(abc)
> If i > Len(abc) Then
> Range("a" & x).Offset(0, d).Value = abc
> Exit For
> End If
> If Asc(Mid(abc, i, 1)) > 64 And Asc(Mid(abc, i, 1)) < 91 Then
> Range("a" & x).Offset(0, d).Value = Left(abc, i - 1)
> xyz = Right(abc, Len(abc) - i + 1)
> abc = xyz
> i = 1
> d = d + 1
> End If
> Next i
> If Len(Range("a" & x).Value) = Len(abc) Then
> Range("a" & x).Offset(0, 1).Value = Range("a" & x).Value
> End If
> Next x
> errh:
>  Exit Sub
> End Sub
>
> *
> On Tue, Sep 13, 2011 at 2:35 PM, karan 1237  wrote:
>
>> Dear All,
>>
>> I'v to transpose data from a cell to columns. Please solve my query.
>>
>>
>> Thnx in advance
>>  Kaяan
>>
>> <http://www.facebook.com/singhkarann> <http://twitter.com/#%21/karan1237>
>> <https://plus.google.com/43524614789164919/posts>
>> <http://www.myspace.com/singhkaran>
>> <http://www.linkedin.com/in/singhkarann> <http://karanxel.blogspot.com/>
>> <http://karanxel.wordpress.com/>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


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

Re: $$Excel-Macros$$ Transpose Data from cell to columns

[karan 1237]

Thnx to all for this great help..!


Kaяan

<http://www.facebook.com/singhkarann> <http://twitter.com/#%21/karan1237>
<https://plus.google.com/43524614789164919/posts>
<http://www.myspace.com/singhkaran> <http://www.linkedin.com/in/singhkarann>
<http://karanxel.blogspot.com/> <http://karanxel.wordpress.com/>




On Tue, Sep 13, 2011 at 9:08 PM, NOORAIN ANSARI wrote:

> Dear karan,
>
> By Excel
> Use formula *=SUBSTITUTE(A1,CHAR(10),"-") * in second Column, and Copy and
> Paste it as value, then normal you can use Text to column
>  .
>
>
> On Tue, Sep 13, 2011 at 5:02 PM, karan 1237  wrote:
>
>> Dear Noorain thanks for replying, but still my query has not solved. I
>> want to transpose data from cell to columns, I don't want to do Text to
>> columns. Please see attached file.
>>
>>
>> Kaяan
>>
>> <http://www.facebook.com/singhkarann> <http://twitter.com/#%21/karan1237>
>> <https://plus.google.com/43524614789164919/posts>
>> <http://www.myspace.com/singhkaran>
>> <http://www.linkedin.com/in/singhkarann> <http://karanxel.blogspot.com/>
>> <http://karanxel.wordpress.com/>
>>
>>
>>
>>
>> On Tue, Sep 13, 2011 at 4:14 PM, NOORAIN ANSARI > > wrote:
>>
>>> **Dear Karan,
>>>
>>> Please see attached Sheet
>>> **
>>> **
>>> *Sub cell_Transpose()
>>> Dim i, j, z, x, d As Long
>>> Dim k As Boolean
>>> Dim st As Long
>>> Dim abc, xyz As String
>>> On Error GoTo errh
>>> Range("A65356").Select
>>> Selection.End(xlUp).Select
>>> z = ActiveCell.Row
>>> For x = 1 To z
>>> d = 1
>>> st = 2
>>> Range("a" & x).Select
>>> abc = ActiveCell.Value
>>> For i = st To Len(abc)
>>> If i > Len(abc) Then
>>> Range("a" & x).Offset(0, d).Value = abc
>>> Exit For
>>> End If
>>> If Asc(Mid(abc, i, 1)) > 64 And Asc(Mid(abc, i, 1)) < 91 Then
>>> Range("a" & x).Offset(0, d).Value = Left(abc, i - 1)
>>> xyz = Right(abc, Len(abc) - i + 1)
>>> abc = xyz
>>> i = 1
>>> d = d + 1
>>> End If
>>> Next i
>>> If Len(Range("a" & x).Value) = Len(abc) Then
>>> Range("a" & x).Offset(0, 1).Value = Range("a" & x).Value
>>> End If
>>> Next x
>>> errh:
>>>  Exit Sub
>>> End Sub
>>>
>>> *
>>>   On Tue, Sep 13, 2011 at 2:35 PM, karan 1237 wrote:
>>>
>>>> Dear All,
>>>>
>>>> I'v to transpose data from a cell to columns. Please solve my query.
>>>>
>>>>
>>>> Thnx in advance
>>>>  Kaяan
>>>>
>>>> <http://www.facebook.com/singhkarann>
>>>> <http://twitter.com/#%21/karan1237>
>>>> <https://plus.google.com/43524614789164919/posts>
>>>> <http://www.myspace.com/singhkaran>
>>>> <http://www.linkedin.com/in/singhkarann>
>>>> <http://karanxel.blogspot.com/> <http://karanxel.wordpress.com/>
>>>>
>>>>
>>>> --
>>>>
>>>> --
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>>  
>>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>

$$Excel-Macros$$ Extract (%) Numbers from the text

[karan 1237]

Hello All,

Hope you all are doing well. I'm here as usual, need your assistance. I'v
text data which have percentage numbers (50% or 60%), I need to extract
minimum percentage number. Kindly help me to sort out this problem.

Text is : minimum qualification pcm with 50% or MCA 60%
Result should be : 50%

I've attached the file, Please find enclosed.


Thanks
Karan Singh

 

 
 

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


Extract Percentage Number.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Extract 6 & 7 Digit Number

[karan 1237]

Dear All,

Hope you all are doing well !

I need your assistance to sort out my problem. I need to extract 6 & 7 Digit
number from the string.

Example :

I. C, Rajendra Palace, New Delhi 110053
II. C, 301 Rajendra Palace, 110053 New Delhi
III. C, Rajendra Palace, 110 053 New Delhi

*Result : *

I. 110053
II. 110053
III. 110 053


Kindly help.


Kaяan

 

 
 

-- 
--
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$$ Working out of Statistics on Exam Results URGENT solution needed!

[karan 1237]

Hey Shane,

If your workbook size is more than 10 MB, you can compressed its size
through this :

Save as or press F12
>From "Save as type" drop down & save your file in Excel Binary Format.

Just try this.


Kaяan

 

 
 




On Tue, Oct 4, 2011 at 1:07 AM, shaneallen  wrote:

> morning

-- 
--
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$$ Prefix "0" before the number- Help

[karan 1237]

Hey Waheeb,

Pls find enclosed.


Kaяan

 

 
 




On Tue, Oct 11, 2011 at 1:14 PM,  wrote:

> Hi group,
>
> I have numeric data in column, each cell contains 5 to 6 numeric values but
> are less 7 characters.
> For example: 12345,
> 385469.
>
> What I want is, what ever is the count it should round upto 7 characters.
>
> Exampl 1): 12345.
> Result: 0012345.
>
> Ex; 2) 384569
> Result: 0384569
>
> "0" should be prefixed here...
>
> Thanks in advance,
>
> Regards,
> waheed
>
> --
>
> --
> 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


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

Re: $$Excel-Macros$$ Shortcut key for Border

[karan 1237]

Hey Ankit,

Please see below image :
For all border press Alt+H+B+A
For outline border Ctrl+Shift+&
& for all border commands
press Alt+H+B+ then press character which is showing in the image below:


[image: Picture1.jpg]

Kaяan


 

 
 




On Thu, Oct 13, 2011 at 10:25 AM, Ankit Agrawal
wrote:

> out

-- 
--
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$$ can we change hard copy in excel

[karan 1237]

Yes you can convert your image files in excel through online or download a
software from the website below :

http://www.onlineocr.net/
http://www.cometdocs.com/
http://www.coolutils.com/Online-Excel-Converter.php
http://document.online-convert.com/convert-to-pdf
http://www.pdfconverter.com/
http://www.freepdfconvert.com/
http://www.simpleocr.com/OCR_Software/Convert_Image/convert_image_to_Excel.asp


Through these sites you convert your image files in excel format but I'll
suggest you try this software Abby Fine Reader 10 Professional Edition.
Download it from the website, because it can convert your images files in
one time.



Kaяan

 

 
 




On Thu, Oct 13, 2011 at 3:49 PM, Sam Mathai Chacko wrote:

> Hi Anil,
>
> Could you please explain a little more. Not sure what your query is.
>
> Sam
>
>
> On Thu, Oct 13, 2011 at 3:15 PM, anil kumar  wrote:
>
>> Hi frineds,
>>
>>
>>  can we change a hard copy of data in excel by scanner.
>>
>>
>> Regards & Thanks
>>
>> Anil
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
>
> --
> 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$$ queary about a jpg file into excel or pdf file

[karan 1237]

Hey Anil,
Please find enclosed.



Kaяan

 

 
 




On Tue, Oct 18, 2011 at 5:28 PM, anil kumar  wrote:

> Dear all,
>
>  I want to know that can we change a jpg file into excel or pdf for editing
> according self. I have attached a file for exaple.
>
>
> Thanks & Regards
>
> Anil
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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


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

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

[karan 1237]

Hey Anil,

Convert your image files in excel through online or download a software from
the website below :

http://www.onlineocr.net/


http://www.cometdocs.com/


http://www.coolutils.com/Online-Excel-Converter.php


http://document.online-convert.com/convert-to-pdf


http://www.pdfconverter.com/


http://www.freepdfconvert.com/


http://www.simpleocr.com/OCR_Software/Convert_Image/convert_image_to_Excel.asp




Through these sites you can convert your image files in excel format but
I'll suggest you try this software *Abby Fine Reader 10 Professional Edition
*. Download it from the website, because it can convert your images files in
one time.


Kaяan

 

 
 




On Tue, Oct 18, 2011 at 6:01 PM, anil kumar  wrote:

> but

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Extract (Text & Numbers)

[karan 1237]

Dear All,

Hope you all are doing well..!
I need your assistance to sort out my problem. I need to extract Pincode,
Principal Name, Establishment. I'v attached the sheet. Kindly help.

Thanks
Kaяan

 

 
 

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


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

Re: $$Excel-Macros$$ Extract (Text & Numbers)

[karan 1237]

Dear all,

Help me in this..!


Kaяan

<http://www.facebook.com/singhkarann> <http://twitter.com/#%21/karan1237>
<https://plus.google.com/43524614789164919/posts>
<http://www.myspace.com/singhkaran> <http://www.linkedin.com/in/singhkarann>
<http://karanxel.blogspot.com/> <http://karanxel.wordpress.com/>




On Thu, Oct 20, 2011 at 9:57 AM, karan 1237  wrote:

> Dear All,
>
> Hope you all are doing well..!
> I need your assistance to sort out my problem. I need to extract Pincode,
> Principal Name, Establishment. I'v attached the sheet. Kindly help.
>
> Thanks
> Kaяan
>
> <http://www.facebook.com/singhkarann> <http://twitter.com/#%21/karan1237>
> <https://plus.google.com/43524614789164919/posts>
> <http://www.myspace.com/singhkaran>
> <http://www.linkedin.com/in/singhkarann> <http://karanxel.blogspot.com/>
> <http://karanxel.wordpress.com/>
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Extract (Text & Numbers)

[karan 1237]

Thanks a lot neil but there is a query (Pincode) which has not solved yet.
I've to extract Pin Code from the text as I'v written on mail & worksheet.
Kindly help me in this.

Thanks
Kaяan

 

 
 




On Thu, Oct 20, 2011 at 3:54 PM, neil johnson wrote:

> nd t

-- 
--
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$$ FW: Village

[karan 1237]

Amazing..!!


Kaяan

 

 
 




On Tue, Nov 1, 2011 at 12:16 PM, sudhir kumar
wrote:

>  ** **
>
> ** **
>
> *From:* Sukhvir Verma [mailto:sve...@eigen-tech.com]
> *Sent:* Tuesday, October 25, 2011 11:51 AM
> *To:* sudhir.ku...@lazerindia.com
> *Subject:* Village
> *Importance:* Low
>
> ** **
>
>
> *Either  the person who did this is an Excel freak or he  just did not
> know
> what to do with his time  all day, but his art work is worth  looking
>
> To  see his work of art, please do the  following:
>
> 1.  Open the attachment  Village.xls
>
> 2.  Select all cells (or press  CTRL+A)
>
> 3.  Go to format, and set the row height as  15.33
>
> 4.  Go to format, and set the column width as  2.4
>
> I  DON'T THINK EVEN THE PERSON  WHO PROGRAMMED EXCEL COULD DO THIS.!!!
> *
>   
>
> *Warm Regards,***
>
> * *
>
> *Sukhvir Verma***
>
> *Sr. Detailer*
>
> ** **
>
> [image: EiGEN-Logo-Blue-with-transparent-background.png]
>
> *EiGEN Technical Services Pvt. Ltd.*
>
> 5th Floor Vatika Atrium *|* Tower – B | Sector 53 | Golf Course Road |
> Gurgaon-122001 | India
>
> T: +91 124 4017470 Ext. 549| M: +91 9818346504 | F: +91 124 4017468
>
> *sve...@eigen-tech.com*  *| 
> **www.eigen-tech.com*
> **
>
> ü please consider the environment before printing this e-mail
>
> ** **
>
> ** **
>
>  
>
>  --
> FORUM RULES (925+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (925+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

$$Excel-Macros$$ Extract Text

[karan 1237]

Dear All,

I've around 8k cell which has data showing below, I need your help to
extract specific text from the string. I need to extract text after first
comma ( *,* ) & before left paranthesis as showing below.

Kindly help.


Govt College of Engineering, Wayanand, P O Nallurnad, Mananthavady (1999).
Btech, BArch. Enrol 291. Teachers 14. Principal- Prof Binu Mangal

Govt College of Teacher Education, Thalassery, (1957). BEd. Enrol 120.
Teachers 9. Principal-Prof G Surendran Nair.

Keyi Sahib Training College, Karimbam PO (1995) BEd. Enrol 100. Teachers 8.
Principal - Prof E K Ali.

E-Max Institute of Computer Applications, Vill Gola, PO Bhadauli, Tehsil
Mullana, Dist Ambala. (2008) Enrol 24.




Kaяan

 

 
 

-- 
FORUM RULES (925+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Re: [bulk] $$Excel-Macros$$ Extract Text

[karan 1237]

Its working..! Great!

Thanks a lot Momin..!


Kaяan

<http://www.facebook.com/singhkarann> <http://twitter.com/#%21/karan1237>
<https://plus.google.com/43524614789164919/posts>
<http://www.myspace.com/singhkaran> <http://www.linkedin.com/in/singhkarann>
<http://karanxel.blogspot.com/> <http://karanxel.wordpress.com/>




On Tue, Nov 1, 2011 at 3:33 PM, Siraj Momin (BTG)  wrote:

> PFA
>
> ** **
>
> Best Regards
>
> ** **
>
> * *
>
> Momin Siraj Ahmad
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *karan 1237
> *Sent:* 01 November 2011 01:39 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* [bulk] $$Excel-Macros$$ Extract Text
> *Importance:* Low
>
> ** **
>
>
> Dear All,
>
> I've around 8k cell which has data showing below, I need your help to
> extract specific text from the string. I need to extract text after first
> comma ( *,* ) & before left paranthesis as showing below.
>
> Kindly help.
>
>
> Govt College of Engineering, Wayanand, P O Nallurnad, Mananthavady (1999).
> Btech, BArch. Enrol 291. Teachers 14. Principal- Prof Binu Mangal
>
> Govt College of Teacher Education, Thalassery, (1957). BEd. Enrol 120.
> Teachers 9. Principal-Prof G Surendran Nair.
>
>
> Keyi Sahib Training College, Karimbam PO (1995) BEd. Enrol 100. Teachers
> 8. Principal - Prof E K Ali.
>
> E-Max Institute of Computer Applications, Vill Gola, PO Bhadauli, Tehsil
> Mullana, Dist Ambala. (2008) Enrol 24.
>
>
>
>
> Kaяan
>
> <http://www.facebook.com/singhkarann> 
> <http://twitter.com/#%21/karan1237><https://plus.google.com/43524614789164919/posts><http://www.myspace.com/singhkaran><http://www.linkedin.com/in/singhkarann><http://karanxel.blogspot.com/><http://karanxel.wordpress.com/>
> 
>
> ** **
>
> --
> FORUM RULES (925+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (925+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (925+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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