Re: $$Excel-Macros$$ Disable delete

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 to be configured using file and > network permissions. > > Here's an example "advanced" file permissions dialo

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(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),""))) Copy down.. ___ HTH, Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise,

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

I think this is the proper solution. Perhaps you should test yourself. Don Guillett SalesAid Software dguille...@gmail.com From: Rajan_Verma Sent: Thursday, December 29, 2011 3:47 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ To Extract a text with Conditions In attached f

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

My solution did not give the proper result. Formulas would be a “toughie” Don Guillett SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Thursday, December 29, 2011 1:59 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To Extract a text with Conditions Wonderfu

RE: $$Excel-Macros$$ Require Help Urgent

See if it helps.. Give both range to in input with in a worksheets.. you will get the difference http://excelpoweruser.blogspot.com/2011/08/if-you-want-to-match-data-between -two.html -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf

Re: $$Excel-Macros$$ Require Help Urgent

You need to be MUCH more specific on what you want with cell references and before/after examples. Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: ashjain2...@yahoo.co.in Sent: Thursday, December 29, 2011 10:15 AM To: excel-macros@googlegroups.com Subject

$$Excel-Macros$$ Best Wishes 2012

Dear Friends, Its just been a few months that I have become a member of this group, and I am really glad I am a member. Want to take this opportunity to wish each member of this group a very HAPPY NEW YEAR and request each and everyone to keep up the good work. I am hoping in 2012, we ll have more

RE: $$Excel-Macros$$ Lookup value by fulfill some condition in list

Try this: =INDEX($B$9:$C$14,MATCH("*"&B3,$B$9:$B$14,0),2) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Dec/Fri/2011 01:13 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup value by fulfill some condition in lis

RE: $$Excel-Macros$$ Lookup value by fulfill some condition in list

Try this : =OFFSET($B$9,MATCH("*"&B3,$B$9:$B$14,0),1,1,1) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Dec/Fri/2011 01:13 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup value by fulfill some condition in lis

RE: $$Excel-Macros$$ Lookup value by fulfill some condition in list

Try this: =VLOOKUP("*828",$B$9:$C$14,2,0) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Dec/Fri/2011 01:13 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup value by fulfill some condition in list One soluti

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

Wonderful solution Guillett, is it possible with formulas? Regards, Aamir Shahzad On Thu, Dec 29, 2011 at 7:33 PM, dguillett1 wrote: > Even simpler > > Option Explicit > Sub GetFinalDestinationSAS() > Dim c As Range > Dim start As String > Dim final As String > > Application.ScreenUpdating =

Re: $$Excel-Macros$$ Lookup value by fulfill some condition in list

One solution is attached. Regards, Aamir Shahzad On Thu, Dec 29, 2011 at 6:21 PM, Ashish Bhalara wrote: > Dear Experts, > > I need to use vlookup function to look value by fulfill some particular > condition. The example to understand the problem is attached herewith. > > Thanks & regards > > A

Re: $$Excel-Macros$$ Help

Hi Rajan, In excel sheet Year ( 1 ). 1987 & 1988 is Two Consecutive Year , So Answer will be One Time and ( 2 ). 2001 ; 2002 And 2003 is Three Consecutive Year , So Answer will be One Time.. i want Year to be display..In J8 Thanks Nikhil On Fri, Dec 30, 2011 at 12:43 AM, Rajan_Verma wrote: >

Re: $$Excel-Macros$$ Help

Dear Rajan Thanks ..Excellent Tips.. Its working..You are using Array Function.. Nikhil On Thu, Dec 29, 2011 at 6:32 PM, Rajan_Verma wrote: > Try this : > > ** ** > > =SUM(--(B2:B32<0)*--(B3:B33<0)) > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegro

RE: $$Excel-Macros$$ Require Help Urgent

We want to different between last and current month salaries.. And where is different Sent from my Nokia phone -Original Message- From: dguillett1 Sent: 28-12-2011 9:30:18 pm Subject: Re: $$Excel-Macros$$ Require Help Urgent You need to be MUCH more specific on what you want with cell

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

Hi Don, Thanks for your effort. On Thu, Dec 29, 2011 at 5:53 PM, Excel_Lover wrote: > Why? > > > On Thu, Dec 29, 2011 at 5:48 PM, dguillett1 wrote: > >> That’s good. I went back and tested mine. NOT good. >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >> >> *From:* Kris >>

$$Excel-Macros$$ Re: custom macro for email. Need to link excel to apple email.

Dear Members, Can anyone help me. regards, Roopesh Kapur On Dec 25, 4:37 pm, RK wrote: > Dear Group members, > > Below is the code that i have been using in windows based laptop to > connect MS excel to outlook. It takes the email address from a > predefined col G and sends a customized email t

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

Why? On Thu, Dec 29, 2011 at 5:48 PM, dguillett1 wrote: > That’s good. I went back and tested mine. NOT good. > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Kris > *Sent:* Thursday, December 29, 2011 8:06 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-

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

That’s good. I went back and tested mine. NOT good. Don Guillett SalesAid Software dguille...@gmail.com From: Kris Sent: Thursday, December 29, 2011 8:06 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: To Extract a text with Conditions Hi, Try this UDF. Function FINALDEST

