Re: $$Excel-Macros$$ Only MID Function........

=IF(MID(A2,4,2)="10",0,"10 is not in middle") On Tue, Aug 28, 2012 at 11:54 AM, ravinder negi wrote: > Here is the solution. > > --- On *Sun, 8/26/12, Kuldeep Singh * wrote: > > > From: Kuldeep Singh > Subject: $$Excel-Macros$$ Only MID Function > To: excel-macros@googlegroups.com > Date

Re: $$Excel-Macros$$ Only MID Function........

Dear Chandra, That's not a date format. it's showing only confusion. this is a text only. Regards, Kuldeep Singh On Tue, Aug 28, 2012 at 11:54 AM, ravinder negi wrote: > Here is the solution. > > --- On *Sun, 8/26/12, Kuldeep Singh * wrote: > > > From: Kuldeep Singh > Subject: $$Excel-Macros$$

Re: $$Excel-Macros$$ Only MID Function........

Here is the solution. --- On Sun, 8/26/12, Kuldeep Singh wrote: From: Kuldeep Singh Subject: $$Excel-Macros$$ Only MID Function To: excel-macros@googlegroups.com Date: Sunday, August 26, 2012, 1:07 PM Hi Experts, Extract "10" from the reference numbers by using MID Function, if "10" i

Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

Dear Hilary, I want to make dashboard for share accounting and calculations for income tax. Kindly help me for the same. Thanks & Regards, KSAGAR On Mon, Aug 27, 2012 at 5:40 PM, NOORAIN ANSARI wrote: > Nice Creativity HilaryThanks to sharing with us. > > On Fri, Aug 24, 2012 at

Fwd: $$Excel-Macros$$ VBA code for automatic published (Outlook) report save to Given Folder Path

Can Anybody help me -- Forwarded message -- From: amar takale Date: Sat, Aug 25, 2012 at 12:47 PM Subject: $$Excel-Macros$$ VBA code for automatic published (Outlook) report save to Given Folder Path To: excel-macros@googlegroups.com Hi All VBA Experts, This is very Challenging

Re: $$Excel-Macros$$ Request for networkdays formula

dear cute, please try it, first change ur formar in mm/dd/ format =NETWORKDAYS(DATEVALUE(MID(B4,FIND("/",B4,1)+1,1)&"/"&LEFT(B4,1)&"/"&RIGHT(B4,4)),TODAY()) On Mon, Aug 27, 2012 at 10:34 PM, Cute Awesome wrote: > > -- > Join official facebook page of this forum @ > https://www.facebook.com

Re: $$Excel-Macros$$ lookup formula

Dear Noorain, Thank you very much. M Solaiyappan On Mon, Aug 27, 2012 at 2:18 PM, NOORAIN ANSARI wrote: > Dear Solaiya, > > Please find attached study material for basic VBA. > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.com

Re: $$Excel-Macros$$ lookup formula

Dear Noorain, Thank^^^ you very much. M Solaiyappan On Mon, Aug 27, 2012 at 2:18 PM, NOORAIN ANSARI wrote: > Dear Solaiya, > > Please find attached study material for basic VBA. > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.com

$$Excel-Macros$$ Request for networkdays formula

-- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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 n

$$Excel-Macros$$ Re: Required a search option in excel file

