Re: $$Excel-Macros$$ To Extract a text with Conditions

Hi Rajan, what i mentioned in Final Destination column was required result, What I need is i have to extract those codes from Column A, logic I had mentioned in my first post. On Sat, Dec 31, 2011 at 10:33 AM, Rajan_Verma wrote: > My Function is working on those Destinations which are listed in

RE: $$Excel-Macros$$ To Extract a text with Conditions

My Function is working on those Destinations which are listed in FinalDestination Column , if the Keyword is not found in the list FinalDestination.. Result will be blank.. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Excel_Lover Sent: Dec

Re: $$Excel-Macros$$ To Extract a text with Conditions

Hi All, I am sorry, I didn't access my mail yesterday, Thanks to all of you for your replies, @Rajan, I have checked your comparison, don,yours, Kris & also Haseeb's, Hasseb's & Kris's giving same result, but as per your solution in some cells it results blank cells, I dont know whether I am do

RE: $$Excel-Macros$$ How to create *.xla format file

Hi.. If you will save your file in .xla , Excel will Cerate Excel -2003 Add-ins, To make an add-ins you need to have atleast on macro in your workbook.. And by double click on this file you can add this to your application, your macro will at application level. For more details Visit this page.

$$Excel-Macros$$ How to create *.xla format file

Dear experts, Please know me, how to create a *.xla format file of macro Regards Ashish Bhalara 9624111822 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem

RE: $$Excel-Macros$$ Disable delete

Hi Noorain.. Query is how to prevent files to be delete from folders?? Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Dec/Sat/2011 09:48 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Disable delete D

RE: $$Excel-Macros$$ Need Unique list Function

See the attached file.. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Dec/Sat/2011 07:09 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Unique list Function Dear Bhupendra, See attached sheet, i

RE: $$Excel-Macros$$ copy data to new work book

HI, Tryi this : Sub CopyDatatoNewWorkbook() Dim wbkNew As Workbook Set wbkNew = Workbooks.Add ThisWorkbook.ActiveSheet.UsedRange.Copy wbkNew.Worksheets(1).Range("A1") End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Beha

Re: $$Excel-Macros$$ Make String From Range without any Loop

Good one Rajan.. On Sat, Dec 31, 2011 at 12:35 AM, Rajan_Verma wrote: > Hi Group, > > ** ** > > Want to share a useful method on group to make a delimiter separated list > without any loop after taking Input Range of One Column of One Row, it can > work on 255 Cells. > > Application.Trans

Re: $$Excel-Macros$$ Disable delete

Dear Prakash, Please use attached sheet to disable any key. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Mon, Dec 26, 2011 at 11:23 AM, Prakash Gus

Re: $$Excel-Macros$$ To Extract a text with Conditions

Excellent Haseeb On Fri, Dec 30, 2011 at 9:22 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Try this *Array Formula*, > > > =INDEX(MID(A6,ROW(A$1:A$50)*4-3,3),MAX(IFERROR(MATCH(MID(A6,ROW(A$1:A$50)*4-3,3),IF(MID(A6,ROW(A$1:A$50)*4-3,3)="","A",MID(A6,ROW(A$1:A$50)*4-3,3)),0),""))) >

Re: $$Excel-Macros$$ Re: Hiding all excel functions

Press ctrl+A, then ctrl+1 then Protection-Click on Hidden then protect the sheet. On Wed, Dec 28, 2011 at 4:34 PM, EGMono wrote: > Set Toolbars visible to false, then set them back to true when the > workbook loses focus or quits. > > On Dec 27, 1:53 pm, treboryevrah wrote: > > How do I create

Re: $$Excel-Macros$$ Need Unique list Function

Dear Bhupendra, See attached sheet, i hope it will help to u. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Fri, Dec 30, 2011 at 3:02 PM, bhupendra

Re: $$Excel-Macros$$ copy data to new work book

Dear Chandra, You can also use this one.. Range("d5:d10").Copy Workbooks.Add Activeworkbook.Sheets(1).Range("a1").Select Activesheet.paste On Wed, Dec 28, 2011 at 2:30 PM, chandra sekaran wrote: > Dear sir > > i have code for copy past like this > > Range("d5:d10").Copy Workbooks.Add Wo