$$Excel-Macros$$ Re: help

Hi This will work for up to 2 instances of ()...() =IF(LEN(A1)-LEN(SUBSTITUTE(A1,"(",""))=2,MID(A1,FIND("(",A1)+1,SUM(FIND({"(",")"},A1)*{-1,1})-1)&","&MID(A1,FIND("(",A1,FIND(")",A1)+1)+1,SUM(FIND({"(",")"},A1,FIND(")",A1)+1)*{-1,1})-1),MID(A1,FIND("(",A1)+1,SUM(FIND({"(",")"},A1)*{-1,1})-1)) K

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

Hi, Try this UDF Function COLOUR(ByRef R As Range) As String COLOUR = "Enter this Color in the UDF list" Select Case R.Interior.ColorIndex Case 6: COLOUR = "Yellow" Case 14: COLOUR = "Green" Case 3: COLOUR = "Red" End Select End Function and use

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

Even simpler Option Explicit Sub GetFinalDestinationSAS() Dim c As Range Dim start As String Dim final As String Application.ScreenUpdating = False For Each c In Range("a6:a" & Cells(Rows.Count, 1).End(xlUp).Row) start = Left(c, 3) If Not InStr(4, c, start) Then final = Right(c, 3) If InStr(8, c

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

One way. Save your file as .xls or .xlsM to allow macros. Option Explicit Sub GetFinalDestinationSAS() Dim c As Range Dim start As String Dim final As String Application.ScreenUpdating = False For Each c In Range("a6:a" & Cells(Rows.Count, 1).End(xlUp).Row) start = Left(c, 3) If Not InStr(4, c,

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

Works Great, Thank you very much. On Thu, Dec 29, 2011 at 5:06 PM, Kris wrote: > Hi, > > Try this UDF. > > Function FINALDEST(ByRef v) As String > > Dim x, i As Long > > If TypeOf v Is Range Then v = v.Value2 > > x = Split(v, "-") > > With CreateObject("scripting.dictionary") >

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

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 code if necessary. Private Sub Worksheet_Change(ByVal Target As Range) Const ProductNam

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

Hi, Try this UDF. Function FINALDEST(ByRef v) As String Dim x, i As Long If TypeOf v Is Range Then v = v.Value2 x = Split(v, "-") With CreateObject("scripting.dictionary") .comparemode = 1 For i = 0 To UBound(x) If Len(x(i)) Then

$$Excel-Macros$$ Re: Lookup value by fulfill some condition in list

Hi, Use wildcard. =VLOOKUP("*"&B3,B9:C14,2,FALSE) 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 not get quick attention or m

$$Excel-Macros$$ Excel & VBA Jobs (US only)

Hi, Please check and bookmark this link for MS Excel, Access & VBA Jobs. http://jobs.openexcel.com *Best Regards* *Photographer**, Odd Lens Blogger, eXceLiTems.com Traveler, MastWeekend.com Developer, OpenExceL.com (Excel Add-in

Re: $$Excel-Macros$$ Hyperlink to Highlight weekly data

my cursor should automatically go on the data on next sheet On Thu, Dec 29, 2011 at 7:05 PM, dguillett1 wrote: > I don’t understand your request. “it should highlight” > examples > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* lucky singh > *Sent:* Thursday, December

Re: $$Excel-Macros$$ Hyperlink to Highlight weekly data

I don’t understand your request. “it should highlight” examples Don Guillett SalesAid Software dguille...@gmail.com From: lucky singh Sent: Thursday, December 29, 2011 3:59 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Hyperlink to Highlight weekly data Dear Team, Attached

$$Excel-Macros$$ Lookup value by fulfill some condition in list

Dear Experts, I need to use vlookup function to look value by fulfill some particular condition. The example to understand the problem is attached herewith. Thanks & regards Ashish Bhalara -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

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

Send a file with a complete explanation and examples Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: chhajersand...@gmail.com Sent: Thursday, December 29, 2011 6:25 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Auto create of sheet with n

RE: $$Excel-Macros$$ Help

Try this =SUMPRODUCT(--(B2:B32<0),--(B3:B33<0)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Nikhil Shah Sent: Dec/Wed/2011 10:14 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Dear Friend, I want to find out Consecutive Nega

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

Dear excel advisor, I want a macro which create a sheet automatically if I add a new product name in a particular sheet with the name of the new product. And also want a condition validation which restrict user from inserting duplicate name where I insert the new product name. Thanking you in

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

Hi Experts, Can somebody help me to extract a text called 'Final Destination' from the string. Attached is a sample sheet with query. Thanks & Regards, Faisal. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please He

Re: $$Excel-Macros$$ dob

Datedif doest not appear in function list but its exist in Excel.. Thanks On Thu, Dec 29, 2011 at 1:55 AM, Maries wrote: > http://www.cpearson.com/excel/datedif.aspx > > > On Thu, Dec 29, 2011 at 12:09 AM, Aamir Shahzad > wrote: > >> Dear Rajan, >> >> Perhaps there is no function "datedif" ava