Hi Praveen, Please see the attachment hope this will help you. regards prince On Monday, August 27, 2012 3:02:48 PM UTC+5:30, Pravin Gunjal wrote: > > Hello Friends, > > Need a help on the following issue. > > 1. I am having a file containing 318 products / rates in it. (file is > attached f

$$Excel-Macros$$ Re: Change row color to Yellow, Then Hide Row

Hi Dick, Hope this help you. Sub Test() Dim rng As Range Dim ClAs Range With ThisWorkbook.Worksheets("Sheet1") Set rng = .Range("H1:H" & .Range("H" & .Rows.Count).End(xlUp).Row) For Each Cl In rng If Cl.Value > 1 Then Cl.Interior.Color = vbYellow Cl.Ent

$$Excel-Macros$$ NETWORKDAYS Formula for NON-BUSINESS HOURS

Greetings, I am trying to figure out a formula that will give me the amount of *NON-*business hours (*7PM to 6AM M-F*, and *Saturday and Sunday* are the non-business hours) *between* a *start date and time* and an *end date and time*. Below is an example: End Time = 8/20/2012 10:47 Start Time

$$Excel-Macros$$ Re: Number of Non Business Hours Formula Needed

End Time = 8/20/2012 10:47 Start Time = 8/1/2012 10:47 I need to know the amount of hours between the 2 dayes that WERE NOT business hours, meaning the amount of hours on the weekend plus between 7pm and 6am. The result needs to be in hours, or hh:mm:ss format preferably. On Monday, August 27,

$$Excel-Macros$$ Re: Number of Non Business Hours Formula Needed

Hi LJ, Do you want the result in hrs OR in days, because ur format is in mm-dd-yy hh:mm:ss. So please explain ur question with an example. regards prince On Monday, August 27, 2012 7:59:11 PM UTC+5:30, LJ wrote: > > Greetings, > > I am trying to figure out a formula that will give me the amo

Re: $$Excel-Macros$$ Sheet To WB

Dear Amresh, Thanks for sending nice VBA Code, but i think your code will create city wise worksheet instead of workbook. Mr. Krishna want vba code to create city wise workbook. -- With Regards, Noorain Ansari http:// noorainansari.com

$$Excel-Macros$$ Number of Non Business Hours Formula Needed

Greetings, I am trying to figure out a formula that will give me the amount of *NON-*business hours (*7PM to 6AM M-F*, and *Saturday and Sunday* are the non-business hours) *between* a *start date and time* and an *end date and time*. The cells have the following information with a MM-DD-

$$Excel-Macros$$ Baler Software

Please don't ban me (I won't do it again) but I have this that someone may want badly. If you don't know what it is you probably wouldn't be interested. Contact off list ONLY Baler xe ver 1.0 ser 741095 complete Baler Ice 1.0 960455 Visual Baler Baler xe 2.0 books Don Guillett Microsoft Excel De

Re: $$Excel-Macros$$ Sheet To WB

