date:20111015

Re: $$Excel-Macros$$ Toggle a Cell value

2011-10-15 Thread Cab Boose

Hi Don & Sam

Don.   appreciate your comment.  I had not made it clear what I was looking
for.  Apologies.

Sam, yes it is working great with dbl click or right click.  It does not
work with a single click, which is what I prefer.  In use the cell would be
selected and then may also need to click once again to change the cell to
requirement.

Your comments would be appreciated.

Thanks

Charlie Harris

On Sun, Oct 16, 2011 at 12:13 AM, dguillett1  wrote:

>   Your request was “when I SELECT the cell”. So, as Sam says, use another
> event such as doubleclick.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Cab Boose 
> *Sent:* Friday, October 14, 2011 8:32 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Toggle a Cell value
>
>  Hi Don and Sam
>
> Thanks for your input.
>
> I use Win7  Excel  and on a laptop.
>
>
> Don, your code work ok but  small hiccup.  The code/color changes ok when I
> select a different cell and then come back to actual cell again.  Color and
> number change as required.  However I would like to be able to leave the
> cursor in the active cell, somethimes,  and each time I tap the cell on the
> laptop pad, it should change. That is without having to go to another
> cell first.  In other words how do you get Excel to know when you select
> cell and then select again without moving.  Maybe if we can after the first
> selection and change of color/code Excel places the active cell into a
> default cell nearby, and if the direction needs to be changed again I need
> to select that cell again.  Or is there a way of refreshing the g15 cell
> without moving.
>
> Sam, your code brings up a   run time error '13'   type mismatch.  The
> color is ok by format, but does the code allow for changing the value in the
> cell back and forth from 1 to 0 and 0 to 1 .
>
>
> Thankyou all
>
> Charlie Harris
>
>
>
>
>
> On Sat, Oct 15, 2011 at 6:36 AM, Sam Mathai Chacko wrote:
>
>> This should do it
>>
>>
>> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>>
>> If Target.Address(0, 0) = "G15" Then
>> Target.Value = Abs(CLng(Not -Target.Value))
>> End If
>>
>> End Sub
>>
>> Use a conditional format for coloring the cell.
>>
>> If you do not want to add a conditional format (which is faster than VBA
>> by the way), and do the coloring also through VBA, then just add the
>> following line within the If End IF statement in the VBA above.
>>
>> Target.Interior.ColorIndex = 4 - Target.Value
>>
>> Regards,
>>
>> Sam Mathai Chacko
>>
>>
>> On Fri, Oct 14, 2011 at 6:09 PM, dguillett1  wrote:
>>
>>>   Right click sheet tab>view code>copy/paste this to make the changes in
>>> col G
>>>
>>> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>>> If Target.Column <> 7 Or Target.Count > 1 Then Exit Sub
>>> If Target = 1 Then
>>> Target = 0
>>> Target.Interior.ColorIndex = 4
>>> Else
>>> Target = 1
>>> Target.Interior.ColorIndex = 3
>>> End If
>>> End Sub
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Cab Boose 
>>> *Sent:* Friday, October 14, 2011 2:33 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ Toggle a Cell value
>>>
>>>   Hi eveyrone
>>>
>>> See attached sheet.
>>>
>>> For a 12 volt motor speed direction, Forward or Reverse  I want to have a
>>> value of a cell to toggle back and forth between 0 and 1 and cell color also
>>> to change each time between green and red.
>>>
>>> Prefer to use a cell than use a toggle button, unless a toggle button can
>>> change colors etc and the value of 0 or 1  from the toggle button can be
>>> used to export etc
>>>
>>> Your comments would be appreciated.
>>>
>>> Charlie Harris
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>  --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel

Re: $$Excel-Macros$$ vlookup return with pcture assinged

2011-10-15 Thread prabhat.shrivasta...@gmail.com

Hi, can u pls explain the formula being used in this sheet.

On Oct 14, 9:45 pm, NOORAIN ANSARI  wrote:
> Dear prabhat,
>
> Please find attached sheet in Excel 2003 Version.
> Hope it help to u
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
> On Fri, Oct 14, 2011 at 8:23 PM, prabhat.shrivasta...@gmail.com <
>
>
>
> prabhat.shrivasta...@gmail.com> wrote:
> > The file need to run on ms excel 2003 version.
>
> > Rgrds.Prabhat
>
> > On Oct 14, 12:03 pm, ashish koul  wrote:
> > > see if it helps
>
> > > On Fri, Oct 14, 2011 at 9:46 AM, prabhat.shrivasta...@gmail.com <
>
> > > prabhat.shrivasta...@gmail.com> wrote:
> > > > Good morning experts
>
> > > > Need your valueable help to complete ma project, i have three n more
> > > > pics in name of ram, shyam, n more pasted on diffrent sheet now i want
> > > > if i write ram in a assinged cell ram's pic appear in selected area of
> > > > sheet n so on. I dont wanna use macro for thisi need this to
> > > > complete ma project.
>
> > > > Thanks n regards,
> > > > Prabhat Shrivastava
>
> > > > --
>
> > ---
> > ---
> > > > Some important links for excel users:
> > > > 1. Follow us on TWITTER for tips tricks and links :
> > > >http://twitter.com/exceldailytip
> > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > > > To post to this group, send email to excel-macros@googlegroups.com
>
> > > > <><><><><><><><><><><><><><><><><><><><><><>
> > > > Like our page on facebook , Just follow below link
> > > >http://www.facebook.com/discussexcel
>
> > > --
> > > *Regards*
> > > * *
> > > *Ashish Koul*
> > > *http://www.excelvbamacros.com/*
>
> > > P Before printing, think about the environment.
>
> > >  images_index.xlsx
> > > 55KViewDownload
>
> > --
>
> > --- 
> > ---
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
>
>
>  Image_Fatching example1.xls
> 59KViewDownload

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

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

