$$Excel-Macros$$ Transpose Query
Dear Members, I have one file for Transpose query but now i need this formula in reversal(opposite) condition...Data in sheet2 format and need to change in sheet1 format. Please guide me! -- *Sky* "Good, Better, Best! *Always listen to your heart, because there lives your parents.* -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Transpose.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date
Dear Paul, Pls revert, if you have time. On Mar 17, 2017 5:22 PM, "karleenbiggs via MS EXCEL AND VBA MACROS" < excel-macros@googlegroups.com> wrote: > > > On Fri, 3/17/17, karleenbiggs via MS EXCEL AND VBA MACROS < > excel-macros@googlegroups.com> wrote: > > Subject: Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly > basis as per date > To: excel-macros@googlegroups.com > Date: Friday, March 17, 2017, 1:50 PM > > > > On Fri, 3/17/17, karleenbiggs via MS EXCEL AND VBA MACROS > > wrote: > > Subject: Re: $$Excel-Macros$$ How to pick rental on > pro-rata/monthly basis as per date > To: excel-macros@googlegroups.com > Date: Friday, March 17, 2017, 11:41 AM > > > > On Fri, 3/17/17, derrickandrew994 via MS EXCEL AND VBA > MACROS > wrote: > >Subject: Re: $$Excel-Macros$$ How to pick rental on > pro-rata/monthly basis as per date >To: excel-macros@googlegroups.com > Date: Friday, March 17, 2017, 9:44 AM > > > >On Fri, 3/17/17, Sunil Kumar Yadav >wrote: > > Subject: Re: $$Excel-Macros$$ How to pick rental on >pro-rata/monthly basis as per date > To: excel-macros@googlegroups.com > Date: Friday, March 17, 2017, 9:17 AM > > Dear Paul, > > I want to > formula in one column not month-wise separately. > > Please guide > me! > > On Fri, Mar 17, 2017 at > 12:44 PM, Sunil Kumar Yadav > wrote: > Dear Team, > > I want to pick > rental pro-rata/monthly as per purchasing date. > > Pro-rata - > If purchasing date after 1st then rental will be >calculated > days-wise(count) > > monthly - If > purchasing date 1st then rental will be paid full. > > -- > Sky > > > "Good, Better, > Best!Always listen > to your heart, because there lives your > parents. > > > > > -- > > 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, > 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 question in the thread of another > member. > > 3) Don't post questions regarding breaking or > bypassing > any security measure. > > 4) Acknowledge the responses you receive, good or > bad. > > 5) Jobs posting is not allowed. > > 6) Sharing copyrighted material and their links is > not > allowed. > > > > NOTE : Don't ever post confidential data in a >workbook. > Forum owners and members are not responsible for any > loss. > > --- > > You received this message because you are subscribed > to >the > Google Groups "MS EXCEL AND VBA MACROS" group. > > To unsubscribe from this group and stop receiving > emails > from it, send an email to excel-macros+unsubscribe@ > googlegroups.com. > > To post to this group, send email to excel-macros@googlegroups.com. > > Visit this group at https://groups.google.com/ > group/excel-macros. > > For more options, visit https://groups.google.com/d/ > optout. > > > > > -- > Sky > > > "Good, Better, > Best!Always listen to > your heart, because there lives your > parents. > > > > > -- > > 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, > 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 question in the thread of another > member. > > 3) Don't post questions regarding breaking or > bypassing > any security measure. > > 4) Acknowledge the responses
Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date
Dear Paul, I want to formula in one column not month-wise separately. Please guide me! On Fri, Mar 17, 2017 at 12:44 PM, Sunil Kumar Yadav wrote: > Dear Team, > > I want to pick rental pro-rata/monthly as per purchasing date. > > Pro-rata - If purchasing date after 1st then rental will be calculated > days-wise(count) > > monthly - If purchasing date 1st then rental will be paid full. > > -- > *Sky* > "Good, Better, Best! > *Always listen to your heart, because there lives your parents.* > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- *Sky* "Good, Better, Best! *Always listen to your heart, because there lives your parents.* -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date
Dear Team, I want to pick rental pro-rata/monthly as per purchasing date. Pro-rata - If purchasing date after 1st then rental will be calculated days-wise(count) monthly - If purchasing date 1st then rental will be paid full. -- *Sky* "Good, Better, Best! *Always listen to your heart, because there lives your parents.* -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Formula.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers
Thank you so much it's working perfectly:)
On Mar 13, 2017 6:34 PM, "Paul Schreiner" wrote:
> What I would do is first load your "Roll No." values into a Dictionary
> object.
> Then, loop through your "S.No." values and look to see if they are in the
> Dictionary.
> Report the missing values.
> Like:
>
> Sub Find_Missing()
> Dim Dict_SN, SN
> Dim nRows, nRow, drow
> Set Dict_SN = CreateObject("Scripting.Dictionary")
> Dict_SN.RemoveAll
>
> nRows = Range("A1").SpecialCells(xlLastCell).Row
>
> ' Load Dictionary
> For nRow = 2 To nRows
> SN = Trim(ActiveSheet.Cells(nRow, "B").Value)
> If (SN & "X" <> "X") Then
> If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN, nRow
> End If
> Next nRow
>
> ActiveSheet.Range("C2:C65000").ClearContents
> drow = 1
>
> For nRow = 2 To nRows
> SN = Trim(ActiveSheet.Cells(nRow, "A").Value)
> If (SN & "X" <> "X") Then
> If (Not Dict_SN.exists(SN)) Then
> drow = drow + 1
> ActiveSheet.Cells(drow, "C").Value = SN
> End If
> End If
> Next nRow
> End Sub
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you 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*
> -
>
>
> On Sunday, March 12, 2017 1:23 AM, Sunil Kumar Yadav <
> sk.yadav7...@gmail.com> wrote:
>
>
> Dear Paul,
>
> I have need your help for this query. Please guide me.
>
> --
> *Sky*
> "Good, Better, Best!
> *Always listen to your heart, because there lives your parents.*
> --
> 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, 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 question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> 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, 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 question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
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 of
$$Excel-Macros$$ How to pick numbers which are missing in serial numbers
Dear Paul, I have need your help for this query. Please guide me. -- *Sky* "Good, Better, Best! *Always listen to your heart, because there lives your parents.* -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. How to pick numbers which are missing in serial numbers.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month
Thank you so much paul it's almost working correctly as per my requirement😊 On Mar 6, 2017 7:39 PM, "Paul Schreiner" wrote: Please take a closer look at my long-winded explanation. I was merely trying to explain how your "static" formula using Today() was inefficient and why. I then went on to suggest that you use (in cell B5) the formula: =IF(YEAR(A5-15) <> YEAR(TODAY()),0, MONTH(A5-15)*1.5) I also said that for your second question (rounding values to .5 increments) can be done with: =INT(A23*2)/2 My explanations get kind-of long, because I prefer to TEACH the reasons why instead of simply handing over answers. *Paul* - *“Do all the good you can,By all the means you 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* - On Saturday, March 4, 2017 12:10 AM, Sunil Kumar Yadav < sk.yadav7...@gmail.com> wrote: Dear Paul, Thank you so much for your support but I don't have need formula calculation start from today. It should be start from my provided date...pls recheck that time my file i am sure you will be got my query. On Mar 4, 2017 1:58 AM, "Paul Schreiner" wrote: First of all, your IF() statement: A nested if statement will evaluate each section until it finds a true() option. So, in the first case: IF(TODAY()<=42750 evaluates false, that means today is > 42750 So the second part: IF(AND(TODAY()>=42751 HAS to be true, so there's no reason to test it! Your IF statement could be simplified to: IF(TODAY()<=42750,0, IF(TODAY()<=42781,1.5, IF(TODAY()<=42809,3, IF(TODAY()<=42840,4.5, IF(TODAY()<=42870,6, IF(TODAY()<=42901,7.5, IF(TODAY()<=42931,9, IF(TODAY()<=42962,10.5, IF(TODAY()<=42993,12, IF(TODAY()<=43023,13.5, IF(TODAY()<=43054,15, IF(TODAY()<=43084,16.5, IF(TODAY()>=43085,18,0 ) But, you can simplify it even more. You're using the 15th of the month as the "break point". So, if you were to subtract 15 days, you'd be in the "same" month if the day is > 15, and the PREVIOUS month if it is before the 15th. Basically, by subtracting 15, you're setting the "break point" as the first of the month. So, if you determine the month number: (MONTH(A5-15)) you could say you want 1.5 for each month, or: MONTH(A6-15) * 15 Now, the issue is with the first half of January. subtracting 15 makes it December of the PREVIOUS year, and therefore should be 0 instead of 18. so, you need to check to see if the offset year is the same as the current year: =IF(YEAR(A5-15) <> YEAR(TODAY()),0, MONTH(A5-15)* 1.5) This seems match the same as your sample values for rows 5-9, but I'm not sure what you were doing with rows 12-16 Why does 16-Mar in row 8 result in 4.5, but 16-Mar in row 13 is supposed to be 1.5 ??? I'm not sure what the rules you're using here. as for your second query: You're basically wanting to round off your number to the nearest 1/2. You can accomplish this by first doubling the number and removing the decimal portion (extract just the integer portion) then divide it by 2: =INT(A23*2)/2 this works for your samples. hope this helps. *Paul* -- --- *“Do all the good you can,By all the means you 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*-- --- On Friday, March 3, 2017 12:08 PM, Sunil Kumar Yadav wrote: Dear All, I have two query for automatically update value on one fixed date, have created formula but need dynamic formula. Formula: IF(TODAY()<=42750,0,IF(AND( TODAY()>=42751,TODAY()<=42781) ,1.5,IF(AND(TODAY()>=42782, TODAY()<=42809),3,IF(AND( TODAY()>=42810,TODAY()<=42840) ,4.5,IF(AND(TODAY()>=42841, TODAY()<=42870),6,IF(AND( TODAY()>=42871,TODAY()<=42901) ,7.5,IF(AND(TODAY()>=42902, TODAY()<=42931),9,IF(AND( TODAY()>=42932,TODAY()<=42962) ,10.5,IF(AND(TODAY()>=42963, TODAY()<=42993),12,IF(AND( TODAY()>=42994,TODAY()<=43023) ,13.5,IF(AND(TODAY()>=43024, TODAY()<=43054),15,IF(AND( TODAY()>=43055,TODAY()<=43084) ,16.5,IF(AND(TODAY()>=43085, TODAY()>=43085),18,0)) ))) Please check excel sheet...Thanks in advance for help! -- *Sky* "Good, Better, Best ! *Always listen to your heart* ** , because there lives your parents. -- 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 <https://www.facebook.com/discussexcel> FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,
Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month
Dear Paul, Thank you so much for your support but I don't have need formula calculation start from today. It should be start from my provided date...pls recheck that time my file i am sure you will be got my query. On Mar 4, 2017 1:58 AM, "Paul Schreiner" wrote: > First of all, your IF() statement: > A nested if statement will evaluate each section until it finds a true() > option. > So, in the first case: > IF(TODAY()<=42750 > evaluates false, that means today is > 42750 > So the second part: > IF(AND(TODAY()>=42751 HAS to be true, so there's no reason to test it! > Your IF statement could be simplified to: > IF(TODAY()<=42750,0, > IF(TODAY()<=42781,1.5, > IF(TODAY()<=42809,3, > IF(TODAY()<=42840,4.5, > IF(TODAY()<=42870,6, > IF(TODAY()<=42901,7.5, > IF(TODAY()<=42931,9, > IF(TODAY()<=42962,10.5, > IF(TODAY()<=42993,12, > IF(TODAY()<=43023,13.5, > IF(TODAY()<=43054,15, > IF(TODAY()<=43084,16.5, > IF(TODAY()>=43085,18,0) > > But, you can simplify it even more. > You're using the 15th of the month as the "break point". > So, if you were to subtract 15 days, you'd be in the "same" month if the > day is > 15, and the PREVIOUS month if it is before the 15th. > Basically, by subtracting 15, you're setting the "break point" as the > first of the month. > So, if you determine the month number: (MONTH(A5-15)) you could say you > want 1.5 for each month, or: > MONTH(A6-15) * 15 > Now, the issue is with the first half of January. > subtracting 15 makes it December of the PREVIOUS year, and therefore > should be 0 instead of 18. > > so, you need to check to see if the offset year is the same as the current > year: > =IF(YEAR(A5-15) <> YEAR(TODAY()),0, MONTH(A5-15)*1.5) > > This seems match the same as your sample values for rows 5-9, > but I'm not sure what you were doing with rows 12-16 > Why does 16-Mar in row 8 result in 4.5, but 16-Mar in row 13 is supposed > to be 1.5 ??? > I'm not sure what the rules you're using here. > > as for your second query: > > You're basically wanting to round off your number to the nearest 1/2. > You can accomplish this by first doubling the number and removing the > decimal portion > (extract just the integer portion) > then divide it by 2: > =INT(A23*2)/2 > > this works for your samples. > > hope this helps. > > > > *Paul* > --------- > > > > > > > > *“Do all the good you can,By all the means you 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* > - > > > On Friday, March 3, 2017 12:08 PM, Sunil Kumar Yadav < > sk.yadav7...@gmail.com> wrote: > > > Dear All, > > I have two query for automatically update value on one fixed date, have > created formula but need dynamic formula. > > Formula: > IF(TODAY()<=42750,0,IF(AND(TODAY()>=42751,TODAY()<=42781) > ,1.5,IF(AND(TODAY()>=42782,TODAY()<=42809),3,IF(AND( > TODAY()>=42810,TODAY()<=42840),4.5,IF(AND(TODAY()>=42841, > TODAY()<=42870),6,IF(AND(TODAY()>=42871,TODAY()<=42901) > ,7.5,IF(AND(TODAY()>=42902,TODAY()<=42931),9,IF(AND( > TODAY()>=42932,TODAY()<=42962),10.5,IF(AND(TODAY()>=42963, > TODAY()<=42993),12,IF(AND(TODAY()>=42994,TODAY()<=43023) > ,13.5,IF(AND(TODAY()>=43024,TODAY()<=43054),15,IF(AND( > TODAY()>=43055,TODAY()<=43084),16.5,IF(AND(TODAY()>=43085, > TODAY()>=43085),18,0) > > Please check excel sheet...Thanks in advance for help! > > -- > *Sky* > "Good, Better, Best > ! > *Always listen to your heart* > *, because there lives your parents.* > > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners
$$Excel-Macros$$ How to make dynamic formula for value change on fix date every month
Dear All, I have two query for automatically update value on one fixed date, have created formula but need dynamic formula. Formula: IF(TODAY()<=42750,0,IF(AND(TODAY()>=42751,TODAY()<=42781),1.5,IF(AND(TODAY()>=42782,TODAY()<=42809),3,IF(AND(TODAY()>=42810,TODAY()<=42840),4.5,IF(AND(TODAY()>=42841,TODAY()<=42870),6,IF(AND(TODAY()>=42871,TODAY()<=42901),7.5,IF(AND(TODAY()>=42902,TODAY()<=42931),9,IF(AND(TODAY()>=42932,TODAY()<=42962),10.5,IF(AND(TODAY()>=42963,TODAY()<=42993),12,IF(AND(TODAY()>=42994,TODAY()<=43023),13.5,IF(AND(TODAY()>=43024,TODAY()<=43054),15,IF(AND(TODAY()>=43055,TODAY()<=43084),16.5,IF(AND(TODAY()>=43085,TODAY()>=43085),18,0) Please check excel sheet...Thanks in advance for help! -- *Sky* "Good, Better, Best ! *Always listen to your heart* *, because there lives your parents.* -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Query.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ copy paste issue from one sheet to another
check it...maybe this is helpful...because i m also learner :-) On Fri, Feb 19, 2016 at 11:43 AM, Kat wrote: > Hi guys, > > I would like to copy paste entire row from king sheet to queen sheet if > the cells in range "B2:B" has the value of "update" in king sheet. However, > I have copy area and paste area not same size error. May I know how can I > solve this? Can anyone help? Thanks in advance. > > > Cheers > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- *Sky* "Good, Better, Best! Never let it rest, Til your good is better and your better is best." - *St. Jerome* -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. test.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Re: How can I add 2-6 characters to the front of numbers based ONLY on how long the number is?
U can use this but formula is very long:
Blank cell will be blank!
IF(B1="","",IF(6<=LEN(B1),B1,IF(LEN(REPT("1",6))<=LEN(B1),0,"AB")&REPT("0",(7-LEN(B1)-2))&B1))
On Thu, Feb 18, 2016 at 6:25 PM, Paul Schreiner
wrote:
> If you REALLY want to shorten your formula:
>
> the =concatenate() function is a "throwback" to earlier versions of excel
> and only included for "backward compatibility".
>
> "technically", these two are the same thing:
> =CONCATENATE("AB",TEXT(I2,"0"))
> ="AB" & TEXT(I2,"0")
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you 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*
> -
>
>
> On Wednesday, February 17, 2016 10:29 PM, Paul Bevins <
> paul.bevins...@gmail.com> wrote:
>
>
>
> I added both formulas to the sheet.
> Is there a way to get this done using VB, so I can leave the cells blank
> and have this occur?
>
> On Wednesday, February 10, 2016 at 4:27:58 PM UTC-8, Paul Bevins wrote:
>
> Hi, I've got an odd problem.
>
> I have a database of some 15000 numbers.
>
> 10,000 of them (roughly), go from 1 to 10,000.
> Another 5,000 go from 1,000,000 to 2,000,000.
>
> However, the numbers SHOULD AB1 to AB1.
>
> I need to be able to type the root number in and have Excel decide what it
> needs:
>
> 1 = AB1 (7 digits)
> 22 = AB00022 (7 digits)
> 333 = AB00333 (7 digits)
> =AB0 (7 digits)
> 1 = AB1 (7 digits) (excusing that this number won't exist above
> 10,000, but five digits.)
> 11 = 11 (6 digits)
> 22 = 22 (same length at 6 digits)
>
> I have searched around quite a bit, but have been unable to find the terms
> to search for to get these answers.
> I'm beginning to think I'll need to do it with a VBA script, but am open
> to any simple method of doing it, since I type these numbers dozens of
> times a day,
>
> Anyone have any ideas?
>
> Thanks in advance for any help
>
> Paul
>
> 1733
> --
> 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, 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 question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> 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, 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 question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
*Sky*
"Good, Better, Best!
Never let it rest, Til your good is better and your better is best." - *St.
Jerome*
--
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
Re: $$Excel-Macros$$ Re: Enabling VB cobe to change cell format with protected sheet format. Excel 2007
No thank you…I'm also learner! On Mon, Oct 26, 2015 at 6:10 PM, Gary Dinges wrote: > Thank You Sir! > > Gary > > On Friday, October 23, 2015 at 2:47:17 PM UTC-4, Gary Dinges wrote: > >> I will start by saying I did search group looking for answer to my issue, >> but didn't find, or understand what I needed. >> >> I am working on a form that will be distributed to remote plant >> locations. It has VB code to change color of cells & check boxes to >> highlight selected cells. >> >> The cells in the 2 plant location rows are at issue. >> >> Issue I am having is when sheet is protected, the format change conflicts >> with protection settings. >> >> 1st sheet of file attached. File is unprotected and works as intended now. >> >> Thank You, >> >> *Gary Dinges* | Mechanical Design Engineer II | Probes & New Product >> Development >> *Emerson Climate Technologies* | Therm-O-Disc, Inc.| 1320 South Main >> Street | Mansfield | OH | 44907 | USA >> T +1 419 525 8554 >> >> -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- *Sky* "Good, Better, Best! Never let it rest, Til your good is better and your better is best." - *St. Jerome* -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Require formula to find the count targeted till date
Hello, Please check enclosed file. -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Tue, Jul 28, 2015 at 1:13 AM, raghu wrote: > Hi All > > We have planned some execution of test cases daily. I would like to have > the test conditions planned till date in a cell. For example in the > attached sheet for reference > > we have dates from D2:V2 and corresponding test cases planned under each > date for Sub process. > > Now if we take today date as 7/30/2015 for subarea (APA in cell b3) the > planned conditions till date is 38 (i.e. D2+E2+F2+G2) > > I would like to have the this data automatically reflected in C2 cell. > > Can any one help me with a formula macros for the same > > Regards > Raghu > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Datewise SUM(solved).xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Ribbon_Gallery_Items
Dear Mr. Ashish, Can u tell me what's wrong in my query? Thanks, Sunil Kr. Yadav Sent from my ASUS On 25-Jul-2015 5:35 pm, "Ashish Kumar" wrote: > Dear Sunil Kumar Yadav, > > Don't violating our group rules. Go thru our group rules once before > posting your queries. > > > Regards > Ashish Kumar > > > On Sunday, July 19, 2015 at 11:51:58 AM UTC+5:30, Sunil Kumar Yadav wrote: >> >> Hi Experts >> >> I need your little help...please check my file i want to call my sub >> processors for three stages...first for gmail, second yahoomail and third >> hotmail...but there is if condition not running as per my requirement. >> >> there is ribbon's coding generated automatically where i can't modify to >> coding. >> >> -- >> >> >> Thanks & Regards >> *Sunil Kumar Yadav* >> Skype ID: sunil.yadav7186 >> > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Ribbon_Gallery_Items
Thanks, Sunil Kr. Yadav Sent from my ASUS On 25-Jul-2015 5:35 pm, "Ashish Kumar" wrote: > Dear Sunil Kumar Yadav, > > Don't violating our group rules. Go thru our group rules once before > posting your queries. > > > Regards > Ashish Kumar > > > On Sunday, July 19, 2015 at 11:51:58 AM UTC+5:30, Sunil Kumar Yadav wrote: >> >> Hi Experts >> >> I need your little help...please check my file i want to call my sub >> processors for three stages...first for gmail, second yahoomail and third >> hotmail...but there is if condition not running as per my requirement. >> >> there is ribbon's coding generated automatically where i can't modify to >> coding. >> >> -- >> >> >> Thanks & Regards >> *Sunil Kumar Yadav* >> Skype ID: sunil.yadav7186 >> > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Ribbon_Gallery_Items
Hi Team, Please revert on this!!! -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Sun, Jul 19, 2015 at 11:51 AM, Sunil Kumar Yadav wrote: > Hi Experts > > I need your little help...please check my file i want to call my sub > processors for three stages...first for gmail, second yahoomail and third > hotmail...but there is if condition not running as per my requirement. > > there is ribbon's coding generated automatically where i can't modify to > coding. > > -- > > > Thanks & Regards > *Sunil Kumar Yadav* > Skype ID: sunil.yadav7186 > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Query in VBA
Hi Soumyendu, PDF -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Sat, Jul 11, 2015 at 8:48 AM, Soumyendu Paul wrote: > Dear All, > > My query for attached file When we select data from drop down A cursor to > move A6;when we select B from drop down cursor move down B13 > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Query.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ renaming of pdf files
Dear Siraj, Coding is absolutely fine need to just defined variables...Please check Dim line! and add "on error resume next" anywhere in coding for Error handling. Dear Mandeep Sir, i m also learner...Excellent Job sir! -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Sat, Jul 11, 2015 at 12:20 PM, Siraj Momin (BHOG) wrote: > Dear Sir, > > > > The attached file was posted on this group before for renaming of pdf > files, by mr. Mandeep Baluja but it is not working in my case > > What I want is first it should get the list of file from particular folder > then I will put new name against each file in excel sheet it should rename > accordingly > > Below is the snapshot of error > > > > > > > > > > Please do the needful to solve the problem. > > > > > > > > > > Regards, > > Siraj Momin > > > -- > *This email and any attachments to it may be confidential and are intended > solely for the use of the recipient(s). If you are not the intended > recipient of this email, you must neither take any action based upon its > content, nor copy or show it to anyone. Please contact the sender if you > believe you have received this email in error. Statements and opinions > expressed in this e-mail are those of the sender, and do not necessarily > reflect those of CCC unless explicitly so mentioned. FYI, CCC regularly > deploys anti-virus and malicious software protection, we however cannot > accept any liability for damage caused by any virus / error transmitted by > this email. * > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Rename_pdf_Files.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Web_Query_For_Mozilla
Dear Vaibhav Sir Please look into this matter! -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Sat, Jul 11, 2015 at 12:45 PM, Sunil Kumar Yadav wrote: > Hello Team, > > i have created gmail login query only for example but now i want to run > this is query on Mozilla Firefox because my official ID works only on > Mozilla at office site...but i have no idea how to write what code for this! > > I have checked lots of site for this query but result is 0, Please guide > me any coding for this so that i can run my ID on Mozilla. > > -- > Thanks & Regards > *Sunil Kumar Yadav* > Skype ID: sunil.yadav7186 > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Web_Query_For_Mozilla
Hello Team, i have created gmail login query only for example but now i want to run this is query on Mozilla Firefox because my official ID works only on Mozilla at office site...but i have no idea how to write what code for this! I have checked lots of site for this query but result is 0, Please guide me any coding for this so that i can run my ID on Mozilla. -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Web_Query.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Change the date in required format in macro and store in variable
Welcome! -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Fri, Jul 10, 2015 at 12:14 PM, Ganesh N wrote: > Thanks bro > > Regards, > GN > > On Thu, Jul 9, 2015 at 1:45 PM, Sunil Kumar Yadav > wrote: > >> PFA >> >> -- >> Thanks & Regards >> *Sunil Kumar Yadav* >> Skype ID: sunil.yadav7186 >> >> On Thu, Jul 9, 2015 at 12:15 PM, Ganesh N wrote: >> >>> Dear team, >>> >>> Need a help on storing the date in the required format in macro. >>> >>> I can able to do but i showing the current date not the actual date. >>> >>> Please find the attached file for your reference. >>> >>> Thanks & Regards, >>> Ganesh N >>> >>> -- >>> 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, 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 question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> 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, 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 question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. &
Re: $$Excel-Macros$$ Change the date in required format in macro and store in variable
PFA -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Thu, Jul 9, 2015 at 12:15 PM, Ganesh N wrote: > Dear team, > > Need a help on storing the date in the required format in macro. > > I can able to do but i showing the current date not the actual date. > > Please find the attached file for your reference. > > Thanks & Regards, > Ganesh N > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. doubt.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
Re: $$Excel-Macros$$ Loop in filtered value by VBA
Thank you so muchnow it's working absolutely!!!
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Tue, Apr 28, 2015 at 2:52 PM, Mandeep Baluja
wrote:
> Sub Getvalues()
>
> Dim r As Range
> lr = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row
> Set Rng = Sheets("Sheet1").Range("B2:B" & lr)
>
>
> For Each cell In Rng
> If cell.Value Like "*LF*" Then
> cell.Offset(0, 1) = 0
> Else
> cell.Offset(0, 1) = 1
> End If
> Next
> On Error Resume Next
> Sheets("Sheet1").Range("$A$1:$B$16").AutoFilter Field:=2,
> Criteria1:="*LF*", Operator:=xlAnd
> Sheets("Sheet1").Range("A2:B" & lr).SpecialCells(xlCellTypeVisible).Copy
> Sheets("Lost").Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial
> Paste:=xlPasteAll
>
> Sheets("Sheet1").ShowAllData
>
> Sheets("Sheet1").Range("$A$1:$B$16").AutoFilter Field:=2,
> Criteria1:="<>*LF*", Operator:=xlAnd
> Sheets("Sheet1").Range("A2:B" & lr).SpecialCells(xlCellTypeVisible).Copy
> Sheets("State").Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial
> Paste:=xlPasteAll
> Sheets("Sheet1").ShowAllData
> Sheets("Sheet1").Activate
>
> End Sub
>
> On Tuesday, April 28, 2015 at 1:57:33 PM UTC+5:30, sk.yadav7186 wrote:
>>
>> Dear it's not working, please check the file...i have deleted the LF
>> records but coding is not doing copy and paste exactly correct location to
>> other data!!!
>>
>> You can check!!!
>>
>> i m sending you both filekindly give me one coding which will be work
>> on both data without error.
>>
>>
>> --
>> Thanks & Regards
>> *Sunil Kumar Yadav*
>> Skype ID: sunil.yadav7186
>>
>> On Mon, Apr 27, 2015 at 5:41 PM, Mandeep Baluja
>> wrote:
>>
>>> change activesheet to Sheets("sheet1")
>>>
>>>
>>> On Monday, April 27, 2015 at 5:41:00 PM UTC+5:30, Mandeep Baluja wrote:
>>>>
>>>> Sub Getvalues()
>>>>
>>>> Dim r As Range
>>>> lr = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row
>>>> Set Rng = ActiveSheet.Range("B2:B" & lr)
>>>>
>>>> For Each cell In Rng
>>>> If cell.Value Like "*LF*" Then
>>>> cell.Offset(0, 1) = 0
>>>> Else
>>>> cell.Offset(0, 1) = 1
>>>> End If
>>>> Next
>>>> On Error Resume Next
>>>> ActiveSheet.Range("$A$1:$B$16").AutoFilter Field:=2, Criteria1:="*LF*",
>>>> Operator:=xlAnd
>>>> ActiveSheet.Range("A2:B" & lr).SpecialCells(xlCellTypeVisible).Copy
>>>> Sheets("Lost").Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial
>>>> Paste:=xlPasteAll
>>>>
>>>> Sheets("Sheet1").ShowAllData
>>>> ActiveSheet.Range("$A$1:$B$16").AutoFilter Field:=2,
>>>> Criteria1:="<>*LF*", Operator:=xlAnd
>>>> ActiveSheet.Range("A2:B" & lr).SpecialCells(xlCellTypeVisible).Copy
>>>> Sheets("State").Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial
>>>> Paste:=xlPasteAll
>>>>
>>>> On Monday, April 27, 2015 at 5:23:18 PM UTC+5:30, sk.yadav7186 wrote:
>>>>>
>>>>> Dear Mandeep,
>>>>>
>>>>> I need to some modification in this, when no record of LF exist in
>>>>> this data then your query showing error and stop it but I want to go on
>>>>> next step(copy other data) without error or stop
>>>>>
>>>>> Please also check my coding!!!
>>>>>
>>>>>
>>>>> --
>>>>> Thanks & Regards
>>>>> *Sunil Kumar Yadav*
>>>>> Skype ID: sunil.yadav7186
>>>>>
>>>>> On Mon, Apr 27, 2015 at 3:20 PM, Sunil Kumar Yadav <
>>>>> sk.yad...@gmail.com> wrote:
>>>>>
>>>>>> Thank u so much
>>>>>>
>>>>>> it's working as per my requirement :-)
>>>>>>
>>>>>> --
>>>>>> Thanks & Regards
>>>>>> *Sunil Kumar Yadav*
>>>>>> Skype ID: sunil.yadav7186
>>>>>>
>>>>>> On Mon, Apr 27, 2015 at 3:12 PM, Mandeep Baluja
>>>>>> wrote:
>>>>
Re: $$Excel-Macros$$ Loop in filtered value by VBA
Dear it's not working, please check the file...i have deleted the LF
records but coding is not doing copy and paste exactly correct location to
other data!!!
You can check!!!
i m sending you both filekindly give me one coding which will be work
on both data without error.
--
Thanks & Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Mon, Apr 27, 2015 at 5:41 PM, Mandeep Baluja
wrote:
> change activesheet to Sheets("sheet1")
>
>
> On Monday, April 27, 2015 at 5:41:00 PM UTC+5:30, Mandeep Baluja wrote:
>>
>> Sub Getvalues()
>>
>> Dim r As Range
>> lr = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row
>> Set Rng = ActiveSheet.Range("B2:B" & lr)
>>
>> For Each cell In Rng
>> If cell.Value Like "*LF*" Then
>> cell.Offset(0, 1) = 0
>> Else
>> cell.Offset(0, 1) = 1
>> End If
>> Next
>> On Error Resume Next
>> ActiveSheet.Range("$A$1:$B$16").AutoFilter Field:=2, Criteria1:="*LF*",
>> Operator:=xlAnd
>> ActiveSheet.Range("A2:B" & lr).SpecialCells(xlCellTypeVisible).Copy
>> Sheets("Lost").Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial
>> Paste:=xlPasteAll
>>
>> Sheets("Sheet1").ShowAllData
>> ActiveSheet.Range("$A$1:$B$16").AutoFilter Field:=2, Criteria1:="<>*LF*",
>> Operator:=xlAnd
>> ActiveSheet.Range("A2:B" & lr).SpecialCells(xlCellTypeVisible).Copy
>> Sheets("State").Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial
>> Paste:=xlPasteAll
>>
>> On Monday, April 27, 2015 at 5:23:18 PM UTC+5:30, sk.yadav7186 wrote:
>>>
>>> Dear Mandeep,
>>>
>>> I need to some modification in this, when no record of LF exist in this
>>> data then your query showing error and stop it but I want to go on next
>>> step(copy other data) without error or stop
>>>
>>> Please also check my coding!!!
>>>
>>>
>>> --
>>> Thanks & Regards
>>> *Sunil Kumar Yadav*
>>> Skype ID: sunil.yadav7186
>>>
>>> On Mon, Apr 27, 2015 at 3:20 PM, Sunil Kumar Yadav
>>> wrote:
>>>
>>>> Thank u so much
>>>>
>>>> it's working as per my requirement :-)
>>>>
>>>> --
>>>> Thanks & Regards
>>>> *Sunil Kumar Yadav*
>>>> Skype ID: sunil.yadav7186
>>>>
>>>> On Mon, Apr 27, 2015 at 3:12 PM, Mandeep Baluja
>>>> wrote:
>>>>
>>>>> check this out code given
>>>>>
>>>>>
>>>>> Regards,
>>>>> Mandeep Baluja
>>>>>
>>>>> On Monday, April 27, 2015 at 12:42:08 PM UTC+5:30, sk.yadav7186 wrote:
>>>>>>
>>>>>> hi...pls any revert
>>>>>>
>>>>>> --
>>>>>> Thanks & Regards
>>>>>> *Sunil Kumar Yadav*
>>>>>> Skype ID: sunil.yadav7186
>>>>>>
>>>>>> On Sat, Apr 25, 2015 at 3:10 PM, Sunil Kumar Yadav <
>>>>>> sk.yad...@gmail.com> wrote:
>>>>>>
>>>>>>> My means sometimes LF invoice no. not exist in data that time my
>>>>>>> filter query got error bcoz filtered value blank i want to query go to
>>>>>>> next
>>>>>>> step for other invoices copy without any errorin simple words i
>>>>>>> want to
>>>>>>> run loop in many columns in same time only in filtered visible value!!!
>>>>>>>
>>>>>>> Thanks,
>>>>>>> Sunil Kr. Yadav
>>>>>>>
>>>>>>> Sent from my ASUS
>>>>>>> On 25-Apr-2015 12:17 pm, "Vaibhav Joshi" wrote:
>>>>>>>
>>>>>>>> hi
>>>>>>>>
>>>>>>>> What do you mean by "when sometime no record of LF found then other
>>>>>>>> data past on state sheet with error"??
>>>>>>>>
>>>>>>>> You mean no additional data found ?
>>>>>>>>
>>>>>>>> On Fri, Apr 24, 2015 at 7:35 PM, Sunil Kumar Yadav <
>>>>>>>> sk.yad...@gmail.com> wrote:
>>>>>>>>
>>>>>>>>> Dear Team,
>>>>>>>>>
>>>>>>>>> i have
Re: $$Excel-Macros$$ Loop in filtered value by VBA
Dear Mandeep, I need to some modification in this, when no record of LF exist in this data then your query showing error and stop it but I want to go on next step(copy other data) without error or stop Please also check my coding!!! -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Mon, Apr 27, 2015 at 3:20 PM, Sunil Kumar Yadav wrote: > Thank u so much > > it's working as per my requirement :-) > > -- > Thanks & Regards > *Sunil Kumar Yadav* > Skype ID: sunil.yadav7186 > > On Mon, Apr 27, 2015 at 3:12 PM, Mandeep Baluja > wrote: > >> check this out code given >> >> >> Regards, >> Mandeep Baluja >> >> On Monday, April 27, 2015 at 12:42:08 PM UTC+5:30, sk.yadav7186 wrote: >>> >>> hi...pls any revert >>> >>> -- >>> Thanks & Regards >>> *Sunil Kumar Yadav* >>> Skype ID: sunil.yadav7186 >>> >>> On Sat, Apr 25, 2015 at 3:10 PM, Sunil Kumar Yadav >>> wrote: >>> >>>> My means sometimes LF invoice no. not exist in data that time my >>>> filter query got error bcoz filtered value blank i want to query go to next >>>> step for other invoices copy without any errorin simple words i want to >>>> run loop in many columns in same time only in filtered visible value!!! >>>> >>>> Thanks, >>>> Sunil Kr. Yadav >>>> >>>> Sent from my ASUS >>>> On 25-Apr-2015 12:17 pm, "Vaibhav Joshi" wrote: >>>> >>>>> hi >>>>> >>>>> What do you mean by "when sometime no record of LF found then other >>>>> data past on state sheet with error"?? >>>>> >>>>> You mean no additional data found ? >>>>> >>>>> On Fri, Apr 24, 2015 at 7:35 PM, Sunil Kumar Yadav < >>>>> sk.yad...@gmail.com> wrote: >>>>> >>>>>> Dear Team, >>>>>> >>>>>> i have read this type query on many sites but not understand >>>>>> properly, please write the code in my file for my data!!! >>>>>> >>>>>> Example file enclosed >>>>>> >>>>>> Please help!!! >>>>>> >>>>>> -- >>>>>> Thanks & Regards >>>>>> *Sunil Kumar Yadav* >>>>>> Skype ID: sunil.yadav7186 >>>>>> >>>>>> -- >>>>>> 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, 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 question in the thread of another member. >>>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>>> measure. >>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>> 5) Jobs posting is not allowed. >>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>> >>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>>> and members are not responsible for any loss. >>>>>> --- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to excel-macros...@googlegroups.com. >>>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>> -- >>>>> 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 >&
Re: $$Excel-Macros$$ Loop in filtered value by VBA
Thank u so much it's working as per my requirement :-) -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Mon, Apr 27, 2015 at 3:12 PM, Mandeep Baluja wrote: > check this out code given > > > Regards, > Mandeep Baluja > > On Monday, April 27, 2015 at 12:42:08 PM UTC+5:30, sk.yadav7186 wrote: >> >> hi...pls any revert!!!! >> >> -- >> Thanks & Regards >> *Sunil Kumar Yadav* >> Skype ID: sunil.yadav7186 >> >> On Sat, Apr 25, 2015 at 3:10 PM, Sunil Kumar Yadav >> wrote: >> >>> My means sometimes LF invoice no. not exist in data that time my filter >>> query got error bcoz filtered value blank i want to query go to next step >>> for other invoices copy without any errorin simple words i want to run >>> loop in many columns in same time only in filtered visible value!!! >>> >>> Thanks, >>> Sunil Kr. Yadav >>> >>> Sent from my ASUS >>> On 25-Apr-2015 12:17 pm, "Vaibhav Joshi" wrote: >>> >>>> hi >>>> >>>> What do you mean by "when sometime no record of LF found then other >>>> data past on state sheet with error"?? >>>> >>>> You mean no additional data found ? >>>> >>>> On Fri, Apr 24, 2015 at 7:35 PM, Sunil Kumar Yadav >>> > wrote: >>>> >>>>> Dear Team, >>>>> >>>>> i have read this type query on many sites but not understand properly, >>>>> please write the code in my file for my data!!! >>>>> >>>>> Example file enclosed >>>>> >>>>> Please help!!! >>>>> >>>>> -- >>>>> Thanks & Regards >>>>> *Sunil Kumar Yadav* >>>>> Skype ID: sunil.yadav7186 >>>>> >>>>> -- >>>>> 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, 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 question in the thread of another member. >>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>> measure. >>>>> 4) Acknowledge the responses you receive, good or bad. >>>>> 5) Jobs posting is not allowed. >>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>> >>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>> and members are not responsible for any loss. >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to excel-macros...@googlegroups.com. >>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> -- >>>> 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, 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 question in the thread of another member. >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> 4) Acknowledge the responses you receive, good or bad. >>>> 5) Jobs posting is not allowed. >>>> 6) Sharing copyrighted material and their links is not allowed. >>>> >>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>> and members are not
Re: $$Excel-Macros$$ Loop in filtered value by VBA
hi...pls any revert -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Sat, Apr 25, 2015 at 3:10 PM, Sunil Kumar Yadav wrote: > My means sometimes LF invoice no. not exist in data that time my filter > query got error bcoz filtered value blank i want to query go to next step > for other invoices copy without any errorin simple words i want to run > loop in many columns in same time only in filtered visible value!!! > > Thanks, > Sunil Kr. Yadav > > Sent from my ASUS > On 25-Apr-2015 12:17 pm, "Vaibhav Joshi" wrote: > >> hi >> >> What do you mean by "when sometime no record of LF found then other data >> past on state sheet with error"?? >> >> You mean no additional data found ? >> >> On Fri, Apr 24, 2015 at 7:35 PM, Sunil Kumar Yadav < >> sk.yadav7...@gmail.com> wrote: >> >>> Dear Team, >>> >>> i have read this type query on many sites but not understand properly, >>> please write the code in my file for my data!!! >>> >>> Example file enclosed >>> >>> Please help!!! >>> >>> -- >>> Thanks & Regards >>> *Sunil Kumar Yadav* >>> Skype ID: sunil.yadav7186 >>> >>> -- >>> 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, 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 question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> 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, 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 question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Loop in filtered value by VBA
My means sometimes LF invoice no. not exist in data that time my filter query got error bcoz filtered value blank i want to query go to next step for other invoices copy without any errorin simple words i want to run loop in many columns in same time only in filtered visible value!!! Thanks, Sunil Kr. Yadav Sent from my ASUS On 25-Apr-2015 12:17 pm, "Vaibhav Joshi" wrote: > hi > > What do you mean by "when sometime no record of LF found then other data > past on state sheet with error"?? > > You mean no additional data found ? > > On Fri, Apr 24, 2015 at 7:35 PM, Sunil Kumar Yadav > wrote: > >> Dear Team, >> >> i have read this type query on many sites but not understand properly, >> please write the code in my file for my data!!! >> >> Example file enclosed >> >> Please help!!! >> >> -- >> Thanks & Regards >> *Sunil Kumar Yadav* >> Skype ID: sunil.yadav7186 >> >> -- >> 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, 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 question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Loop in filtered value by VBA
Dear Team, i have read this type query on many sites but not understand properly, please write the code in my file for my data!!! Example file enclosed Please help!!! -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Auto filter query.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ How to check a field and change highlight color if the cell value changes
Great Sir Thanks, Sunil Kr. Yadav Sent from my ASUS On 31-Mar-2015 1:36 pm, "Vaibhav Joshi" wrote: > Hi Bob, > > Check attachment, > > Copy formula from G2 & Select A2 to D12 ( or larger range) & goto > conditional formatting, select manage rules & select new rule, after that > select use formula to determine which cells to format..paste formula, click > format & select color you want to give... > > After that Copy formula from G1 follow same process.. > > Cheers!! > > On Tue, Mar 31, 2015 at 7:53 AM, Bob Engler > wrote: > >> >> >> >> >> >> field 1field >> 2field 3field 41x1235421x24367822x325997886b82938826212 >> b77374q11ccb273bs62g79fffppaa6w5qp99pl9fffddlsa52d >> 87s7rk27hwlr7le388w77wr15jjjfawf2f34ks4ks33m77k442uuaw87efield >> 1field 2field 3field 41x1235421x24367822x325997886b8293 >> 8826212b77374q11ccb273bs62g79fffppaa6w5qp99pl9fff >> ddlsa52d87s7rk27hwlr7le388w77wr15jjjfawf2f34ks4ks33m77k442 >> uuaw87e >> >> The top is the sheet before doing what I need. the bottom is what I need >> to do. What I want is if field 2 (row 1 is header row) is the same, the row >> is highlighted the same. If field 2 is different from the one above it, the >> row is highlighted with a different color (alternating colors are fine on >> the changing row). The sheet is sorted on field 2. I normally do this >> manually but the Excel they just sent me has over 1,000 rows and most of >> the field 2s are non repeating. >> >> Thank you, >> >> Bob Engler >> >> -- >> 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, 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 question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for
Re: $$Excel-Macros$$ Query for If condition or VBA
Awesome Sir :-) and thanks -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Wed, Mar 25, 2015 at 2:13 PM, Vaibhav Joshi wrote: > check formula in col E, If there are more than 2 case of overlap then 1st > will be shown as ok & second will be as error. > > In case it is more than 2 case of overlap then 1st will be shown as ok & > rest all will be shown as error.. > > Cheers!! > > On Wed, Mar 25, 2015 at 2:01 PM, Vaibhav Joshi wrote: > >> can you explain one example.. >> >> On Wed, Mar 25, 2015 at 1:45 PM, Sunil Kumar Yadav < >> sk.yadav7...@gmail.com> wrote: >> >>> Hello, >>> >>> Please solve this query!!! >>> >>> -- >>> Thanks & Regards >>> *Sunil Kumar Yadav* >>> * Sr. Executive - *MIS (Billing Deptt.) >>> Skype ID: sunil.yadav7186 >>> >>> On Tue, Mar 24, 2015 at 5:27 PM, Sunil Kumar Yadav < >>> sk.yadav7...@gmail.com> wrote: >>> >>>> Dear >>>> Team, >>>> >>>> PFA file and check my query. >>>> >>>> >>>> -- >>>> Thanks & Regards >>>> *Sunil Kumar Yadav* >>>> Skype ID: sunil.yadav7186 >>>> >>>> -- >>>> 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, 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 question in the thread of another member. >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> 4) Acknowledge the responses you receive, good or bad. >>>> 5) Jobs posting is not allowed. >>>> 6) Sharing copyrighted material and their links is not allowed. >>>> >>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>> and members are not responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "MS EXCEL AND VBA MACROS" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to excel-macros+unsubscr...@googlegroups.com. >>>> To post to this group, send email to excel-macros@googlegroups.com. >>>> Visit this group at http://groups.google.com/group/excel-macros. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >>> 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, 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 question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> > -- > 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 conci
Re: $$Excel-Macros$$ Query for If condition or VBA
Hello, Please solve this query!!! -- Thanks & Regards *Sunil Kumar Yadav* * Sr. Executive - *MIS (Billing Deptt.) Skype ID: sunil.yadav7186 On Tue, Mar 24, 2015 at 5:27 PM, Sunil Kumar Yadav wrote: > Dear > Team, > > PFA file and check my query. > > > -- > Thanks & Regards > *Sunil Kumar Yadav* > Skype ID: sunil.yadav7186 > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Query for If condition or VBA
Dear Team, PFA file and check my query. -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. QUERY1.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Choose Formula
Nice :-)
On Mon, Feb 9, 2015 at 7:43 PM, Vaibhav Joshi wrote:
> FYI choose formula:
>
>
> =CHOOSE(Month,'Attn. Sheet.xlsx'!Jan,'Attn. Sheet.xlsx'!Feb,'Attn.
> Sheet.xlsx'!Mar,'Attn. Sheet.xlsx'!Apr,'Attn. Sheet.xlsx'!May,'Attn.
> Sheet.xlsx'!Jun,'Attn. Sheet.xlsx'!Jul,'Attn. Sheet.xlsx'!Aug,'Attn.
> Sheet.xlsx'!Sep,'Attn. Sheet.xlsx'!Oct,'Attn. Sheet.xlsx'!Nov,'Attn.
> Sheet.xlsx'!Dec)
>
> Cheers!!
>
> On Mon, Feb 9, 2015 at 7:14 PM, Sunil Kumar Yadav
> wrote:
>
>> Good sir :-) and Thank you
>>
>> Sunil
>>
>> On Mon, Feb 9, 2015 at 3:40 PM, Vaibhav Joshi wrote:
>>
>>> Hi
>>>
>>> Use this array formula instead=:
>>>
>>> =INDIRECT("'Attn. Sheet.xlsx'!"&TEXT(DATE($B$1,Month,1),"MMM"))
>>>
>>> check att..
>>>
>>>
>>> Cheers!!
>>>
>>> On Mon, Feb 9, 2015 at 1:52 PM, Sunil Kumar Yadav <
>>> sk.yadav7...@gmail.com> wrote:
>>>
>>>> Dear Experts,
>>>>
>>>> I want to know, what can i use choose formula in this file for get the
>>>> date 1 2 3 etc.
>>>>
>>>> --
>>>> Thanks & Regards
>>>> Sunil Kumar Yadav
>>>>
>>>> --
>>>> 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, 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 question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> Visit this group at http://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>> --
>>> 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, 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 question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> 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 Fac
Re: $$Excel-Macros$$ Choose Formula
Good sir :-) and Thank you
Sunil
On Mon, Feb 9, 2015 at 3:40 PM, Vaibhav Joshi wrote:
> Hi
>
> Use this array formula instead=:
>
> =INDIRECT("'Attn. Sheet.xlsx'!"&TEXT(DATE($B$1,Month,1),"MMM"))
>
> check att..
>
>
> Cheers!!
>
> On Mon, Feb 9, 2015 at 1:52 PM, Sunil Kumar Yadav
> wrote:
>
>> Dear Experts,
>>
>> I want to know, what can i use choose formula in this file for get the
>> date 1 2 3 etc.
>>
>> --
>> Thanks & Regards
>> Sunil Kumar Yadav
>>
>> --
>> 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, 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 question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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, 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 question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
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, 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 question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Choose Formula
Dear Experts, I want to know, what can i use choose formula in this file for get the date 1 2 3 etc. -- Thanks & Regards Sunil Kumar Yadav -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Attn. Sheet.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Re: Introduce Yourself !!
Hi Myself Sunil Yadav from Delhi. I'm a Sr. MIS Executive in Telecom Sector and recently learned VBA. Excel is my passion i want to learn more and more things about excel and thanks to Vaibhav Sir and Mr. Ashish who guide me everytime when i ask any query! -- Thanks & Regards Sunil Kumar Yadav Sr. Executive - MIS (Billing Deptt.) +91-9560128057 On Wed, Feb 4, 2015 at 12:12 PM, Vaibhav Joshi wrote: > Hi > > good to see you noel... > > Cheers!! > > On Wed, Feb 4, 2015 at 4:12 AM, sss1008 > wrote: > >> Hi I'm Noel from the Philippines. I'm a computer programmer. I'd been >> doing projects VBA for Access and Excel. I'm glad to be part of this >> forum. >> >> On Friday, June 8, 2012 at 3:21:59 PM UTC-4, Ayush Jain wrote: >>> >>> Hey all new and current posters, >>> >>> Welcome to excel group,one of the largest online community of excel Fans! >>> >>> I hope you enjoy your time here & find this forum to be a friendly and >>> knowledgeable community. Please feel free to post a small introduction, a >>> friendly hello or tell us a bit about yourself. Why not tell us where are >>> you from, what you do, what your interests are, how old you are, which is >>> your favourite excel site or blog is or anything else that comes to mind! >>> >>> Thanks for your time >>> Ayush Jain >>> Group Manager >>> Microsoft MVP >>> >> -- >> 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, 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 question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measu
$$Excel-Macros$$ multi range query in chart
Hello Dears, i have checked many chart of Mr. Chandoo...he used two or three range in series value in one series in selected data source...i mean please look below snapshot. i want to know how i can select similiarly range in my data...i use window 2007. Please!!! [image: Inline image 1] -- Thanks *Sunil Kumar Yadav* -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Loop to check duplicate value
Ok Sorry next time i will keep in my mind.
On Mon, Feb 2, 2015 at 5:30 PM, Vaibhav Joshi wrote:
> Dear Ashish Bhalara
>
> What exactly you are doing, can you pl explain..
>
> On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara
> wrote:
>
>> Dear experts,
>>
>> Below code is not work to check duplicate value, please know me problem
>> in code.
>>
>> For q = 5 To 1000
>> If Worksheets("BankData").Cells(q, 4).Value =
>> Worksheets("NewEntry").Cells(7, 2).Value Then
>> MsgBox "Account number already exist", vbOKOnly, "Ashish"
>> Exit Sub
>> End If
>> q = q + 1
>>
>> Next q
>>
>>
>> Regards.
>> Ashish Bhalara
>> 9624111822
>> P*Please do not print this email unless it is absolutely necessary.
>> Spread environmental üawareness.♣♣♣*
>>
>> --
>> 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, 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 question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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, 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 question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
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, 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 question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Loop to check duplicate value
Hello Friends,
i have checked many chart of Mr. Chandoo...he used two or three range in
series value in one series in selected data source...i mean please look
below snapshot.
i want to know how i can select similiarly range in my data...i use window
2007.
Please!!!
[image: Inline image 1]
--
Thanks
*Sunil Kumar Yadav*
On Mon, Feb 2, 2015 at 4:44 PM, Ashish Bhalara
wrote:
> Dear experts,
>
> Below code is not work to check duplicate value, please know me problem in
> code.
>
> For q = 5 To 1000
> If Worksheets("BankData").Cells(q, 4).Value =
> Worksheets("NewEntry").Cells(7, 2).Value Then
> MsgBox "Account number already exist", vbOKOnly, "Ashish"
> Exit Sub
> End If
> q = q + 1
>
> Next q
>
>
> Regards.
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
> --
> 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, 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 question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
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, 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 question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Networkdays
Hi Ashish, i have downloaded this file from chandoo site and have understood everything how to created chart, table etc. but very little query i m not able to understand, when i click on box then color auto changed but where is write formula for this? Please tell me! On Fri, Jan 30, 2015 at 12:07 PM, Sunil Kumar Yadav wrote: > Hello Ashish, > > below formula is working same then why have you used MOD in your formula, > please little explain! > > INT(B3-A3)&IF(INT(B3-A3)=1," day, "," days, ")&HOUR(B3-A3)&" hours, > "&MINUTE(B3-A3)&" minutes" > > On Thu, Jan 29, 2015 at 1:38 PM, Ashish Kumar > wrote: > >> Thank you Vaibhav Bhai...!!! >> >> >> 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, 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 question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > > Thanks & Regards, > Sunil Kumar Yadav > -- Thanks & Regards, Sunil Kumar Yadav -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Color Require.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Networkdays
Hello Ashish, below formula is working same then why have you used MOD in your formula, please little explain! INT(B3-A3)&IF(INT(B3-A3)=1," day, "," days, ")&HOUR(B3-A3)&" hours, "&MINUTE(B3-A3)&" minutes" On Thu, Jan 29, 2015 at 1:38 PM, Ashish Kumar wrote: > Thank you Vaibhav Bhai...!!! > > > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Thanks & Regards, Sunil Kumar Yadav -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: How to Sort Data
Thank u Ashish ji, i got it as per your coding! On Wed, Jan 28, 2015 at 2:44 PM, Ashish Kumar wrote: > Hi Sachin, > > Which Msg. > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Thanks & Regards, Sunil Kumar Yadav -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: How to Sort Data
Dears, Can u guide me how it has been done, because i have checked file but in sort option is nothing new. On Wed, Jan 28, 2015 at 1:10 PM, Rahul Chavan wrote: > Hi Ashu, > PFA, > > On Tuesday, January 27, 2015 at 3:20:07 PM UTC+5:30, Ashu k wrote: >> >> Dear Seniors, >> >> Please help to sort the data.. Sheet is attached and required output is >> in the (Sheet 1). >> >> >> >> Kindly help. >> >> >> >> Regards >> Ashu Kenith. >> >> >> -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Thanks & Regards, Sunil Kumar Yadav -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN
Hi kanwaljit Can u explain me how to work your formula, max right i understand but minus why using twice! Pls explain it i know little more array function. On Oct 9, 2014 10:36 PM, "Kanwaljit Singh Dhunna" wrote: > Have a Look ! > > I hope you are aware of how to enter an Array Formula ! > > On Thu, Oct 9, 2014 at 9:07 PM, Sundarvelan N wrote: > >> Friends. >> >> I tried all your suggestions i did not got the answer >> >> Thanks >> N.Sundarvelan >> 9600160150 >> >> On Thu, Oct 9, 2014 at 8:14 PM, Kanwaljit Singh Dhunna < >> kanwal...@gmail.com> wrote: >> >>> Hi, >>> >>> Assuming yours values are in range A1:A10, you need to enter the >>> following as an Array Formula >>> >>> =MAX(--RIGHT(A1:A10,8)) >>> >>> To enter the same as an Array Formula, you need to press >>> Ctrl+Shift+Enter after entering the formula in the Cell. >>> >>> On Thu, Oct 9, 2014 at 6:34 PM, manu kashyap >>> wrote: >>> Hi Frd, =max(substitute(cellvalue ya cell reference,"IT","",1)) Try kro bhai On Oct 9, 2014 6:25 PM, "Sundarvelan N" wrote: > Dear Friends, > > Please help me in finding the maximum value in a non numeric column, > example below > > Answer needed is IT20140010 > > > IT20140001 IT20140002 IT20140003 IT20140004 IT20140005 > IT20140006 IT20140007 IT20140008 IT20140009 IT20140010 > > > Thanks > N.Sundarvelan > 9600160150 > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners > and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google > Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send > an email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. >>> >>> >>> >>> -- >>> Sincere Regards >>> CA Kanwaljit Singh Dhunna >>> +91-987 6739 911 >>> +91-950 1031 007 >>> P*Please don't print this e-mail unless you really need to.* >>> *IF U LOSE, DON'T LOSE THE LESSON.* >>> >>> -- >>> 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, 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 question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) A
Re: $$Excel-Macros$$ Amazing Excel formulas...
really amazing!!! *Thanks & Regards,Sunil Kumar Yadav* On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi wrote: > Hi, > > No posts since morning thought of sharing amazing excel formulas by Bill > Jelen aka Mr. Excel. > > Cheers!! > + > *I did not do this for you. God is here working through me for you.* > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Auto filter issue
Yes, Vaibhav Bhai is rock in VBA, his coding explanation is very sample for understanding. *Thanks & Regards,Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 5:23 PM, Ashish Kumar wrote: > Vaibhav Bhai, > > Superb solutions according to the requirement. > > > Regards > Ashish > > > On 4 September 2014 15:57, Vaibhav Joshi wrote: > >> cheers!! >> >> >> On Thu, Sep 4, 2014 at 3:43 PM, Sunil Kumar Yadav > > wrote: >> >>> yeah :-), it is absolutely working as per my requirement. >>> >>> Thank you so much! :-) >>> >>> >>> *Thanks & Regards, Sunil Kumar Yadav* >>> >>> >>> On Thu, Sep 4, 2014 at 3:13 PM, Vaibhav Joshi wrote: >>> >>>> Ok, i goofed up in last stat.. >>>> >>>> Check this now.. >>>> >>>> >>>> On Thu, Sep 4, 2014 at 1:51 PM, Sunil Kumar Yadav < >>>> sk.yadav7...@gmail.com> wrote: >>>> >>>>> yes but first filter 5 against filter GPRS by "contains"(all type >>>>> GPRS), if GPRS not found then sub procedure close or find it then fill >>>>> Correct. >>>>> >>>>> but my create procedure when GPRS not found then fill correct against >>>>> all number like 6,7,8,9,12 etc. that is wrong. >>>>> >>>>> >>>>> *Thanks & Regards,Sunil Kumar Yadav* >>>>> >>>>> >>>>> On Thu, Sep 4, 2014 at 1:27 PM, Vaibhav Joshi wrote: >>>>> >>>>>> It means if you find GPRS & 5 then only you want to paste "Correct" >>>>>> am i right? >>>>>> >>>>>> >>>>>> On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav < >>>>>> sk.yadav7...@gmail.com> wrote: >>>>>> >>>>>>> Sorry sir, but i think u r not understand what i want, may be in >>>>>>> this my mistake...i tell you again....! >>>>>>> >>>>>>> >>>>>>> please find the enclosed file...1)correct 2)Incorrect and >>>>>>> 3)your coding file. >>>>>>> i have mentioned coding in both file in modulepls run and check >>>>>>> status column of both file. >>>>>>> >>>>>>> In incorrect file, when filter not found GPRS against 5 then filled >>>>>>> correct in all row...that is wrong >>>>>>> in correct file, when filter found GPRS against 5 then skip other >>>>>>> rows(2,3,10,9 etc) means blank...that is right. >>>>>>> >>>>>>> now i want when filter not found GPRS against 5 then do the skip >>>>>>> other rows(2,3,10,9 etc) means blank. >>>>>>> >>>>>>> >>>>>>> >>>>>>> *Thanks & Regards,Sunil Kumar Yadav* >>>>>>> >>>>>>> >>>>>>> On Wed, Sep 3, 2014 at 3:56 PM, Vaibhav Joshi wrote: >>>>>>> >>>>>>>> Hi >>>>>>>> >>>>>>>> Check this module 2. >>>>>>>> >>>>>>>> Cheers!! >>>>>>>> >>>>>>>> >>>>>>>> On Wed, Sep 3, 2014 at 2:15 PM, Sunil Kumar Yadav < >>>>>>>> sk.yadav7...@gmail.com> wrote: >>>>>>>> >>>>>>>>> Actually i want first step auto filter, do the filter Column H (in >>>>>>>>> this filter 3,4 and update the correct in column I) then again filter >>>>>>>>> column D (in this filter GPRS all type) and in same time second filter >>>>>>>>> column H (in this filter 5) Now update correct in status column. >>>>>>>>> >>>>>>>>> my question is when filter GPRS in column D after that software >>>>>>>>> not found 5 in Column H then macro fill correct in all number against >>>>>>>>> like >>>>>>>>> 2,6,7,8...i want to 2,6,7,8 etc not fill it, if 5 not found than macro >>>>>>>>> running stop it. >>>>>>>>> >>>>>>>>> >>>>>>>>> *Thanks & Regards,Sunil Kumar Yadav* >>>>>>&g
Re: $$Excel-Macros$$ Auto filter issue
yeah :-), it is absolutely working as per my requirement. Thank you so much! :-) *Thanks & Regards,Sunil Kumar Yadav* On Thu, Sep 4, 2014 at 3:13 PM, Vaibhav Joshi wrote: > Ok, i goofed up in last stat.. > > Check this now.. > > > On Thu, Sep 4, 2014 at 1:51 PM, Sunil Kumar Yadav > wrote: > >> yes but first filter 5 against filter GPRS by "contains"(all type GPRS), >> if GPRS not found then sub procedure close or find it then fill Correct. >> >> but my create procedure when GPRS not found then fill correct against all >> number like 6,7,8,9,12 etc. that is wrong. >> >> >> *Thanks & Regards,Sunil Kumar Yadav* >> >> >> On Thu, Sep 4, 2014 at 1:27 PM, Vaibhav Joshi wrote: >> >>> It means if you find GPRS & 5 then only you want to paste "Correct" am i >>> right? >>> >>> >>> On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav < >>> sk.yadav7...@gmail.com> wrote: >>> >>>> Sorry sir, but i think u r not understand what i want, may be in this >>>> my mistake...i tell you again! >>>> >>>> >>>> please find the enclosed file...1)correct 2)Incorrect and 3)your >>>> coding file. >>>> i have mentioned coding in both file in modulepls run and check >>>> status column of both file. >>>> >>>> In incorrect file, when filter not found GPRS against 5 then filled >>>> correct in all row...that is wrong >>>> in correct file, when filter found GPRS against 5 then skip other >>>> rows(2,3,10,9 etc) means blank...that is right. >>>> >>>> now i want when filter not found GPRS against 5 then do the skip other >>>> rows(2,3,10,9 etc) means blank. >>>> >>>> >>>> >>>> *Thanks & Regards,Sunil Kumar Yadav* >>>> >>>> >>>> On Wed, Sep 3, 2014 at 3:56 PM, Vaibhav Joshi wrote: >>>> >>>>> Hi >>>>> >>>>> Check this module 2. >>>>> >>>>> Cheers!! >>>>> >>>>> >>>>> On Wed, Sep 3, 2014 at 2:15 PM, Sunil Kumar Yadav < >>>>> sk.yadav7...@gmail.com> wrote: >>>>> >>>>>> Actually i want first step auto filter, do the filter Column H (in >>>>>> this filter 3,4 and update the correct in column I) then again filter >>>>>> column D (in this filter GPRS all type) and in same time second filter >>>>>> column H (in this filter 5) Now update correct in status column. >>>>>> >>>>>> my question is when filter GPRS in column D after that software not >>>>>> found 5 in Column H then macro fill correct in all number against like >>>>>> 2,6,7,8...i want to 2,6,7,8 etc not fill it, if 5 not found than macro >>>>>> running stop it. >>>>>> >>>>>> >>>>>> *Thanks & Regards,Sunil Kumar Yadav* >>>>>> >>>>>> >>>>>> On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi wrote: >>>>>> >>>>>>> share sample book & explain step by step what you want to do.. >>>>>>> >>>>>>> Cheers!! >>>>>>> >>>>>>> >>>>>>> On Tue, Sep 2, 2014 at 6:48 PM, Sunil Kumar Yadav < >>>>>>> sk.yadav7...@gmail.com> wrote: >>>>>>> >>>>>>>> >>>>>>>> Hi Friends, >>>>>>>> >>>>>>>> Please guide me on my second query >>>>>>>> >>>>>>>> I have recorded macro on auto filter and modified the 2 conditions >>>>>>>> but when "GPRS" not found against "5", in this situation filter fills >>>>>>>> "correct" in all row of status column, i want to set such condition >>>>>>>> when >>>>>>>> "GPRS" not found against "5" then process work on next step/or close >>>>>>>> without fill correct in all row. >>>>>>>> >>>>>>>> in sample word how can set 3 or 4 conditions on different columns >>>>>>>> in auto filter. >>>>>>>> >>>>>>>> Look Table formate: >>>>>>>> >&g
Re: $$Excel-Macros$$ Auto filter issue
yes but first filter 5 against filter GPRS by "contains"(all type GPRS), if
GPRS not found then sub procedure close or find it then fill Correct.
but my create procedure when GPRS not found then fill correct against all
number like 6,7,8,9,12 etc. that is wrong.
*Thanks & Regards,Sunil Kumar Yadav*
On Thu, Sep 4, 2014 at 1:27 PM, Vaibhav Joshi wrote:
> It means if you find GPRS & 5 then only you want to paste "Correct" am i
> right?
>
>
> On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav
> wrote:
>
>> Sorry sir, but i think u r not understand what i want, may be in this my
>> mistake...i tell you again!
>>
>>
>> please find the enclosed file...1)correct 2)Incorrect and 3)your
>> coding file.
>> i have mentioned coding in both file in modulepls run and check
>> status column of both file.
>>
>> In incorrect file, when filter not found GPRS against 5 then filled
>> correct in all row...that is wrong
>> in correct file, when filter found GPRS against 5 then skip other
>> rows(2,3,10,9 etc) means blank...that is right.
>>
>> now i want when filter not found GPRS against 5 then do the skip other
>> rows(2,3,10,9 etc) means blank.
>>
>>
>>
>> *Thanks & Regards,Sunil Kumar Yadav*
>>
>>
>> On Wed, Sep 3, 2014 at 3:56 PM, Vaibhav Joshi wrote:
>>
>>> Hi
>>>
>>> Check this module 2.
>>>
>>> Cheers!!
>>>
>>>
>>> On Wed, Sep 3, 2014 at 2:15 PM, Sunil Kumar Yadav <
>>> sk.yadav7...@gmail.com> wrote:
>>>
>>>> Actually i want first step auto filter, do the filter Column H (in this
>>>> filter 3,4 and update the correct in column I) then again filter column D
>>>> (in this filter GPRS all type) and in same time second filter column H (in
>>>> this filter 5) Now update correct in status column.
>>>>
>>>> my question is when filter GPRS in column D after that software not
>>>> found 5 in Column H then macro fill correct in all number against like
>>>> 2,6,7,8...i want to 2,6,7,8 etc not fill it, if 5 not found than macro
>>>> running stop it.
>>>>
>>>>
>>>> *Thanks & Regards,Sunil Kumar Yadav*
>>>>
>>>>
>>>> On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi wrote:
>>>>
>>>>> share sample book & explain step by step what you want to do..
>>>>>
>>>>> Cheers!!
>>>>>
>>>>>
>>>>> On Tue, Sep 2, 2014 at 6:48 PM, Sunil Kumar Yadav <
>>>>> sk.yadav7...@gmail.com> wrote:
>>>>>
>>>>>>
>>>>>> Hi Friends,
>>>>>>
>>>>>> Please guide me on my second query
>>>>>>
>>>>>> I have recorded macro on auto filter and modified the 2 conditions
>>>>>> but when "GPRS" not found against "5", in this situation filter fills
>>>>>> "correct" in all row of status column, i want to set such condition when
>>>>>> "GPRS" not found against "5" then process work on next step/or close
>>>>>> without fill correct in all row.
>>>>>>
>>>>>> in sample word how can set 3 or 4 conditions on different columns in
>>>>>> auto filter.
>>>>>>
>>>>>> Look Table formate:
>>>>>>
>>>>>> Len CalltypeStatus(autofile)
>>>>>> 3GPRSIncorrect
>>>>>> 4 Roaming Correct
>>>>>> 5Local GPRS Correct
>>>>>> 9Cross Incorrect
>>>>>> etc
>>>>>>
>>>>>> ActiveSheet.Range("$A$1:$AC$102").AutoFilter Field:=13,
>>>>>> Criteria1:=Array( _
>>>>>>"4", "3"), Operator:=xlFilterValues
>>>>>> Range("N1:N102").Cells.SpecialCells(xlCellTypeBlanks).Select
>>>>>> Range("N1:N102").Cells.SpecialCells(xlCellTypeBlanks).Value
>>>>>> = "Correct"
>>>>>> Selection.AutoFilter
>>>>>> Range("I1").Select
>>>>>> Selection.AutoFilter
>>>>>> ActiveSheet.Range("$A$1:$AC$102").AutoFilter Field:=9,
>>>>>> Criteria1:="=*GPRS*"
Re: $$Excel-Macros$$ Auto filter issue
Hi,
Anybody revert on this please!!!
*Thanks & Regards,Sunil Kumar Yadav*
On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav
wrote:
> Sorry sir, but i think u r not understand what i want, may be in this my
> mistake...i tell you again!
>
>
> please find the enclosed file...1)correct 2)Incorrect and 3)your
> coding file.
> i have mentioned coding in both file in modulepls run and check status
> column of both file.
>
> In incorrect file, when filter not found GPRS against 5 then filled
> correct in all row...that is wrong
> in correct file, when filter found GPRS against 5 then skip other
> rows(2,3,10,9 etc) means blank...that is right.
>
> now i want when filter not found GPRS against 5 then do the skip other
> rows(2,3,10,9 etc) means blank.
>
>
>
> *Thanks & Regards,Sunil Kumar Yadav*
>
>
> On Wed, Sep 3, 2014 at 3:56 PM, Vaibhav Joshi wrote:
>
>> Hi
>>
>> Check this module 2.
>>
>> Cheers!!
>>
>>
>> On Wed, Sep 3, 2014 at 2:15 PM, Sunil Kumar Yadav > > wrote:
>>
>>> Actually i want first step auto filter, do the filter Column H (in this
>>> filter 3,4 and update the correct in column I) then again filter column D
>>> (in this filter GPRS all type) and in same time second filter column H (in
>>> this filter 5) Now update correct in status column.
>>>
>>> my question is when filter GPRS in column D after that software not
>>> found 5 in Column H then macro fill correct in all number against like
>>> 2,6,7,8...i want to 2,6,7,8 etc not fill it, if 5 not found than macro
>>> running stop it.
>>>
>>>
>>> *Thanks & Regards,Sunil Kumar Yadav*
>>>
>>>
>>> On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi wrote:
>>>
>>>> share sample book & explain step by step what you want to do..
>>>>
>>>> Cheers!!
>>>>
>>>>
>>>> On Tue, Sep 2, 2014 at 6:48 PM, Sunil Kumar Yadav <
>>>> sk.yadav7...@gmail.com> wrote:
>>>>
>>>>>
>>>>> Hi Friends,
>>>>>
>>>>> Please guide me on my second query
>>>>>
>>>>> I have recorded macro on auto filter and modified the 2 conditions but
>>>>> when "GPRS" not found against "5", in this situation filter fills
>>>>> "correct"
>>>>> in all row of status column, i want to set such condition when "GPRS" not
>>>>> found against "5" then process work on next step/or close without fill
>>>>> correct in all row.
>>>>>
>>>>> in sample word how can set 3 or 4 conditions on different columns in
>>>>> auto filter.
>>>>>
>>>>> Look Table formate:
>>>>>
>>>>> Len CalltypeStatus(autofile)
>>>>> 3GPRSIncorrect
>>>>> 4Roaming Correct
>>>>> 5Local GPRS Correct
>>>>> 9Cross Incorrect
>>>>> etc
>>>>>
>>>>> ActiveSheet.Range("$A$1:$AC$1020000").AutoFilter Field:=13,
>>>>> Criteria1:=Array( _
>>>>>"4", "3"), Operator:=xlFilterValues
>>>>> Range("N1:N102").Cells.SpecialCells(xlCellTypeBlanks).Select
>>>>> Range("N1:N102").Cells.SpecialCells(xlCellTypeBlanks).Value =
>>>>> "Correct"
>>>>> Selection.AutoFilter
>>>>> Range("I1").Select
>>>>> Selection.AutoFilter
>>>>> ActiveSheet.Range("$A$1:$AC$102").AutoFilter Field:=9,
>>>>> Criteria1:="=*GPRS*", Operator:=xlAnd
>>>>> Range("M1").Select
>>>>> ActiveSheet.Range("$A$1:$AC$102").AutoFilter Field:=13,
>>>>> Criteria1:="5", Operator:=xlFilterValues
>>>>> Range("N1:N102").Cells.SpecialCells(xlCellTypeBlanks).Select
>>>>> Range("N1:N102").Cells.SpecialCells(xlCellTypeBlanks).Value =
>>>>> "Correct"
>>>>>
>>>>>
>>>>> *Thanks & Regards, Sunil Kumar Yadav*
>>>>>
>>>>> --
>>>>> 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 t
Re: $$Excel-Macros$$ Auto filter issue
Actually i want first step auto filter, do the filter Column H (in this
filter 3,4 and update the correct in column I) then again filter column D
(in this filter GPRS all type) and in same time second filter column H (in
this filter 5) Now update correct in status column.
my question is when filter GPRS in column D after that software not found 5
in Column H then macro fill correct in all number against like 2,6,7,8...i
want to 2,6,7,8 etc not fill it, if 5 not found than macro running stop it.
*Thanks & Regards,Sunil Kumar Yadav*
On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi wrote:
> share sample book & explain step by step what you want to do..
>
> Cheers!!
>
>
> On Tue, Sep 2, 2014 at 6:48 PM, Sunil Kumar Yadav
> wrote:
>
>>
>> Hi Friends,
>>
>> Please guide me on my second query
>>
>> I have recorded macro on auto filter and modified the 2 conditions but
>> when "GPRS" not found against "5", in this situation filter fills "correct"
>> in all row of status column, i want to set such condition when "GPRS" not
>> found against "5" then process work on next step/or close without fill
>> correct in all row.
>>
>> in sample word how can set 3 or 4 conditions on different columns in auto
>> filter.
>>
>> Look Table formate:
>>
>> Len CalltypeStatus(autofile)
>> 3GPRSIncorrect
>> 4Roaming Correct
>> 5Local GPRS Correct
>> 9Cross Incorrect
>> etc
>>
>> ActiveSheet.Range("$A$1:$AC$102").AutoFilter Field:=13,
>> Criteria1:=Array( _
>>"4", "3"), Operator:=xlFilterValues
>> Range("N1:N102").Cells.SpecialCells(xlCellTypeBlanks).Select
>> Range("N1:N102").Cells.SpecialCells(xlCellTypeBlanks).Value =
>> "Correct"
>> Selection.AutoFilter
>> Range("I1").Select
>> Selection.AutoFilter
>> ActiveSheet.Range("$A$1:$AC$102").AutoFilter Field:=9,
>> Criteria1:="=*GPRS*", Operator:=xlAnd
>> Range("M1").Select
>> ActiveSheet.Range("$A$1:$AC$102").AutoFilter Field:=13,
>> Criteria1:="5", Operator:=xlFilterValues
>> Range("N1:N102").Cells.SpecialCells(xlCellTypeBlanks).Select
>> Range("N1:N102").Cells.SpecialCells(xlCellTypeBlanks).Value =
>> "Correct"
>>
>>
>> *Thanks & Regards, Sunil Kumar Yadav*
>>
>> --
>> 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, 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 question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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, 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 question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing
$$Excel-Macros$$ Auto filter issue
Hi Friends,
Please guide me on my second query
I have recorded macro on auto filter and modified the 2 conditions but when
"GPRS" not found against "5", in this situation filter fills "correct" in
all row of status column, i want to set such condition when "GPRS" not
found against "5" then process work on next step/or close without fill
correct in all row.
in sample word how can set 3 or 4 conditions on different columns in auto
filter.
Look Table formate:
Len CalltypeStatus(autofile)
3GPRSIncorrect
4Roaming Correct
5Local GPRS Correct
9Cross Incorrect
etc
ActiveSheet.Range("$A$1:$AC$102").AutoFilter Field:=13,
Criteria1:=Array( _
"4", "3"), Operator:=xlFilterValues
Range("N1:N102").Cells.SpecialCells(xlCellTypeBlanks).Select
Range("N1:N102").Cells.SpecialCells(xlCellTypeBlanks).Value =
"Correct"
Selection.AutoFilter
Range("I1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$AC$102").AutoFilter Field:=9,
Criteria1:="=*GPRS*", Operator:=xlAnd
Range("M1").Select
ActiveSheet.Range("$A$1:$AC$102").AutoFilter Field:=13,
Criteria1:="5", Operator:=xlFilterValues
Range("N1:N102").Cells.SpecialCells(xlCellTypeBlanks).Select
Range("N1:N102").Cells.SpecialCells(xlCellTypeBlanks).Value =
"Correct"
*Thanks & Regards,Sunil Kumar Yadav*
--
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, 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 question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Vlookup Issue
thank u so much...it's working completely. *Thanks & Regards,Sunil Kumar Yadav* On Mon, Sep 1, 2014 at 6:48 PM, Vaibhav Joshi wrote: > Check this.. > > Cheers!! > > > On Mon, Sep 1, 2014 at 6:36 PM, Sunil Kumar Yadav > wrote: > >> Hello Friends, >> >> i have a query, please guide me. >> >> i have created a little software for word-meaning, now i want to display >> error message when finding word not available in software, but how? >> >> >> *Thanks & Regards,Sunil Kumar Yadav* >> >> -- >> 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, 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 question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > 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, 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 question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, 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 question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