welcome...!.. and for merge the split data in single sheet as same format.. use this code. Sub mergesheet() If ThisWorkbook.Worksheets(1).Name = "abc" Then Application.DisplayAlerts = False ThisWorkbook.Worksheets("abc").Delete Application.DisplayAlerts = False ThisWorkbook.Worksheets.Add(befor

RE: $$Excel-Macros$$ Sheet To WB

Thanks Amresh I will check this. Thanks for your valuable time. Regards, Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EPIP Area, Whitefield Bangalore - 560 066. India. Direct Line: +1.800.920.9657 Extn 1915 Switchboard: +90-(0

Re: $$Excel-Macros$$ Sheet To WB

Hi, use this macros also ... hope help you. Sub nee() If ThisWorkbook.Worksheets.Count > 1 Then Sheets("master").Activate For i = 2 To ThisWorkbook.Worksheets.Count Application.DisplayAlerts = False ThisWorkbook.Worksheets(2).Delete Application.DisplayAlerts = True Next End If Application.Scre

Re: $$Excel-Macros$$ Task Total Time Formula

Hi You are calculating the daytime worktime. (Lets call it D2) could you use =B2-C2-D2? Regards David Grugeon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles

Re: $$Excel-Macros$$ Task Total Time Formula

Dear LJ, Can you share a sample workbook with us for more clarity. On Sun, Aug 26, 2012 at 11:51 PM, LJ wrote: > *Greetings!* > * > * > *I currently use the formula below to calculate the total time to > complete a task between 6AM and 7PM (13-hour workday). I need to reverse > the formula to c

RE: $$Excel-Macros$$ Sheet To WB

Hi Noorain, Thanks a lot. I will change this code as per my requirements. Regards, Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EPIP Area, Whitefield Bangalore - 560 066. India. Direct Line: +1.800.920.9657 Extn 1915 Switchboa

Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

Nice Creativity HilaryThanks to sharing with us. On Fri, Aug 24, 2012 at 8:08 PM, Hilary Lomotey wrote: > Hi Guys, > > i just completed an upgrade of my stock market dashboard, pls use as you > will. cheers > > -- > Join official facebook page of this forum @ > https://www.facebook.c

Re: $$Excel-Macros$$ You are gonna like it !!

Hi Rajan, Can you provide me link for the book " EXCEL Charts.and.Graphs" Please. Thanks. On Fri, Aug 24, 2012 at 11:28 PM, shashank bhosle < catchshashankbho...@yahoo.co.in> wrote: > Mind Freaking Rajan !!! Awesome!!! > >*From:* Rajan_Verma > *To:* excel-macros@googlegroups.com > *Sent:*

Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

Simply Awesome !!! On Sat, Aug 25, 2012 at 1:51 PM, amar takale wrote: > Hi Hilary > I used Excel 2003 So I tell you it is possible to see excel 2003. No > problem I will see it 2007. > Thanks > > > On Sat, Aug 25, 2012 at 1:40 PM, wrote: > >> ** >> Hi Amar >> >> I built the dashboard in 2007 a

Re: $$Excel-Macros$$ Sheet To WB

Dear Krishan, Please see attached workbook, I have created a compiler, which are creating workbook name wise. Hope it will help to you for your query. Please revert if it will not help to you. I will do it in your data On Mon, Aug 27, 2012 at 3:29 PM, Krishnaraddi V. Madolli < krishnaraddi.mad

Re: FW: $$Excel-Macros$$ resolve the problem

You are always welcome bro.. On Mon, Aug 27, 2012 at 5:22 PM, Neeraj wrote: > Thanks noorain. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* Monday, August 27, 2012 5:07 PM > > *To:* excel-macros@googlegr

RE: FW: $$Excel-Macros$$ resolve the problem

Thanks noorain. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Monday, August 27, 2012 5:07 PM To: excel-macros@googlegroups.com Subject: Re: FW: $$Excel-Macros$$ resolve the problem Dear Neeraj, Try below formula : =IF(COUNTIF

RE: FW: $$Excel-Macros$$ resolve the problem

Dear noorain, I don't want to change the colum min and mix. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Monday, August 27, 2012 4:04 PM To: excel-macros@googlegroups.com Subject: Re: FW: $$Excel-Macros$$ resolve the problem

Re: $$Excel-Macros$$ Change row color to Yellow, Then Hide Row

Dear Dick, Please consider it.. Sub color_hide() Dim sh As Worksheet Dim rng As Range Dim cell As Range Set sh = ThisWorkbook.Sheets(1) Set rng = sh.Range("H2:H" & sh.Cells(Rows.Count, "H").End(xlUp).Row) For Each cell In rng If cell.Value > 1 Then cell.Interior.Color = vbYellow cell.EntireRow.Hi

Re: $$Excel-Macros$$ Change row color to Yellow, Then Hide Row

Dear Dick, try it.. Sub color_hide() Dim sh As Worksheet Dim rng As Range Dim cell As Range Set sh = ThisWorkbook.Sheets(1) Set rng = sh.Range("A2:A" & sh.Cells(Rows.Count, "H").End(xlUp).Row) For Each cell In rng If cell.Value > 1 Then cell.Interior.Color = vbYellow cell.EntireRow.Hidden = True

Re: FW: $$Excel-Macros$$ resolve the problem

Noorin sir Can y send me this file in excel 2003 On Mon, Aug 27, 2012 at 4:03 PM, NOORAIN ANSARI wrote: > Dear Neeraj, > > See attached sheet, Hope it will help to you. > > > On Mon, Aug 27, 2012 at 3:23 PM, Neeraj wrote: > >> ** ** >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto

RE: $$Excel-Macros$$ Sheet To WB

I want data for only one city in one workbook for example in attached sheet, 4 city name data is present so I want 4 separate workbooks each contains data for only one city. Hence finally I will get 4 workbooks saved based on city name. Hope I explained better. Regards, Krishnaraddi V Madolli

Re: $$Excel-Macros$$ Sheet To WB

Dear Krishna, Please explain what you exact want. On Mon, Aug 27, 2012 at 3:29 PM, Krishnaraddi V. Madolli < krishnaraddi.mado...@asia.xchanging.com> wrote: > "CONFIDENTIALITY NOTICE: This message and any attachment are confidential > and may also be privileged. If you are not the intended recip

Re: $$Excel-Macros$$ Only MID Function........

Dear Kuldeep, Plz confirm that whether Data in column-A is Date or text. If it's Date then use bellow mentioned formula to exact 10, and if it's text then you should first change column A data in text formate to use MID formula to exact your desired text. =IF(MONTH(A2)=10,"10","0") On Sun, Aug 2