Re: $$Excel-Macros$$ How to learn vba

2011-10-15 Thread Dilip Pandey

Hi Mr. Excel,

I would suggest you to enable recording and do whatever you want to do
in Excel window.  Now go to code window (Alt + F11) and see how Excel
transformed your actions into vba code and try to understand that.
Change some references there and play that again to see your edited
actions.  Keep doing like this and you will learn automatically plus
you can refer the links as well as mentioned by group members..

Best of luck.

Regards,
DILIPandey

On 10/16/11, Mr excel  wrote:
> Hi group,
>
>i would like to know a specific method for learning Excel vba.I mean i m
> just getting perplexed & worried about how to learn excel vba on seeing this
> so many examples in this forum.I could not get a right point where to start
> in vba.
>
> Kindly suggest some tips or methods so that i can follow in learning excel
> vba.
>
> Thanks in advance.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


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

Re: $$Excel-Macros$$ How to learn vba

2011-10-15 Thread XLS S

firstly learn recording then play with recorded code

http://www.youtube.com/watch?v=Ycab4OiPug0
http://www.internet4classrooms.com/excel_record_macro.htm
http://office.microsoft.com/en-us/excel-help/record-and-use-excel-macros-HA001054837.aspx
http://msdn.microsoft.com/en-us/library/7kyhdt1z%28v=vs.80%29.aspx

On Sun, Oct 16, 2011 at 5:53 AM, Mr excel  wrote:

> Hi group,
>
>i would like to know a specific method for learning Excel vba.I mean i m
> just getting perplexed & worried about how to learn excel vba on seeing this
> so many examples in this forum.I could not get a right point where to start
> in vba.
>
> Kindly suggest some tips or methods so that i can follow in learning excel
> vba.
>
> Thanks in advance.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

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

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

Re: $$Excel-Macros$$ How to learn vba

2011-10-15 Thread Venkat CV

Hi,

Refer Below Links..

http://www.cpearson.com/Excel/MainPage.aspx
http://www.teachexcel.com/
http://www.ozgrid.com/VBA/
http://www.exceltip.com/st/Writing_Your_First_VBA_Function_in_Excel/631.html

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *



On Sun, Oct 16, 2011 at 5:53 AM, Mr excel  wrote:

> Hi group,
>
>i would like to know a specific method for learning Excel vba.I mean i m
> just getting perplexed & worried about how to learn excel vba on seeing this
> so many examples in this forum.I could not get a right point where to start
> in vba.
>
> Kindly suggest some tips or methods so that i can follow in learning excel
> vba.
>
> Thanks in advance.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*
*
*

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

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

$$Excel-Macros$$ How to learn vba

2011-10-15 Thread Mr excel

Hi group,

   i would like to know a specific method for learning Excel vba.I mean i m
just getting perplexed & worried about how to learn excel vba on seeing this
so many examples in this forum.I could not get a right point where to start
in vba.

Kindly suggest some tips or methods so that i can follow in learning excel
vba.

Thanks in advance.

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

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

Re: $$Excel-Macros$$ multiple emails

2011-10-15 Thread Sam Mathai Chacko

You could use this. There's also a link to Ron's site.

http://www.excelfox.com/forum/showthread.php?142-Excel-template-with-macro-for-sending-mails-and-attahment-thru-outlook
.

Regards,

Sam Mathai Chacko (GL)

On Sat, Oct 15, 2011 at 10:19 PM, Bob  wrote:

> Can someone help. I have a list in column C of email addresses. I'd
> like to have a commandbutton once clicked to automatically attach all
> the email names to an email to do a bulk email. Thanks in advance!!!
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



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

$$Excel-Macros$$ multiple emails

2011-10-15 Thread Bob

Can someone help. I have a list in column C of email addresses. I'd
like to have a commandbutton once clicked to automatically attach all
the email names to an email to do a bulk email. Thanks in advance!!!

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

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

Re: $$Excel-Macros$$ Help

2011-10-15 Thread Swapnil Palande

Send sample file
On 15 Oct 2011 21:51, "santhu"  wrote:

> Hi,
>
>  How to extract a text file data to an excel sheet.
>
> Ex:  Sl.no FirstName MiddleName LastName Place
> 1 ABC  abc India
> 2 DEF  def   ghi   Aus
> 3 GHI  ghi   India
>
> while extracting this data to excel it should place in the exact
> column even the middle name is empty it should display empty in cell.
>
> It should be extract based on the length of the column as predefined
> in text file.
>
> Thanks in Advance!!
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ Dynamic chart range

2011-10-15 Thread dguillett1

Thanks

Don Guillett
SalesAid Software
dguille...@gmail.com

From: NOORAIN ANSARI 
Sent: Saturday, October 15, 2011 12:14 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Dynamic chart range

Very excellent Example Don Sir...

Masterpiece..


On Sat, Oct 15, 2011 at 7:44 PM, dguillett1  wrote:

  If you just need it to be dynamic withOUT having to select the month, change 
my cola formula to this so when each month is added it will chart
  colA
  =OFFSET(SAS!$A$3,0,0,COUNTA(SAS!$A:$A)-1,1)
  colB
  =offset(colA,0,1)

  Don Guillett
  SalesAid Software
  dguille...@gmail.com

  From: dguillett1 
  Sent: Saturday, October 15, 2011 8:09 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Dynamic chart range

  With dynamic name applied. See SAS sheet

  Don Guillett
  SalesAid Software
  dguille...@gmail.com

  From: NOORAIN ANSARI 
  Sent: Friday, October 14, 2011 9:49 PM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Dynamic chart range

  Dear Atul,

  Please see attached sheet with Dynamic Chart example.

  -- 

  Thanks & regards,
  Noorain Ansari
  http://excelmacroworld.blogspot.com/
  http://noorain-ansari.blogspot.com/
  On Thu, Oct 13, 2011 at 5:32 AM, Atul  wrote:

Hi All,
I want to make chart  range dynamic  For example, range A1:g1
represents series for the first week and I want to extend the range
for the second week means I want to change the range to A1:N1. Please
help me to make it dynamic
Thanks
Atul

--

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

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

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





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

  To post to this group, send email to excel-macros@googlegroups.com
   
  <><><><><><><><><><><><><><><><><><><><><><>
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel

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

  To post to this group, send email to excel-macros@googlegroups.com
   
  <><><><><><><><><><><><><><><><><><><><><><>
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel




-- 

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

<><><><><><><><><><><><><><><><><><>

Re: $$Excel-Macros$$ Dynamic chart range

2011-10-15 Thread NOORAIN ANSARI

Very excellent Example Don Sir...

Masterpiece..

On Sat, Oct 15, 2011 at 7:44 PM, dguillett1  wrote:

>   If you just need it to be dynamic withOUT having to select the month,
> change my cola formula to this so when each month is added it will chart
> colA
> =OFFSET(SAS!$A$3,0,0,COUNTA(SAS!$A:$A)-1,1)
> colB
> =offset(colA,0,1)
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* dguillett1 
> *Sent:* Saturday, October 15, 2011 8:09 AM
>   *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Dynamic chart range
>
>With dynamic name applied. See SAS sheet
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* NOORAIN ANSARI 
> *Sent:* Friday, October 14, 2011 9:49 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Dynamic chart range
>
>  Dear Atul,
>
> Please see attached sheet with Dynamic Chart example.
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
> On Thu, Oct 13, 2011 at 5:32 AM, Atul  wrote:
>
>> Hi All,
>> I want to make chart  range dynamic  For example, range A1:g1
>> represents series for the first week and I want to extend the range
>> for the second week means I want to change the range to A1:N1. Please
>> help me to make it dynamic
>> Thanks
>> Atul
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



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

Re: $$Excel-Macros$$ JOB MIS executive for Gurgaon

2011-10-15 Thread XLS S

Hey All,

Hiring still open kindly come for interview at

AuthBridge Research Services Pvt. Ltd.
Plot No. 123, II Floor, Udyog Vihar,
Phase IV – Gurgaon – 122 016
HARYANA, INDIA



On Tue, Sep 6, 2011 at 11:00 PM, XLS S  wrote:

> Hey All,
>
>
>
> We need MIS Exe having good knowledge of Excel and Access. Forward you’re
> CV on my e-mail address (vikask...@gmail.com) or call me 9911868518
>
> Company Name : AuthBridge Research Services (p) Ltd.
>
> Company Website : www.AuthBridge.com
>
> Role:MIS Executive
>
> Job Description:
>
> 1) Prepare Client Dashboard and client trackers
>
> 2) Prepare daily/weekly/monthly MIS,
>
> 3) provide analysis of the MIS,
>
> 4) Provide additional MIS & analysis on need basis request.
>
> Experience:
>
> 2 - 3 Years
>
> Location:
>
> Gurgaon
>
> Compensation:
>
> Rupees 1,00,000 - 2,00,000
>
>  Education:
>
> Any
> Regards
> Vikas Chauhan
> 9911868518
>
> --
> .
> XLS S
> Pagal Bana Dey
>



-- 
.

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

2011-10-15 Thread Sam Mathai Chacko