$$Excel-Macros$$ Make String From Range without any Loop

Hi Group, Want to share a useful method on group to make a delimiter separated list without any loop after taking Input Range of One Column of One Row, it can work on 255 Cells. Application.Transpose need to be used once if Data is Vertical and if data is horizontal its need to be used Twice..

RE: $$Excel-Macros$$dividing my data set in 70-30 Ratio

Try this Code: Sub DividData() Dim wksSheet As Worksheet Application.ScreenUpdating = 0 With ThisWorkbook Set wksSheet = ActiveSheet wksSheet.Range("A1:A" & Int((wksSheet.UsedRange.Rows.Count * 70) / 100)).EntireRow.Copy .Worksheets.Add.Name = "70%" .Act

Re: $$Excel-Macros$$dividing my data set in 70-30 Ratio

Try this.use this macro Sub Test() Dim RowCount As Integer Dim S As Integer Dim T As Integer LR = Cells(Rows.Count, "A").End(xlUp).Row RowCount = LR S = Round(RowCount * 70 / 100, 0) T = Application.WorksheetFunction.RoundUp(RowCount * 30 / 100, 0) Range("A1").

Re: $$Excel-Macros$$ Excel - Cell color actions

Hello Amar, As you said colors are changing through CF, check is the conditions TRUE or FALSE, then you can assign the values, if it is true. If you can share a dummy file or your CF condition to the group, it would be helpful. ___ HTH, Haseeb -- FORUM RULES (934+ members already BANN

$$Excel-Macros$$ Re: Search Engine DOUBT

Not sure about this. Try this macro. You could assign this macro on a button as well for easy use. Sub kTest() Dim ka, k(), i As Long, n As Long, j As Long, c As Long Dim WhichColAs String, Cols(), x, SearchKey As String Const SearchCellAs String = "E3" '<<== adj

Re: $$Excel-Macros$$ To Extract a text with Conditions

Yes,very nice Don Guillett SalesAid Software dguille...@gmail.com From: Haseeb Avarakkan Sent: Thursday, December 29, 2011 9:52 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To Extract a text with Conditions Try this Array Formula, =INDEX(MID(A6,ROW(A$1:A$50)*4-3,3),MAX(

$$Excel-Macros$$ Need Unique list Function

hello sir, how to find extract unique list in a list thanks raghav. -- FORUM RULES (934+ 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 att

Re: $$Excel-Macros$$ VBA Bignner

Thank Sir, I found this group very usefull. is good for beginners. On Fri, Dec 30, 2011 at 2:52 PM, Rajan_Verma wrote: > Hi Raghav, > > Welcome to the Group. > > You can follow these site and blog to learn VBA and to better understand of > Excel. If you want to read some book. You can downloa

RE: $$Excel-Macros$$ Auto create of sheet with new name in a sheet

Hi Please find the attached File.. It will also provide you automatically Hyperlinked index at the time of Worksheet Creation Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Err: Application.ScreenUpdating = False If Target.Column = 1 And Target.Cells.Count = 1 And Target.V

$$Excel-Macros$$ Re: Auto create of sheet with new name in a sheet

Thanks krish its working great. Sandeep On 29 December 2011 19:22, Kris wrote: > Hi, > > Put this code in the 'Particular sheet' module. Right click on sheet name > > view code and paste the code there. > > Also I set the range D2 where you enter the name of the product. adjust > this range in

Re: $$Excel-Macros$$ Send Personalized emails in Lotus Notes

Got a working code in our Jain brother's site. http://www.excelitems.com/2011/01/send-lotus-notes-email-vba-excel.html Thanks for your help though Rajan... On Dec 30, 2:28 pm, "Rajan_Verma" wrote: > You need to call this procedure with in another procedure with all > parameters > Sub sendMymail

Re: $$Excel-Macros$$ Disable delete

Thanks its also useful to me Thanks Rajan. On Fri, Dec 30, 2011 at 10:09 AM, Prakash Gusain wrote: > Thanks Asa it solved the issue! > > On Dec 27, 7:33 am, "Asa Rossoff" wrote: > > Since deleting is done through the operating system, network (if > > applicable), and file system, This needs

Re: $$Excel-Macros$$ Excel - Cell color actions

Try this : Sub AddCOmment() Dim rngCell As Range If rngCell.Interior.Color = YourCOlor Then rngCell.AddCOmment "YourCommentText" End If End Sub On Fri, Dec 30, 2011 at 3:20 PM, Kasireddy Amarender wrote: > Dear Both, > > Thank you for helping me out. I just understand that the

Re: $$Excel-Macros$$ Excel - Cell color actions

Dear Both, Thank you for helping me out. I just understand that the interior's colors are actually coming from the conditional formatting, so I think the filtering / using of color property may not be helping, hence I'm switching to use the conditions which were used for conditional formatting. H

RE: $$Excel-Macros$$ Send Personalized emails in Lotus Notes

You need to call this procedure with in another procedure with all parameters Sub sendMymail() SendNotesMail(Subject , attachment, ReceipentEmailID, bodytext, ,True) End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prakash Gu

Re: $$Excel-Macros$$ Send Personalized emails in Lotus Notes

Rajan Thanks for your reply. but sorry to say bro it's not working. On Dec 30, 1:28 pm, "Rajan_Verma" wrote: > Hi, > See the link.. you can modify as per your requirement.. > > http://www.fabalou.com/VBandVBA/lotusnotesmail.asp > > -Original Message- > From: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ VBA Bignner

Hi Raghav, Welcome to the Group. You can follow these site and blog to learn VBA and to better understand of Excel. If you want to read some book. You can download Many Free books on internet.. Please be in touch with Group :) www.ozgrid.com www.cpearson.com www.akoul.blogspot.com www.excelpow

$$Excel-Macros$$ VBA Bignner.

Rajan Sir, I have sound knowledge of Excel but want to learn VBA as well. Please suggest me some material from where i can start learn Regards Raghav. On Fri, Dec 30, 2011 at 2:00 PM, bhupendra singh raghav < raghav.bhupen...@gmail.com> wrote: > Hi Rajan Sir, > I have sound knowledge of Excel

$$Excel-Macros$$ VBA Bignner

Hello Experts, I have sound knowledge of Excel but want to learn VBA as well. Please suggest me some material from where i can start learn Regards Raghav. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, U

Re: $$Excel-Macros$$ Help

Hi Kris, you right..it is very complex with formula..I have to use Pivot table.itwill very easy.. Thanks Nikhil Shah On Fri, Dec 30, 2011 at 1:18 PM, Kris wrote: > Hi, > > With the help of a helper column, a Pivot table would do the trick. > > PFA. > > Kris > > -- > FORUM RULES (934+ members

RE: $$Excel-Macros$$ Send Personalized emails in Lotus Notes

Hi, See the link.. you can modify as per your requirement.. http://www.fabalou.com/VBandVBA/lotusnotesmail.asp -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prakash Gusain Sent: Dec/Fri/2011 01:56 To: MS EXCEL AND VBA MACROS Su

$$Excel-Macros$$ Send Personalized emails in Lotus Notes

Hi I want to send emails with constant subject but with variable matter to people in the my list. I am using Lotus notes as email client. For example: Column A has my mail matter. A1: xcvb, A2: assd A3: qwer A4: poiu Column B has email addresses. B1: x...@gmail.com B2: a...@gmail.com B3: q...@g

Re: $$Excel-Macros$$ Help

Hi, With the help of a helper column, a Pivot table would do the trick. PFA. Kris -- FORUM RULES (934+ 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 no

Re: $$Excel-Macros$$ To Extract a text with Conditions

@ Haseeb, Nice :) -- FORUM RULES (934+ 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

RE: $$Excel-Macros$$ To Extract a text with Conditions

Great From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Haseeb Avarakkan Sent: Dec/Fri/2011 09:23 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To Extract a text with Conditions Try this Array Formula, =INDEX(MID(A6,ROW(A$1:A$50)*4-3,

RE: $$Excel-Macros$$ Excel - Cell color actions

You need to make a color mapping and can use vlookup.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of siti Vi Sent: Dec/Fri/2011 10:45 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel - Cell color actions I have Color-Index-Numbe