Re: $$Excel-Macros$$ to pickup only require number or word

pfa On Tue, Jun 13, 2017 at 6:27 PM, wrote: > > Respected All, > > please help me to separate the require number or word in excel,means how > can i separate of pick the numbers or alphabet which only i need.for the > example i am attaching the excel sheet > > -- > Are you =EXP(E:RT) or =NOT(EXP(

Re: $$Excel-Macros$$ to add - sign in vehical number

thank so much for help me now its easy for me, once again thanks a lot. On Tue, Feb 21, 2017 at 5:49 PM, Paul Schreiner wrote: > Its simple enough to determine the last 4 characters using the right() > function. > But because the length varies (from 7 to 11), you need to be a bit more > "cre

Re: $$Excel-Macros$$ to add - sign in vehical number

On Tue, 2/21/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ to add - sign in vehical number To: "excel-macros@googlegroups.com" Date: Tuesday, February 21, 2017, 2:19 PM Its simple enough to determine the last 4 characters

Re: $$Excel-Macros$$ to add - sign in vehical number

Its simple enough to determine the last 4 characters using the right() function.But because the length varies (from 7 to 11), you need to be a bit more "creative" with the left() function. try inserting a column with:=LEFT(F3,LEN(F3)-4)&"-"&RIGHT(F3,4) copy to all rows, then copy/paste Values to

Re: $$Excel-Macros$$ To seek help on writing Excel formula

Hi Kindly note that the match operation is to be performed basis the variable "dataset" in "Sheet1" and Variable_sheet2 in "Sheet1" should be populated using "Sheet2". Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India

Re: $$Excel-Macros$$ To seek help on writing Excel formula

Is there any relation between both sheets? If yes you can use vlookup. It would be great if you can upload (attache) some sample data with your requirement -- On Fri, Sep 9, 2016 at 5:17 PM, Sandeep Kumar Baranwal < sandeepkumarbaran...@gmail.com> wrote: > Hi > > I have a spreadsheet with two t

Re: $$Excel-Macros$$ To Print .msg Files Saved in Folder

Where did the .msg files come from?By looking online, it sounds like .msg files COULD be: MSG is a file extension for a mail message file format used by Microsoft Outlook and Exchange.  An MSG file can contain plain ASCII text for the headers and the main message body as well as hyperlinks and

Re: $$Excel-Macros$$ to change cell value in Column A daily

Hi Paul, Thank you for your reply. Thanks a lot for your suggestion. I've changed to use another way for the time being. Hope you have a very nice day! Cheers On Thursday, 18 February 2016 20:59:51 UTC+8, Paul Schreiner wrote: > > "Without opening the file manually".. > I think there's a way

Re: $$Excel-Macros$$ to change cell value in Column A daily

"Without opening the file manually"..I think there's a way to do that, but from what I understand the technique still requires the excel file with the macro to be open. Instead, you can write macro that tests for the current date/time and changes  the cell when the file is opened.(it would then s

Re: $$Excel-Macros$$ To seek help on fuzzy text matching of list of 30000 text values from a list of 300000 text values

Hi Ashish Koul Do you have the excel template for the same? I think I will not be able to download it on my office laptop. Is there any way out to do the same? Thanks and regards Sandeep Kumar Baranwal > On Aug 14, 2015, at 10:39 PM, ashish koul wrote: > > download fuzzy match addin > http:

Re: $$Excel-Macros$$ To seek help on fuzzy text matching of list of 30000 text values from a list of 300000 text values

download fuzzy match addin http://www.microsoft.com/en-in/download/details.aspx?id=15011 On Fri, Aug 14, 2015 at 10:38 PM, wrote: > Hi > > Could anyone help me in performing fuzzy text matching of a list of 3 > text values from a list of 30 text values? > If you have a spreadsheet templa

Re: $$Excel-Macros$$ To Select a Pivot Item

Dear Faisal, Can u pls elborate more detail? I unable to understand your requirement. Regards, Gawli Anil On Sat, Mar 14, 2015 at 3:34 PM, Faisal Pk wrote: > Can anybody help me with a solution. > > Regards, > Faisal PK > > On Fri, Mar 13, 2015 at 11:04 AM, Faisal Pk wrote: > >> I have the b

Re: $$Excel-Macros$$ To Select a Pivot Item

Can anybody help me with a solution. Regards, Faisal PK On Fri, Mar 13, 2015 at 11:04 AM, Faisal Pk wrote: > I have the below code to select an item from the Pivotfield "Customer". > > Request if anybody can help with a code which don't loop through each item > because it leads slow performance

Re: $$Excel-Macros$$ To find ADO object reference

Hi check this.. http://stackoverflow.com/questions/9879825/how-to-add-a-reference-programmatically-vba-excel do let us know for further help... Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 9, 2014 at 7:25 PM, Eugene Bernard wrote: > How to f

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

Thank you everyone. On Fri, Nov 14, 2014 at 5:42 PM, Ashish Kumar wrote: > Hi Pravin, > > PFA!! > > > Edit your data in Pending CN and Highlight the row which you want to paste > in Party Wise and hit the macro. > > > > Regards > Ashish > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

r you can.” - John Wesley - > > From: Pravin Gunjal >To: excel-macros@googlegroups.com >Sent: Friday, November 14, 2014 2:07 AM >Subject: Re: $$Excel-Macros$$ To create a sheet with macro and overwri

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

Hi Pravin, PFA!! Edit your data in Pending CN and Highlight the row which you want to paste in Party Wise and hit the macro. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

*Hi Paul :* If I add this code in my code it creates new sheet and deletes immediately. Pl look in to this. *Hi Ashish :* Your file is creating new sheet every time but I want the same sheet to be overwritten with changes. Thank you, On Thu, Nov 13, 2014 at 7:46 PM, Ashish Kumar wrote: > Hi P

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

Hi Pravin, PFA.!! Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

why not simply delete the sheet if it exists? add this to your code before you copy the sheet: On Error Resume Next Application.DisplayAlerts = False Sheets("Party Wise").Delete Application.DisplayAlerts = True On Error GoTo 0 '-- P

Re: $$Excel-Macros$$ To one digit calculation

please share the sample sheet . Enjoy Team XLS On Thu, Nov 28, 2013 at 8:53 PM, Kongsambath PEN wrote: > Hi there, > > Hi, > > Please help me out in excel to find functions in the result cell following > by calculation. > > >

Re: $$Excel-Macros$$ To Share and View Excel Dashboards.

It can be possible through Google Drive or Sky Drive. On 26 October 2013 17:22, Excel_Lover wrote: > Dear All, > > What is the best way to share and View the excel dashboard online. > > Basically, We have one excel dashboard which we send by e-mail on > updation. What I need is an alternate sol

Re: $$Excel-Macros$$ To Share and View Excel Dashboards.

try this http://office.microsoft.com/en-in/sharepoint-server-help/introduction-to-excel-services-and-excel-web-access-HA010105476.aspx http://msdn.microsoft.com/en-us/library/ms572330(v=office.14).aspx http://blogs.msdn.com/b/mvpawardprogram/archive/2012/05/21/embedded-excel-services-on-your-websit

Re: $$Excel-Macros$$ to

Visit below group link http://groups.google.com/group/excel-macros. and click on "Apply to joingroup" . Enjoy Team XLS On Sat, Sep 28, 2013 at 10:41 AM, TIWARI wrote: > dear Sir, > How can make new member of excel-macros groups. > > -- > Are you =EXP(E:RT) or =NOT

Re: $$Excel-Macros$$ To SUM Dynamic Columns

Dear Excel_Lover, it is exactly in attachment you are asking for. Regards, Waseem Saifi On Sat, Jul 20, 2013 at 2:12 PM, Waseem Saifi wrote: > Dear Excel_Lover, > > PFA your query file with solved formula. > > Regards, > Waseem Saifi > > On 7/19/13, Excel_Lover wrote: > > Dear All, > > > > At

Re: $$Excel-Macros$$ To SUM Dynamic Columns

Dear Excel_Lover, PFA your query file with solved formula. Regards, Waseem Saifi On 7/19/13, Excel_Lover wrote: > Dear All, > > Attached is a sample data in which I have some month wise item total, I > need a formula which can calculate SUM of an item from the Month Jan-12 to > till the month w

Re: $$Excel-Macros$$ To SUM Dynamic Columns

ll the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - > >From: Excel_Lover >To: excel-macros@googlegroups.com >Sent: Friday, July 19, 2013 8:29 AM

Re: $$Excel-Macros$$ To SUM Dynamic Columns

ou can, >> In all the ways you can, >> In all the places you can, >> At all the times you can, >> To all the people you can, >> As long as ever you can.” - John Wesley >> *--------- >> >>*From:* Excel_Lover >> *

Re: $$Excel-Macros$$ To SUM Dynamic Columns

can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > *From:* Excel_Lover > *To:* excel-macros@googlegroups.com > *Sent:* Friday, July 19, 2013 8:12 AM > *Subject:* Re: $$Excel-Macros$$ To SUM Dyn

Re: $$Excel-Macros$$ To SUM Dynamic Columns

esley - > >From: Excel_Lover >To: excel-macros@googlegroups.com >Sent: Friday, July 19, 2013 8:12 AM >Subject: Re: $$Excel-Macros$$ To SUM Dynamic Columns > > > >Dear Mr.Deepak, > > >Thanks for a quick reply, your formula works fine but it's

Re: $$Excel-Macros$$ To SUM Dynamic Columns

Here's my answer: =SUM(INDIRECT(ADDRESS(ROW(),8) & ":" & ADDRESS(ROW(),MATCH($D$1,$H$1:$Z$1)+7)))   Here's my logic: You want to use the =SUM() function to calculate the total for the current row from column H1 through the column described in D1.   For Jun-12, the SUM() function would look like: =S

Re: $$Excel-Macros$$ To SUM Dynamic Columns

Dear Mr.Deepak, Thanks for a quick reply, your formula works fine but it's not considering the items (A,B,C,D etc), it should also be a criteria because its order may vary. Hope it needed a formula like SUMIF which provides SUM by multiple criteria. Thanks again.. On Fri, Jul 19, 2013 at 2:58

Re: $$Excel-Macros$$ To SUM Dynamic Columns

On Fri, Jul 19, 2013 at 5:05 PM, Excel_Lover wrote: > Dear All, > > Attached is a sample data in which I have some month wise item total, I > need a formula which can calculate SUM of an item from the Month Jan-12 to > till the month which we are selecting in the column D1. > > Appreciate if som

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

est. >> >>> >> >>> On 7/6/13, ravinder negi wrote: >> >>> > PFAtry this and advise if this does not work propery.. you just >> >>> > need >> >>> to >> >>> > copy paste formula in validation rng

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

ose will be also add in list...but your second sheet data should >> > formated as given by you. >> > >> > --- On Sat, 7/6/13, Mangesh Vimay wrote: >> > >> > From: Mangesh Vimay >> > Subject: Re: $$Excel-Macros$$ To create drop down list for ma

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

re > data > > and those will be also add in list...but your second sheet data should > > formated as given by you. > > > > --- On Sat, 7/6/13, Mangesh Vimay wrote: > > > > From: Mangesh Vimay > > Subject: Re: $$Excel-Macros$$ To create drop down li

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

e: > > From: Mangesh Vimay > Subject: Re: $$Excel-Macros$$ To create drop down list for many IDs as per > many lists > To: excel-macros@googlegroups.com > Date: Saturday, July 6, 2013, 11:20 AM > > Hi Be Tran Van, > > Thank you for your quick help. > > Howev

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Simply Great !!! Could you please share final workbook. Sorry, for this. Thanks a ton !!! On 7/6/13, vba wrote: > Hi > > You dont have to create name, this will be created programatically for data > in DATA sheet. > > Just copy paste B2 or drag down. > > > Hoe Name is created by this Macro: >

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hi You dont have to create name, this will be created programatically for data in DATA sheet. Just copy paste B2 or drag down. Hoe Name is created by this Macro: First Data sheet is sort on the basis of ID; then unique ID is pasted in range J2 & downwards. Then Name is defined for each ID begi

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hi, Thanks for the help. But, how to create data validations in the first sheet based on the list which you have retrieved by using code. Please help. On 7/6/13, vba wrote: > Hey > > PFA. > > HTH > > > On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay > wrote: > >> Hi Be Tran Van, >> >> Thank you

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hey PFA. HTH On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay wrote: > Hi Be Tran Van, > > Thank you for your quick help. > > However, in my original workbook there are total 1200 lists and its > quite time consuming job to create named range for all 1200 lists and > then to specify the source f

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hi Be Tran Van, Thank you for your quick help. However, in my original workbook there are total 1200 lists and its quite time consuming job to create named range for all 1200 lists and then to specify the source for all the lists for data validations. Could you please suggest shortcut way/method

Re: $$Excel-Macros$$ To count values in a changeble range

Since its focising on sheet1 you got to delete that part... Just put hyphen before the line and before end with line. You may simply delete it also. Hth Vabs On 28 Jun 2013 22:47, "Thiago Souza" wrote: > I'm trying to make it work on the workbook for all sheets, I pasted as you > say and didnt

Re: $$Excel-Macros$$ To count values in a changeble range

I'm trying to make it work on the workbook for all sheets, I pasted as you say and didnt work. So i tried to change With ThisWorkbook.Worksheets("sheet1") for With ThisWokbook.ActiveSheet or With ActiveWorkbook.ActiveSheet, neither of them worked. I dont want to run it on a module where I hav

Re: $$Excel-Macros$$ To count values in a changeble range

Fastest way to learn is try to learn from queries posted here in forum. I have learned VBA thru forum participation. Thanks for Acknowledgement. You can paste code in This workbook so as to get result in all sheet. Alternatively, you can also use in standard module where you have to run this cod

Re: $$Excel-Macros$$ To count values in a changeble range

Very nice, Thank You. I would never get there. I only know the basic programming language for fortran from eng. School. How do I learn VBA like that? Any book you recommend? Backing to work, I made the total days dont count the blank cells, for now everything is perfect. Thank ou so much for your

Re: $$Excel-Macros$$ To Add Comments based on Cell Value

Hi Ashish, Thank you very much. Works fine, saved lot of time. Thanks. On Mon, Dec 17, 2012 at 7:11 PM, ashish koul wrote: > Sub add_comment() > Dim i As Long > Dim x As String, found As Range > Dim j As Long, k As Long > > For i = 2 To Sheets("Clients").Range("a1").End(xlDown).Row > Se

Re: $$Excel-Macros$$ To Add Comments based on Cell Value

Sub add_comment() Dim i As Long Dim x As String, found As Range Dim j As Long, k As Long For i = 2 To Sheets("Clients").Range("a1").End(xlDown).Row Set found = Sheets("Details").Range("a:a").Find(Sheets("Clients").Cells(i, 1).Value, LookIn:=xlValues) If Not found Is Nothing Then j

Re: $$Excel-Macros$$ To The Group Owner

yes i agree with deepak Please don't banned job posting. On Thu, May 31, 2012 at 12:15 PM, Deepak Pal Singh < deepaktheind...@gmail.com> wrote: > Hi Ayush, > > Rather than banning all job posts you can ban repetitive job posts, > because these job posts really help the group members to find goo

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Hi Sub kTest() Dim r As Range, s As String s = [c1].Text Set r = Range("c2:c" & Range("d" & Rows.Count).End(3).Row) With r .Cells(1).Offset(-1) = 0 .FormulaR1C1 = "=IF(R[-1]C[2]<>RC[2],R[-1]C+1,IF(COUNTIF(R2C5:RC[2],RC[2])>5,R[-1]C+1,IF(AND(RC[2]=

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Sent:* Monday, May 07, 2012 1:18 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ To create a serial number based on some > conditions using macro. > > ** ** > > It should be assigned to a button. > > On Mon, May 7, 2012 at 10:4

RE: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Will the list already be sorted when the button is pressed? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Excel_Lover Sent: Monday, May 07, 2012 1:18 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To create a serial number based on

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

; *Sent:* Monday, May 07, 2012 6:48 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ To create a serial number based on some > conditions using macro. > > ** ** > > Dear Mr.Noorain, > > > > Please find the attached sheet with more clarific

RE: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

acros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Excel_Lover Sent: Monday, May 07, 2012 6:48 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro. Dear Mr.Noorain, Please find the attached

RE: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

-macros@googlegroups.com] On Behalf Of Excel_Lover Sent: 08 May 2012 12:57 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro. Dear Rajan, Thanks for your effort, I was seeking for a macro solution for this. How is

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Dear Rajan, Thanks for your effort, I was seeking for a macro solution for this. How is it possible, please let me know. Thanks, On Mon, May 7, 2012 at 8:13 PM, Rajan_Verma wrote: > Hi > > ** ** > > Please find the attached File > > ** ** > > *=IF(OR(COUNTIF($C$1:C2,C2)>=5,E3<>E2),C2

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Yes Mr. Excel_Lover, Please provide more clarification. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, May 7, 2012 at 2:50 AM, Excel_Lover wrote: > Dear All, > > Appreciate an help to write a macro to create a request number as per the > bel

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Was my question not clear? On Mon, May 7, 2012 at 12:20 AM, Excel_Lover wrote: > Dear All, > > Appreciate an help to write a macro to create a request number as per the > below condition. > > for each name on the same date should be a same request number, but should > not be repeated more than

RE: $$Excel-Macros$$ to remove time

See the attached sheet.. There are three solution and I think yellow one best. Provided by xlstime. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Apr/Thu/2012 10:10 To: excel-macros@googlegroups.com Subject: Re: $$Excel

Re: $$Excel-Macros$$ to remove time

Not much info but you can probably change the format. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Thursday, April 05, 2012 10:54 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ to remove time Hi , 12/2/2001 12:00 PM

Re: $$Excel-Macros$$ to remove time

HI Vijay, You can use very simple formula '=int(your date) Int is basically use for Rounds a number down to the nearest integer. On Thu, Apr 5, 2012 at 9:24 PM, vijayajith VA wrote: > Hi , > > 12/2/2001 12:00 PM --- How to remove time ? i need only date .. is > thr any formula ..Th

Re: $$Excel-Macros$$ to remove time

Thanks Noorain ... & Mareshwaran On Thu, Apr 5, 2012 at 9:36 PM, NOORAIN ANSARI wrote: > Dear Vijay, > > Please try it..after selection the required range.. > > Sub remove_Time() > Dim mycell As Range > For Each mycell In Selection > if vba.isdate(mycell) then > mycell.Value = VBA.Left(mycell, VB

Re: $$Excel-Macros$$ to remove time

Dear Vijay, Please try it..after selection the required range.. Sub remove_Time() Dim mycell As Range For Each mycell In Selection if vba.isdate(mycell) then mycell.Value = VBA.Left(mycell, VBA.InStr(1, mycell, " ") - 1) Selection.NumberFormat = "m/d/" endif Next End Sub On Thu, Apr 5, 20

Re: $$Excel-Macros$$ to remove time

*Try it, =TEXT(INT(A1),"DD/MM/")* On Thu, Apr 5, 2012 at 7:54 PM, vijayajith VA wrote: > Hi , > > 12/2/2001 12:00 PM --- How to remove time ? i need only date .. > is thr any formula ..Thanks in advance > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use conci

Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

Dear Pawel, yes, this is what i m looking for, thanks for your help~[?] 2012/4/3 pawel lupinski > I realy don't know what are you looking for so check if this is what you > are looking for. > > Regards, > > Pawel > > *From:* Darwin Chan > *To:* excel-macros@googlegroups.com > *Sent:* Tuesd

Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

I realy don't know what are you looking for so check if this is what you are looking for.   Regards,   Pawel From: Darwin Chan To: excel-macros@googlegroups.com Sent: Tuesday, April 3, 2012 12:02 PM Subject: $$Excel-Macros$$ To calculate the maximum and minimum

Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

Dear Darwin, Please find the attached file. {I am not understant exact wt you want in from time & please revert me with sample like count or sum total working hours ) Thanks & Regards Anil Kumar 113784 On Tue, Apr 3, 2012 at 4:32 PM, Darwin Chan wrote: > Dear all, > > I have a roster

RE: $$Excel-Macros$$ to access in Public Variable of Workbook A module by WorkBook B Procedure

ct.var module.var VBAProject.module.var Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Divaker Pandey Sent: Friday, March 02, 2012 2:11 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ to access in Public Variable of Wo

Re: $$Excel-Macros$$ to access in Public Variable of Workbook A module by WorkBook B Procedure

Still waiting for reply? On Thu, Mar 1, 2012 at 4:47 PM, Divaker Pandey wrote: > > Hi Expert, > > Is there any way to access in Public Variable of Workbook A module by > WorkBook B Procedure. > > if I can't do any modification in Workbook A macros. > > > Thanks in addvance > > -- > FORUM RULES

Re: $$Excel-Macros$$ To excel macro team

Btw, taking a bath or a shower every single minutes is such a waste!!! even every day, in poor countries or our grand-parents from the country side were more clean than what we can think we are today with less water. I don't take a shower every single day if I had a 'quiet' day, just a soda can vo

Re: $$Excel-Macros$$ To excel macro team

Hi Pascal, Check your group membership setting ( go to edit my membership (* https://groups.google.com/group/excel-macros/subscribe?hl=en* ))... On Thu, Feb 2, 2012 at 3:18 AM, Pascal Baro wrote: > Hi, > I'm not receiving mail summary from group posting anymore. Is there

Re: $$Excel-Macros$$ To excel macro team

Dear Pascal, Check below link.. http://www.discussexcel.com/contact-me On Thu, Feb 2, 2012 at 3:18 AM, Pascal Baro wrote: > Hi, > I'm not receiving mail summary from group posting anymore. Is there any > reasons? > Regards, > Pascal > > -- > FORUM RULES (986+ members already BANNED for violati

Re: $$Excel-Macros$$ To excel macro team

why, u want an invit? On Feb 1, 10:12 pm, "dguillett1" wrote: > Did you bathe today. > > Don Guillett > SalesAid Software > dguille...@gmail.com > > From: Pascal Baro > Sent: Wednesday, February 01, 2012 3:48 PM > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ To excel macro team >

Re: $$Excel-Macros$$ To excel macro team

Did you bathe today. Don Guillett SalesAid Software dguille...@gmail.com From: Pascal Baro Sent: Wednesday, February 01, 2012 3:48 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ To excel macro team Hi, I'm not receiving mail summary from group posting anymore. Is there any rea

Re: $$Excel-Macros$$ To List some Values

Attachment missing On Mon, Jan 23, 2012 at 11:33 AM, Excel_Lover wrote: > Dear All, > > Good Morning !!! > > Appreciate your help on the query of below attached sheet. > > Thanks in advance. > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread ti

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

Thanks Kris, it works fine On Mon, Jan 2, 2012 at 7:09 AM, Kris wrote: > In that case my UDF would be > > *Dim dic As Object > Function FINALDEST(ByRef v) As String > > Dim x, i As Long > > If TypeOf v Is Range Then v = v.Value2 > > x = Split(v, "-") > > If dic Is Nothing The

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

Hi Haseeb, Great, I could not expect a solution by formula for this. awesome! On Mon, Jan 2, 2012 at 5:45 AM, Haseeb Avarakkan wrote: > Hello Faisal & Evey one, > > This is what my understanding, > > *If any code repeats after a dest, just before this code consider as > final dest.* > >

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

In that case my UDF would be *Dim dic As Object Function FINALDEST(ByRef v) As String Dim x, i As Long If TypeOf v Is Range Then v = v.Value2 x = Split(v, "-") If dic Is Nothing Then Set dic = CreateObject("scripting.dictionary") With dic

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

Hello Faisal & Evey one, This is what my understanding, *If any code repeats after a dest, just before this code consider as final dest.* Eg: Row 101. DMS-BAH-AUH-CGK-AUH-DMM AUH repeats after CGK, so final dest, CGK. Row 109, DMS-BAH-DAM-BAH-DMM BAH repeat after DAM, so final dest, DAM

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

s.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kris Sent: Dec/Sat/2011 02:56 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To Extract a text with Conditions Hi Rajan, The route are different. DMS-BAH and BAH-DMM Kris -- FORUM RULES (934+ members alr

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

Yes.. this is the logic.. and it is making it bit complicated.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kris Sent: Dec/Sat/2011 02:56 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To Extract a text with Conditions Hi Rajan

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

Hi Rajan, The route are different. DMS-BAH and BAH-DMM 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

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

) then result should be HYD From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kris Sent: Dec/Sat/2011 02:44 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To Extract a text with Conditions What's the logic of last destination D

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

What's the logic of last destination DAM in DMS-BAH-DAM-BAH-DMM ? -- 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 atten

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

l_Lover > *Sent:* Dec/Sat/2011 01:00 > > *To:* excel-macros@googlegroups.com > *Subject:* 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

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

: Dec/Sat/2011 01:00 To: excel-macros@googlegroups.com Subject: 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&#x

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

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

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

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

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$$ 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$$ To remove the character "*" from the cells with a date in it.

Dear Tan,   Find “*” with suffix one or two character and replace only selected suffix   Like find “09*” and replace with “09” Regards LAKSHMAN   From: tan dennis To: excel-macros@googlegroups.com Sent: Friday, 9 December 2011 5:16 PM Subject: $$Excel-Macros$$

Re: $$Excel-Macros$$ To remove the character "*" from the cells with a date in it.

Hi Tan Try : Sub Mtest() Cells.replace What:="~*", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False End Sub *special character must be precede by “~” when you use find & replace option * Formula : Assuming Date with special c

Re: $$Excel-Macros$$ To remove the character "*" from the cells with a date in it.

Just select the columns ( D & E ) desired and use edit>replace ~* with (leave BLANK) Don Guillett SalesAid Software dguille...@gmail.com From: tan dennis Sent: Friday, December 09, 2011 5:46 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ To remove the character "*

  1   2   >