Try importing data from external file > Text file. When you import, you'll
get an option to use a delimiter. Normally, text files are delimited using
tab, or space.

Regards,


Sam Mathai Chacko (GL)

On Sat, Oct 15, 2011 at 6:25 PM, XLS S  wrote:

> Kindly send text file..
>
>  On Sat, Oct 15, 2011 at 5:55 PM, santhu wrote:
>
>> Hi,
>>
>>  How to extract a text file data to an excel sheet.
>>
>> Ex:  Sl.no FirstName MiddleName LastName Place
>> 1 ABC  abc India
>> 2 DEF  def   ghi   Aus
>> 3 GHI  ghi   India
>>
>> while extracting this data to excel it should place in the exact
>> column even the middle name is empty it should display empty in cell.
>>
>> It should be extract based on the length of the column as predefined
>> in text file.
>>
>> Thanks in Advance!!
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> .
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



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

Re: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-15 Thread Dilip Pandey

Hi Anil,

You can use following two formula for your two columns respectively:-

=MID(B7,SEARCH("ORIG:",B7)+5,(SEARCH("ID:",B7)-1-SEARCH("ORIG:",B7)-5))

=MID(E7,SEARCH("BNF:",E7)+4,(SEARCH("ID:",E7)-1-SEARCH("BNF:",E7)-4))

Sample sheet is also attached for your better understanding.

Regards,
DILIPandey

On 10/15/11, Anil Bhange  wrote:
> Hi Ms-EXl-learner and Noorain,
>
> Could you help me with another formula for attached mail.
>
> Regards,Anil Bhange
> IP Phone - 512320 | Mobile - 90290 32123
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Anil Bhange
> Sent: Wednesday, October 12, 2011 04:14 PM
> To: excel-macros@googlegroups.com
> Subject: RE: $$Excel-Macros$$ Formula needed to extract the text from string
>
> Amazing... Ms-Exl-learner...
>
> This is exactly what I wanted... I was pretty sure this forum only can help
> me with solution...
>
> Thanks once again.. this saves my lot of time...
>
> Regards,Anil Bhange
> IP Phone - 512320 | Mobile - 90290 32123
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Ms-Exl-Learner .
> Sent: Wednesday, October 12, 2011 03:34 PM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Formula needed to extract the text from string
>
> Hi Anil,
>
> I Assume that your data is in Column A and your first row is having the
> column header.
>
> So your data will start from 2nd row of Column A (i.e. from A2 cell)
>
> A1 Data
> A2 /ENTRY-10 OCT TRF/REF  6004ABS6834230 /ORD/ Q-FAST TELECOM BV
> STRIJKVIERTEL 26 A 3454 PMDE MEERN /BNF/ INVOICENO 201100247 ACCOUNTNO
>  019481
> A3 /ENTRY-10 OCT TRF/REF  6004ABS68300014073 /ORD/ U-WISS CONSULTANCY OUDAEN
> 26 LELYSTAD /BNF/20110279 TRANSACTIEDATUM 10-10-2011
> A4 /ENTRY-10 OCTTRF/REF  6004ABS68300025023/ORD/ U-WISS CONSULTANCY OUDAEN
> 26 LELYSTAD /BNF/20110295 TRANSACTIEDATUM 10-10-2011
>
> Copy and paste the below formula in any of the 2nd row cell (i.e. B2 cell)
> =TRIM(MID(SUBSTITUTE("/"&A2&REPT("/",6),"/",REPT(CHAR(32),255)),5*255,255))
>
> Drag the B2 cell formula below for the remaining cells of B column.
>
> Hope that helps!
>
> ---
> Ms.Exl.Learner
> --
>
> On Wed, Oct 12, 2011 at 1:20 PM, Anil Bhange
> mailto:anil.bha...@tatacommunications.com>>
> wrote:
> Hi Expert,
>
> I needed the formula which can extract the specific content from a Text,
> below is some sample excel cells
>
> To simplify this there is "/" sign after each content, and I need exact data
> which start after 4th "/" and till 5th "/" (which is mention below in Red).
>
> Can anybody tell me the formula.
>
>
>
> /ENTRY-10 OCT
> TRF/REF  6004ABS6834230
> /ORD/ Q-FAST TELECOM BV STRIJKVIERTEL 26 A 3454 PM
> DE MEERN /BNF/ INVOICENO 201100247 ACCOU
> NTNO019481
>
> /ENTRY-10 OCT
> TRF/REF  6004ABS68300014073
> /ORD/ U-WISS CONSULTANCY OUDAEN 26 LELYSTAD /BNF/
> 20110279 TRANSACTIEDATUM 10-10-2011
>
> /ENTRY-10 OCT
> TRF/REF  6004ABS68300025023
> /ORD/ U-WISS CONSULTANCY OUDAEN 26 LELYSTAD /BNF/
> 20110295 TRANSACTIEDATUM 10-10-2011
>
>
>
>
>
>
>
> Anil Bhange
>
> Assistant Manager
> Financial Reporting & Compliance,
>
> TATA Communications Ltd.
> VSB, Fort,  Mumbai - 400 001,
> India
>
>
>
> ' Desk : + 91 22 6659 2320
> | IP Phone : 51 2320 | Mobile :+ 91 90290 32123
>
> anil.bha...@tatacommunications.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$$ Help

