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

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

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

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

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

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 noorain.ans...@gmail.comwrote: Dear Atul, Please see attached sheet with Dynamic Chart example. -- Thanks regards,

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

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

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

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:

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

$$Excel-Macros$$ Help

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

Re: $$Excel-Macros$$ Help

Kindly send text file.. On Sat, Oct 15, 2011 at 5:55 PM, santhu santhosh.qat...@gmail.com 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

Re: $$Excel-Macros$$ Help

can you attach the sample file On Sat, Oct 15, 2011 at 5:55 PM, santhu santhosh.qat...@gmail.com 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

Re: $$Excel-Macros$$ Help

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 xlst...@gmail.com wrote: Kindly send text file.. On

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

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,

Re: $$Excel-Macros$$ Help

Send sample file On 15 Oct 2011 21:51, santhu santhosh.qat...@gmail.com 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

$$Excel-Macros$$ multiple emails

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

Re: $$Excel-Macros$$ multiple emails

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 bobandrich...@comcast.net wrote: Can someone

$$Excel-Macros$$ How to learn vba

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

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

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

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

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

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

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

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

Hi, can u pls explain the formula being used in this sheet. On Oct 14, 9:45 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear prabhat, Please find attached sheet in Excel 2003 Version. Hope it help to u -- Thanks regards, Noorain Ansari