2011-10-15 Thread ashish koul

can you attach the sample file

On Sat, Oct 15, 2011 at 5:55 PM, santhu  wrote:

> Hi,
>
>  How to extract a text file data to an excel sheet.
>
> Ex:  Sl.no FirstName MiddleName LastName Place
> 1 ABC  abc India
> 2 DEF  def   ghi   Aus
> 3 GHI  ghi   India
>
> while extracting this data to excel it should place in the exact
> column even the middle name is empty it should display empty in cell.
>
> It should be extract based on the length of the column as predefined
> in text file.
>
> Thanks in Advance!!
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

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

2011-10-15 Thread XLS S

Kindly send text file..

On Sat, Oct 15, 2011 at 5:55 PM, santhu  wrote:

> Hi,
>
>  How to extract a text file data to an excel sheet.
>
> Ex:  Sl.no FirstName MiddleName LastName Place
> 1 ABC  abc India
> 2 DEF  def   ghi   Aus
> 3 GHI  ghi   India
>
> while extracting this data to excel it should place in the exact
> column even the middle name is empty it should display empty in cell.
>
> It should be extract based on the length of the column as predefined
> in text file.
>
> Thanks in Advance!!
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

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

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

$$Excel-Macros$$ Help

2011-10-15 Thread santhu

Hi,

 How to extract a text file data to an excel sheet.

Ex:  Sl.no FirstName MiddleName LastName Place
 1 ABC  abc India
 2 DEF  def   ghi   Aus
 3 GHI  ghi   India

while extracting this data to excel it should place in the exact
column even the middle name is empty it should display empty in cell.

It should be extract based on the length of the column as predefined
in text file.

Thanks in Advance!!

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

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

Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

2011-10-15 Thread dguillett1



Forgot about the dups. Use this instead
Sub CustomSortNumbersAndTextSAS()
Application.ScreenUpdating = False
'Range("c1:c15").Copy Range("a1")'for testing

Range("b1") = Range("a1")
With Range("b2:b15")
.Formula = "=text(a2,""@"")"
.Copy
.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
.Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlGuess, _
 orderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End With
With Range("b1:b15")
.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("a1"), Unique:=True
.Clear
End With
Application.ScreenUpdating = True
End Sub

Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: dguillett1

Sent: Saturday, October 15, 2011 10:44 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

Just make sure col B not being used or select another blank column

Sub CustomSortNumbersAndTextSAS()
With Range("b2:b15")
Application.ScreenUpdating = False
.Formula = "=text(a2,""@"")"
.Copy
.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
.Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlGuess, _
 orderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
Application.ScreenUpdating = False
.Cut Destination:=Range("a2")
Range("a2").Select
End With
End Sub


Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: B Sharma

Sent: Thursday, October 13, 2011 10:13 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

Dear Don & other experts

Coloumn A has raw data and column B have sorted data
Before After
52  193
86  195
92C  52
94B  86
94B  87
195  92C
193  94B
ABC  94C
XYZ  94J
87  94K
94J  ABC
94B  XYZ
94K
94C


Hope that you can understand...
Thanks 7 Regards,
BS




On Oct 13, 9:01 pm, "dguillett1"  wrote:

What would the AFTER look like

Don Guillett
SalesAid Software
dguille...@gmail.com







-Original Message-
From: B Sharma
Sent: Thursday, October 13, 2011 8:46 AM
To: MS EXCEL AND VBA MACROS
Cc: rajanverma1...@gmail.com
Subject: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

Dear Excel Experts  (and to my friends who have answered to my
earlier queries)

From a long time, I am searching for a formula which can sort the list
and represent the unique datas only

for Example , In column 1 I have the following data

52
86
92C
94B
94B
195
193
ABC
XYZ
87
94J
94B
94K
94C

like this...
I want a output in column B where it will ignore the duplicate items
and sorted figures.

I think its quiet difficult but please try this ...

Thanks & Regards,
B. Sharma

--
---
 ---
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links 
:http://twitter.com/exceldailytip

2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials athttp://www.excel-macros.blogspot.com
4. Learn VBA Macros athttp://www.quickvba.blogspot.com
5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com

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

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


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

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

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


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

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

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

Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

2011-10-15 Thread dguillett1


Just make sure col B not being used or select another blank column

Sub CustomSortNumbersAndTextSAS()
With Range("b2:b15")
Application.ScreenUpdating = False
.Formula = "=text(a2,""@"")"
.Copy
.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
.Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlGuess, _
 orderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
Application.ScreenUpdating = False
.Cut Destination:=Range("a2")
Range("a2").Select
End With
End Sub


Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: B Sharma

Sent: Thursday, October 13, 2011 10:13 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

Dear Don & other experts

Coloumn A has raw data and column B have sorted data
Before After
52  193
86  195
92C  52
94B  86
94B  87
195  92C
193  94B
ABC  94C
XYZ  94J
87  94K
94J  ABC
94B  XYZ
94K
94C


Hope that you can understand...
Thanks 7 Regards,
BS




On Oct 13, 9:01 pm, "dguillett1"  wrote:

What would the AFTER look like

Don Guillett
SalesAid Software
dguille...@gmail.com







-Original Message-
From: B Sharma
Sent: Thursday, October 13, 2011 8:46 AM
To: MS EXCEL AND VBA MACROS
Cc: rajanverma1...@gmail.com
Subject: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

Dear Excel Experts  (and to my friends who have answered to my
earlier queries)

From a long time, I am searching for a formula which can sort the list
and represent the unique datas only

for Example , In column 1 I have the following data

52
86
92C
94B
94B
195
193
ABC
XYZ
87
94J
94B
94K
94C

like this...
I want a output in column B where it will ignore the duplicate items
and sorted figures.

I think its quiet difficult but please try this ...

Thanks & Regards,
B. Sharma

--
--- 
 ---

Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links 
:http://twitter.com/exceldailytip

2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials athttp://www.excel-macros.blogspot.com
4. Learn VBA Macros athttp://www.quickvba.blogspot.com
5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com

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

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


--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

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


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

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

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

Re: $$Excel-Macros$$ Dynamic chart range

2011-10-15 Thread dguillett1

If you just need it to be dynamic withOUT having to select the month, change my 
cola formula to this so when each month is added it will chart
colA
=OFFSET(SAS!$A$3,0,0,COUNTA(SAS!$A:$A)-1,1)
colB
=offset(colA,0,1)

Don Guillett
SalesAid Software
dguille...@gmail.com

From: dguillett1 
Sent: Saturday, October 15, 2011 8:09 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Dynamic chart range

With dynamic name applied. See SAS sheet

Don Guillett
SalesAid Software
dguille...@gmail.com

From: NOORAIN ANSARI 
Sent: Friday, October 14, 2011 9:49 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Dynamic chart range

Dear Atul,

Please see attached sheet with Dynamic Chart example.

-- 

Thanks & regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
On Thu, Oct 13, 2011 at 5:32 AM, Atul  wrote:

  Hi All,
  I want to make chart  range dynamic  For example, range A1:g1
  represents series for the first week and I want to extend the range
  for the second week means I want to change the range to A1:N1. Please
  help me to make it dynamic
  Thanks
  Atul

  --
  
--
  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$$ Toggle a Cell value

2011-10-15 Thread dguillett1

Your request was “when I SELECT the cell”. So, as Sam says, use another event 
such as doubleclick.

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Cab Boose 
Sent: Friday, October 14, 2011 8:32 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Toggle a Cell value

Hi Don and Sam

Thanks for your input.

I use Win7  Excel  and on a laptop.

Don, your code work ok but  small hiccup.  The code/color changes ok when I 
select a different cell and then come back to actual cell again.  Color and 
number change as required.  However I would like to be able to leave the cursor 
in the active cell, somethimes,  and each time I tap the cell on the laptop 
pad, it should change. That is without having to go to another cell first.  
In other words how do you get Excel to know when you select cell and then 
select again without moving.  Maybe if we can after the first selection and 
change of color/code Excel places the active cell into a default cell nearby, 
and if the direction needs to be changed again I need to select that cell 
again.  Or is there a way of refreshing the g15 cell without moving.

Sam, your code brings up a   run time error '13'   type mismatch.  The color is 
ok by format, but does the code allow for changing the value in the cell back 
and forth from 1 to 0 and 0 to 1 .

Thankyou all

Charlie Harris

On Sat, Oct 15, 2011 at 6:36 AM, Sam Mathai Chacko  wrote:

  This should do it 

  Private Sub Worksheet_SelectionChange(ByVal Target As Range)

  If Target.Address(0, 0) = "G15" Then
  Target.Value = Abs(CLng(Not -Target.Value))
  End If

  End Sub

  Use a conditional format for coloring the cell.

  If you do not want to add a conditional format (which is faster than VBA by 
the way), and do the coloring also through VBA, then just add the following 
line within the If End IF statement in the VBA above.

  Target.Interior.ColorIndex = 4 - Target.Value

  Regards,

  Sam Mathai Chacko 

  On Fri, Oct 14, 2011 at 6:09 PM, dguillett1  wrote:

Right click sheet tab>view code>copy/paste this to make the changes in col G

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column <> 7 Or Target.Count > 1 Then Exit Sub
If Target = 1 Then
Target = 0
Target.Interior.ColorIndex = 4
Else
Target = 1
Target.Interior.ColorIndex = 3
End If
End Sub

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Cab Boose 
Sent: Friday, October 14, 2011 2:33 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Toggle a Cell value

Hi eveyrone

See attached sheet.

For a 12 volt motor speed direction, Forward or Reverse  I want to have a 
value of a cell to toggle back and forth between 0 and 1 and cell color also to 
change each time between green and red.

Prefer to use a cell than use a toggle button, unless a toggle button can 
change colors etc and the value of 0 or 1  from the toggle button can be used 
to export etc

Your comments would be appreciated.

Charlie Harris
-- 

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

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

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

-- 

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

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

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

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

Re: $$Excel-Macros$$ Dynamic chart range

2011-10-15 Thread ashish koul

http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/


http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html

On Sat, Oct 15, 2011 at 8:19 AM, NOORAIN ANSARI wrote:

> Dear Atul,
>
> Please see attached sheet with Dynamic Chart example.
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
> On Thu, Oct 13, 2011 at 5:32 AM, Atul  wrote:
>
>> Hi All,
>> I want to make chart  range dynamic  For example, range A1:g1
>> represents series for the first week and I want to extend the range
>> for the second week means I want to change the range to A1:N1. Please
>> help me to make it dynamic
>> Thanks
>> Atul
>>
>> --
>>
>> --
>> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
--
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$$ Formula needed to extract the text from string

2011-10-15 Thread ashish koul

MID(E7,FIND("BNF:",E7)+4,FIND("ID:",E7)-FIND("BNF:",E7)-4)

On Sat, Oct 15, 2011 at 5:22 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:

> Hi Ms-EXl-learner and Noorain,
>
> ** **
>
> Could you help me with another formula for attached mail.
>
> ** **
>
> Regards,Anil Bhange
>
> IP Phone - 512320 | Mobile - 90290 32123
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Anil Bhange
> *Sent:* Wednesday, October 12, 2011 04:14 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* RE: $$Excel-Macros$$ Formula needed to extract the text from
> string
>
> ** **
>
> Amazing… Ms-Exl-learner…
>
> ** **
>
> This is exactly what I wanted… I was pretty sure this forum only can help
> me with solution…
>
> ** **
>
> Thanks once again.. this saves my lot of time…
>
> ** **
>
> Regards,Anil Bhange
>
> IP Phone - 512320 | Mobile - 90290 32123
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ms-Exl-Learner .
> *Sent:* Wednesday, October 12, 2011 03:34 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Formula needed to extract the text from
> string
>
> ** **
>
> Hi Anil,
>
> ** **
>
> I Assume that your data is in Column A and your first row is having the
> column header.
>
> ** **
>
> So your data will start from 2nd row of Column A (i.e. from A2 cell)
>
> ** **
>
> A1 Data
>
> A2 /ENTRY-10 OCT TRF/REF  6004ABS6834230 /ORD/ Q-FAST TELECOM BV
> STRIJKVIERTEL 26 A 3454 PMDE MEERN /BNF/ INVOICENO 201100247
> ACCOUNTNO019481
>
> A3 /ENTRY-10 OCT TRF/REF  6004ABS68300014073 /ORD/ U-WISS CONSULTANCY
> OUDAEN 26 LELYSTAD /BNF/20110279 TRANSACTIEDATUM 10-10-2011
>
> A4 /ENTRY-10 OCTTRF/REF  6004ABS68300025023/ORD/ U-WISS CONSULTANCY OUDAEN
> 26 LELYSTAD /BNF/20110295 TRANSACTIEDATUM 10-10-2011
>
> ** **
>
> Copy and paste the below formula in any of the 2nd row cell (i.e. B2 cell)
> 
>
> =TRIM(MID(SUBSTITUTE("/"&A2&REPT("/",6),"/",REPT(CHAR(32),255)),5*255,255))
> 
>
> ** **
>
> Drag the B2 cell formula below for the remaining cells of B column.
>
> ** **
>
> Hope that helps!
>
> ** **
>
> ---
> Ms.Exl.Learner
> --
>
> ** **
>
> On Wed, Oct 12, 2011 at 1:20 PM, Anil Bhange <
> anil.bha...@tatacommunications.com> wrote:
>
> Hi Expert,
>
>  
>
> I needed the formula which can extract the specific content from a Text,
> below is some sample excel cells
>
>  
>
> To simplify this there is “/” sign after each content, and I need exact
> data which *start after 4th “/” and till 5th “/”* (which is mention below
> in Red).
>
>  
>
> Can anybody tell me the formula.
>
>  
>
>  
>
>  
>
> /ENTRY-10 OCT
> TRF/REF  6004ABS6834230
> /ORD/* Q-FAST TELECOM BV STRIJKVIERTEL 26 A 3454 PM
> DE MEERN */BNF/ INVOICENO 201100247 ACCOU
> NTNO019481
>
> /ENTRY-10 OCT
> TRF/REF  6004ABS68300014073
> /ORD/* U-WISS CONSULTANCY OUDAEN 26 LELYSTAD */BNF/
> 20110279 TRANSACTIEDATUM 10-10-2011
>
> /ENTRY-10 OCT
> TRF/REF  6004ABS68300025023
> /ORD/* U-WISS CONSULTANCY OUDAEN 26 LELYSTAD** */BNF/
> 20110295 TRANSACTIEDATUM 10-10-2011
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> *Anil Bhange*
>
> *Assistant Manager*
> Financial Reporting & Compliance,
>
> TATA Communications Ltd.
> VSB, Fort,  Mumbai – 400 001,
> India
>
>  
>
> ' Desk : + 91 22 6659 2320
> | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 
>
> anil.bha...@tatacommunications.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
>
> <><><><><><><><><><><><>

RE: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-15 Thread Anil Bhange

Hi Ms-EXl-learner and Noorain,

Could you help me with another formula for attached mail.

Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Anil Bhange
Sent: Wednesday, October 12, 2011 04:14 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Formula needed to extract the text from string

Amazing... Ms-Exl-learner...

This is exactly what I wanted... I was pretty sure this forum only can help me 
with solution...

Thanks once again.. this saves my lot of time...

Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Ms-Exl-Learner .
Sent: Wednesday, October 12, 2011 03:34 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula needed to extract the text from string

Hi Anil,

I Assume that your data is in Column A and your first row is having the column 
header.

So your data will start from 2nd row of Column A (i.e. from A2 cell)

A1 Data
A2 /ENTRY-10 OCT TRF/REF  6004ABS6834230 /ORD/ Q-FAST TELECOM BV 
STRIJKVIERTEL 26 A 3454 PMDE MEERN /BNF/ INVOICENO 201100247 ACCOUNTNO  
  019481
A3 /ENTRY-10 OCT TRF/REF  6004ABS68300014073 /ORD/ U-WISS CONSULTANCY OUDAEN 26 
LELYSTAD /BNF/20110279 TRANSACTIEDATUM 10-10-2011
A4 /ENTRY-10 OCTTRF/REF  6004ABS68300025023/ORD/ U-WISS CONSULTANCY OUDAEN 26 
LELYSTAD /BNF/20110295 TRANSACTIEDATUM 10-10-2011

Copy and paste the below formula in any of the 2nd row cell (i.e. B2 cell)
=TRIM(MID(SUBSTITUTE("/"&A2&REPT("/",6),"/",REPT(CHAR(32),255)),5*255,255))

Drag the B2 cell formula below for the remaining cells of B column.

Hope that helps!

---
Ms.Exl.Learner
--

On Wed, Oct 12, 2011 at 1:20 PM, Anil Bhange 
mailto:anil.bha...@tatacommunications.com>> 
wrote:
Hi Expert,

I needed the formula which can extract the specific content from a Text, below 
is some sample excel cells

To simplify this there is "/" sign after each content, and I need exact data 
which start after 4th "/" and till 5th "/" (which is mention below in Red).

Can anybody tell me the formula.



/ENTRY-10 OCT
TRF/REF  6004ABS6834230
/ORD/ Q-FAST TELECOM BV STRIJKVIERTEL 26 A 3454 PM
DE MEERN /BNF/ INVOICENO 201100247 ACCOU
NTNO019481

/ENTRY-10 OCT
TRF/REF  6004ABS68300014073
/ORD/ U-WISS CONSULTANCY OUDAEN 26 LELYSTAD /BNF/
20110279 TRANSACTIEDATUM 10-10-2011

/ENTRY-10 OCT
TRF/REF  6004ABS68300025023
/ORD/ U-WISS CONSULTANCY OUDAEN 26 LELYSTAD /BNF/
20110295 TRANSACTIEDATUM 10-10-2011







Anil Bhange

Assistant Manager
Financial Reporting & Compliance,

TATA Communications Ltd.
VSB, Fort,  Mumbai - 400 001,
India



' Desk : + 91 22 6659 2320
| IP Phone : 51 2320 | Mobile :+ 91 90290 32123

anil.bha...@tatacommunications.com



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

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on fa

Re: $$Excel-Macros$$ Toggle a Cell value

Re: $$Excel-Macros$$ vlookup return with pcture assinged

Re: $$Excel-Macros$$ How to learn vba

Re: $$Excel-Macros$$ How to learn vba

Re: $$Excel-Macros$$ How to learn vba

$$Excel-Macros$$ How to learn vba

Re: $$Excel-Macros$$ multiple emails

$$Excel-Macros$$ multiple emails

Re: $$Excel-Macros$$ Help

Re: $$Excel-Macros$$ Dynamic chart range

Re: $$Excel-Macros$$ Dynamic chart range

Re: $$Excel-Macros$$ JOB MIS executive for Gurgaon

Re: $$Excel-Macros$$ Help

Re: $$Excel-Macros$$ Formula needed to extract the text from string

Re: $$Excel-Macros$$ Help

Re: $$Excel-Macros$$ Help

$$Excel-Macros$$ Help

Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

Re: $$Excel-Macros$$ Dynamic chart range

Re: $$Excel-Macros$$ Toggle a Cell value

Re: $$Excel-Macros$$ Dynamic chart range

Re: $$Excel-Macros$$ Formula needed to extract the text from string

RE: $$Excel-Macros$$ Formula needed to extract the text from string

24 matches

Site Navigation

Mail list logo

Footer information