Re: $$Excel-Macros$$ Highlight cell values in other areas based on two colimns
Hi Lee, Here you go. Please find the attachment. If you have any questions please let me know. Regards, Ganesh N +91 8056176946 On Sat, Aug 8, 2020 at 10:35 PM Lee wrote: > Hello all! > > You guys have worked miracles before, so I am asking for another. I want > to look at the value in Column H, if it is found in Column C and the Value > of the first character is equal to either A, B or C, then I would like to > highlight it in Column H and bring the term in Column I. > > > Sheet 2 shows what I am hoping to have happen automatically. > > As always, thanks for your help! > > -- > 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 view this discussion on the web visit > https://groups.google.com/d/msgid/excel-macros/249db7db-26c9-4073-964a-576e40217ca5o%40googlegroups.com > <https://groups.google.com/d/msgid/excel-macros/249db7db-26c9-4073-964a-576e40217ca5o%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/excel-macros/CADp4Tf1GZQBnKgdRC1SKhdOAU04tJN3BqEt8pLTw9ighJxQ7qQ%40mail.gmail.com. Sample_result.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Need to highlight more than 6 days working list
Dear Team, Kindly help me to highlight or show more than 6 continues "W" by formula or macro. 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Sample.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ lookup from list or to find a cell contain any one of the item in the list
Dear Team, Any one can help me out ? Thanks & Regards, Ganesh N On Sun, Mar 27, 2016 at 9:15 PM, Ganesh N wrote: > Dear Team, > > Any update on my request ? > > Thanks & Regards, > Ganesh N > > On Sat, Mar 26, 2016 at 7:52 PM, Ganesh N wrote: > >> Dear Team, >> >> Kindly request to help me with some formula to find the cell contains any >> item from the list. I have used search formula but it is not working if the >> list of item in different order. >> >> Working in one sheet and list are in another sheet >> >> If you have any concern kindly let me know. >> >> 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 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.
Re: $$Excel-Macros$$ lookup from list or to find a cell contain any one of the item in the list
Dear Team, Any update on my request ? Thanks & Regards, Ganesh N On Sat, Mar 26, 2016 at 7:52 PM, Ganesh N wrote: > Dear Team, > > Kindly request to help me with some formula to find the cell contains any > item from the list. I have used search formula but it is not working if the > list of item in different order. > > Working in one sheet and list are in another sheet > > If you have any concern kindly let me know. > > 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 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.
$$Excel-Macros$$ lookup from list or to find a cell contain any one of the item in the list
Dear Team, Kindly request to help me with some formula to find the cell contains any item from the list. I have used search formula but it is not working if the list of item in different order. Working in one sheet and list are in another sheet If you have any concern kindly let me know. 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Sample.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ help on find the list matches to the cell part value
Thanks Pankaj and others.
It works fine. Thanks a lot pankaj. Im going to apply in my base data if
any concern kindly help... Thanks
Regards,
Ganesh N
On Tue, Dec 22, 2015 at 9:37 PM, Pankaj Sharma
wrote:
> Dear Ganesh,
>
> I hope it should be ok.
>
>
> Sub lookup_list()
> Dim wf As Object: Set wf = Application.WorksheetFunction
> Dim list As Range: Set list = Range("A1", Range("A" &
> Rows.Count).End(xlUp))
> Dim v1 As Long, v2 As Long, r As Long, a As Long, b As Long
>
>
> On Error Resume Next
> For r = 2 To Range("E" & Rows.Count).End(xlUp).Row
> v1 = Split(Split(Cells(r, 5).Value, "-")(1), "/")(0)
> v2 = Split(Split(Cells(r, 5).Value, "-")(1), "/")(1)
>
> If v1 < v2 Then
> a = wf.CountIf(list, "<=" & v2)
> b = wf.CountIf(list, ">=" & v1)
> ElseIf v1 > v2 Then
> a = wf.CountIf(list, ">=" & v2)
> b = wf.CountIf(list, "<=" & v1)
> End If
> If a > 0 And b > 0 Then Cells(r, 9).Value = "YES" _
> Else Cells(r, 9).Value = "NO"
> Next r
> On Error GoTo 0
>
> End Sub
>
>
>
>
> *Pankaj Sharma *
>
> *MIS Analyst*
>
> *Greater Kailash-1, New Delhi*
>
> *Email *
> *p ankaj123...@gmail.com
> **Skype** pankaj.sharma_pj*
>
>
>
>
> On Tue, Dec 22, 2015 at 6:10 PM, Ganesh N wrote:
>
>> Dear Team,
>>
>> Thanks, But I not get the correct answer.
>>
>> I will say again in the column A I have the list of number. In column E I
>> have some date. I want to check any one in the list (column A) is appearing
>> in column E single cell. If cell E2 have the any number in Column A then i
>> need the answer as "Yes" else "No". But all the solution which i got from
>> the team are not giving the required result. Kindly help.
>>
>> Thanks & Regards,
>> Ganesh N
>>
>> On Tue, Dec 22, 2015 at 5:58 PM, Pankaj Sharma
>> wrote:
>>
>>> check it !
>>>
>>>
>>>
>>> *Pankaj Sharma *
>>>
>>> *MIS Analyst*
>>>
>>> *Greater Kailash-1, New Delhi*
>>>
>>> *Email *
>>> *p ankaj123...@gmail.com
>>> **Skype** pankaj.sharma_pj*
>>>
>>>
>>>
>>>
>>> On Tue, Dec 22, 2015 at 5:07 PM, Ganesh N wrote:
>>>
>>>> Dear team,
>>>>
>>>> I want to find the any of the given list of value matches (part) in the
>>>> particular cell using formula or macro.
>>>>
>>>> Please find the attached excel.
>>>>
>>>> If the solution in formula that would be great!!
>>>>
>>>> If you have any concern let me know.
>>>>
>>>> Thanks Team,
>>>> 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 https://groups.google.com/group/excel-
Re: $$Excel-Macros$$ help on find the list matches to the cell part value
Dear Team, Thanks, But I not get the correct answer. I will say again in the column A I have the list of number. In column E I have some date. I want to check any one in the list (column A) is appearing in column E single cell. If cell E2 have the any number in Column A then i need the answer as "Yes" else "No". But all the solution which i got from the team are not giving the required result. Kindly help. Thanks & Regards, Ganesh N On Tue, Dec 22, 2015 at 5:58 PM, Pankaj Sharma wrote: > check it ! > > > > *Pankaj Sharma * > > *MIS Analyst* > > *Greater Kailash-1, New Delhi* > > *Email * > *p ankaj123...@gmail.com > **Skype** pankaj.sharma_pj* > > > > > On Tue, Dec 22, 2015 at 5:07 PM, Ganesh N wrote: > >> Dear team, >> >> I want to find the any of the given list of value matches (part) in the >> particular cell using formula or macro. >> >> Please find the attached excel. >> >> If the solution in formula that would be great!! >> >> If you have any concern let me know. >> >> Thanks Team, >> 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 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 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$$ help on find the list matches to the cell part value
Dear team, I want to find the any of the given list of value matches (part) in the particular cell using formula or macro. Please find the attached excel. If the solution in formula that would be great!! If you have any concern let me know. Thanks Team, 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Macro required.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Change the date in required format in macro and store in variable
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. 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$$ Change the date in required format in macro and store in variable
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. doubt.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
Re: $$Excel-Macros$$ Re: Introduce Yourself !!
Hi Ayush sir, Thanks for creating the forum. Our group helps me alot and also I help some time. Im working as a PMO in chennai in one of the MNC. " http://www.excel-easy.com/"; is great website which helps with sample file. I request excel beginner to try on that. Thanks again. Regards, Ganesh N On Fri, Jun 19, 2015 at 6:49 PM, Mustapha LMIDMANI < lmidmani.musta...@gmail.com> wrote: > Hello All, > > I'm Mustapha from Morocco. I'm beginer in VBA, and I want to learn and > share my knowledge whith you. > > LMIDMANI Mustapha > Product engineer > lmidmani.musta...@gmail.com > > Le vendredi 8 juin 2012 20:21:59 UTC+1, Ayush Jain a écrit : >> >> 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.
Re: $$Excel-Macros$$ XL formulas not auto updated
Can you pls share the file ? Regards, Ganesh N On Thu, Jun 18, 2015 at 2:10 PM, Ali Abbas wrote: > Dear All Hope you're all well...my problem is my one excel work book's > formulas not updated automatically. Again and again I do press F2+Enter on > any single cell. I have already used check formula+ calculation option + > automatic option but no any advantage of its on and off. > > -- > 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$$ VBA parse an algebraic expression
Hi, Please find the attached file. If you have any concern let me know. Regards, Ganesh N On Thu, Jun 18, 2015 at 8:41 PM, Naftali Herscovici < tuli.herscov...@gmail.com> wrote: > Hello, > > I need to evaluate an algebraic expression. > > Example - start > > dim a,b,c as string > dim x as string > a="5cm" > b="4cm" > x="a+b*sin(30deg)" > > need to get > > c="7cm" > > Example - end > > i.e need to recognize a, b, the trigonometric function, addition operation > and perform the addition > > I know Mathematica can do that, but I need to use a parsing routine in my > code > > Thanks > > -- > 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. Sample.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
Re: $$Excel-Macros$$ How to filter only numbers in the list
Great Mr. Paul. This is want I am looking for. Thanks again also thanks mandeep. Regards, Ganesh N On Wed, Jun 17, 2015 at 6:12 PM, Paul Schreiner wrote: > So you want to see ONLY the alphabetic characters? > You want to filter OUT the numbers? > > If so, I think your terminology is reversed. > Think of Excel filters just like any other filter you can think of: > Coffee, tea, air/furnace > > It's not what stays in the filter that has the most value, that's usually > thrown away. > It's what passes THROUGH the filter that's important! > > When you say you want to "filter only numbers", > that means that you want to remove everything and only let the NUMBERS > pass through. > > If you want to filter OUT the numbers, you're wanting to filter alphabetic > values. > In which case, you can use a filter >=A > > (see attached) > > *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* > - > > -- > *From:* Ganesh N > *To:* "excel-macros@googlegroups.com" > *Sent:* Wednesday, June 17, 2015 8:17 AM > *Subject:* Re: $$Excel-Macros$$ How to filter only numbers in the list > > > Thanks Mr. Paul but how i filter none numeric value ? > > Regards, > Ganesh N > > > > > On Wed, Jun 17, 2015 at 5:36 PM, Paul Schreiner > wrote: > > Simply turn on filters and select values > 0. > > (see attached) > > *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* > - > > -- > *From:* Ganesh N > *To:* "excel-macros@googlegroups.com" > *Sent:* Wednesday, June 17, 2015 7:49 AM > *Subject:* $$Excel-Macros$$ How to filter only numbers in the list > > Dear Team, > > Please help me to know how to filter only number in the list. > > Please find the attachment. > > Thanks & Regards, > GN > -- > 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
Re: $$Excel-Macros$$ How to filter only numbers in the list
Thanks Mr. Mandeep But no other option uh ? Regards, Ganesh N On Wed, Jun 17, 2015 at 6:07 PM, Mandeep Baluja wrote: > Create a helper column right next to your data and use isText function > with respect to left cell apply filter where it is true you can get the > text value !! > > Regards, > MandeepBaluja > Learningzmypassion. > https://www.facebook.com/groups/825221420889809/ > https://www.linkedin.com/profile/view?id=312532939 > > > > On Wednesday, June 17, 2015 at 5:47:41 PM UTC+5:30, Ganesh N wrote: >> >> >> Thanks Mr. Paul but how i filter none numeric value ? >> >> Regards, >> Ganesh N >> >> >> On Wed, Jun 17, 2015 at 5:36 PM, Paul Schreiner >> wrote: >> >>> Simply turn on filters and select values > 0. >>> >>> (see attached) >>> >>> *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* >>> - >>> >>> -- >>> *From:* Ganesh N >>> *To:* "excel-...@googlegroups.com" >>> *Sent:* Wednesday, June 17, 2015 7:49 AM >>> *Subject:* $$Excel-Macros$$ How to filter only numbers in the list >>> >>> Dear Team, >>> >>> Please help me to know how to filter only number in the list. >>> >>> Please find the attachment. >>> >>> Thanks & Regards, >>> GN >>> -- >>> 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 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/exc
Re: $$Excel-Macros$$ How to filter only numbers in the list
Thanks Mr. Paul but how i filter none numeric value ? Regards, Ganesh N On Wed, Jun 17, 2015 at 5:36 PM, Paul Schreiner wrote: > Simply turn on filters and select values > 0. > > (see attached) > > *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* > - > > -- > *From:* Ganesh N > *To:* "excel-macros@googlegroups.com" > *Sent:* Wednesday, June 17, 2015 7:49 AM > *Subject:* $$Excel-Macros$$ How to filter only numbers in the list > > Dear Team, > > Please help me to know how to filter only number in the list. > > Please find the attachment. > > Thanks & Regards, > GN > -- > 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$$ How to filter only numbers in the list
Dear Team, Please help me to know how to filter only number in the list. Please find the attachment. Thanks & Regards, GN -- 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. sample.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Conditional Formating Problem
HI abbas, Use the conditional formatting with "Use a formula to determine which cells to format' Regards, Ganesh N On Thu, May 14, 2015 at 3:24 PM, Ali Abbas wrote: > Dear All. Hope u r all well. > > I have two column with numbers. My requirement is if one column values is > greater than other then greater values color should be red and its smaller > values color is green. How can I compare two columns by using of > conditional. > > -- > 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. sample1.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Re: Exact Search excluding fractions
Dear Mandeep, Can you please explain how you did this ? or can you give the password for the respective code. Thanks & Regards, Ganesh N On Mon, May 4, 2015 at 12:08 AM, Mandeep Baluja wrote: > Check this Out. > > Regards, > Mandeep Baluja > Email :-mandeep.bal...@snapdeal.com > mandeep.bal...@gmail.com > https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77 > https://www.facebook.com/groups/825221420889809/ > > > > > > > > > > > > > On Saturday, May 2, 2015 at 12:52:24 PM UTC+5:30, Zafar Iqbal wrote: >> >> Dear Experts, >> >> I am trying to use (SEARCH and Vlookup) formula to filter out selected >> data from large database. Sample is attached. >> >> When I want to Search 2” ( " means Inch ), current formula brings text >> items containing 2” and non-related items like 1/2", 1 1/2", 2 1/2", >> 12”, 22” etc. >> When I want to Search 1/2”, current formula brings text items >> containing 1/2” and non-related items like 1 1/2", 2 1/2", etc. >> When I want to Search 4”, current formula brings text items containing >> 4” and non-related items like 1/4", 3/4", 1 1/4", 1 3/4", 14”, 24”, >> etc. >> When I want to Search 1/4”, current formula brings text items >> containing 1/4” and non-related items like 1 1/4", 2 1/4", etc. >> >> Kindly help to exclude texts with non-related fractions and attached >> integers on left side. Thanks >> Regards, >> ZAFAR IQBAL >> > -- > 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$$ Copy Dynamically From Column and Pate
Hi Hilary,
Please find the attachment.
Macro1: will copy the data from E1 to the end date which you have.
Macro2: will ask you the start column name. just enter "e" or which column
you want.
Thanks & Regards,
Ganesh N
On Thu, Apr 30, 2015 at 4:44 PM, Paul Schreiner
wrote:
> Hilary,
>
> You've captured the last column in the header in variable "x".
>
> So, your question is how to modify:
> Sheet1.Range("e1:h1").Copy
>
> to make use of this variable column.
>
> One option (of MANY) would be to make use of a variation of the Range()
> object.
>
> Technically, the elements of the Range() object is "Cells".
> one way to identify the cell is using "e1"
> but another way would be:
> Cells(1,"E")
>
> So, e1:h1 can be written Cells(1,"E"),Cells(1,"H")
>
> plugging this into your statement, and implementing the use of the "x"
> variable, you can use:
>
> Sheet1.Range(Cells(1, "E"), Cells(1, x)).Copy
>
> (Personally, I'd use a variable like "LastCol" instead of "x", but that my
> OCD talking)
>
> hope this is what you're looking for.
>
> *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*
> -
>
> --
> *From:* Hilary Lomotey
> *To:* excel-macros
> *Sent:* Thursday, April 30, 2015 4:39 AM
> *Subject:* $$Excel-Macros$$ Copy Dynamically From Column and Pate
>
> Hello Bosses,
>
> i have this code am using to copy Dates from column of sheet1 and
> transpose paste it in sheet2. the issue is to dynamically find the column
> header to copy the data to eg copy from E1 to J1, assuming i enter data in
> column K1 i need an assistance with code to dynaically coopy from EI to
> k1. i can get the last column but dont know how to get the column header .
> please assist. thanks
>
>
>
>
> Sub copytranspose()
>
>
> Dim x As Long
> x = Sheet1.Cells(1, Columns.Count).End(xlToLeft).Column
> Application.ScreenUpdating = False
> 'need to make column dynamic so if i put a value in column i it will
> dynamically pick and copy
> Sheet1.Range("e1:h1").Copy
>
> Sheet2.Range("A2").PasteSpecial xlPasteValues, Transpose:=True
> Application.CutCopyMode = False
> Application.ScreenUpdating = True
> End Sub
>
> --
> 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 confident
Re: $$Excel-Macros$$ FW: Help required
Dear neeraj, PFA, Regards, Ganesh N On Tue, Feb 24, 2015 at 10:40 AM, Neeraj wrote: > Dear experts, > > > > I want to SUM of time as given below format > > > > *2/1/2015* > > *2/21/2015* > > *sum in Hours* > > *Like* > > 11:39:49 > > 9:42:15 > > > > 9 hrs 30 Minute > > > > > > *From:* Neeraj [mailto:neerajchauhan...@gmail.com] > *Sent:* Tuesday, February 24, 2015 10:11 AM > *To:* 'excel-macros@googlegroups.com' > *Subject:* Help required > > > > Dear experts, > > > > I want to some of times as given below format > > > > *2/1/2015* > > *2/21/2015* > > *sum in Hours* > > *Like* > > 11:39:49 > > 9:42:15 > > > > 9 hrs 30 Minute > > > > -- > 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. sam1.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Text to columns
Dear amit, Please find the attachment. Note: Few thing u have do it. 1. don't change the header. 2. change the second comment to = Comnt: has I mentioned. Regards, Ganesh N On Wed, Feb 18, 2015 at 2:47 PM, Amit Desai (MERU) wrote: > Dear Friends, > > > > Please help me getting the data in a cell move to relevant columns. I have > Attached sample file for the same. > > > > Best regards, > > Amit > Disclaimer: This message and its attachments contain confidential > information and may also contain legally privileged information. This > message is intended solely for the named addressee. If you are not the > addressee indicated in this message (or authorized to receive for > addressee), you may not copy or deliver any part of this message or its > attachments to anyone or use any part of this message or its attachments. > Rather, you should permanently delete this message and its attachments (and > all copies) from your system and kindly notify the sender by reply e-mail. > Any content of this message and its attachments that does not relate to the > official business of Meru Cab Company Pvt. Ltd. must be taken not to have > been sent or endorsed by any of them. Email communications are not private > and no warranty is made that e-mail communications are timely, secure or > free from computer virus or other defect. > > -- > 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. Book1-V.xlsx Description: MS-Excel 2007 spreadsheet
Fwd: $$Excel-Macros$$ Colour the Group Rows
Hello, Amazing macro Thanks a lot -- Forwarded message -- From: Vaibhav Joshi Date: Fri, Jan 30, 2015 at 7:01 PM Subject: Re: $$Excel-Macros$$ Colour the Group Rows To: "excel-macros@googlegroups.com" Hi Check this...I have created to Macros, one for clearing format, press erase me button & sleect range from which you want to delete formatting/colr.. And to apply color formatting, press color me & slect top most cell e.g.A2 in your case & press enter..Macro will color cell as per ur requirement.. Cheers!! ᐧ On Fri, Jan 30, 2015 at 5:33 PM, Ganesh Acharya wrote: > Hello > > yes > > after every group there is one space > On Fri, Jan 30, 2015 at 5:28 PM, Vaibhav Joshi wrote: > >> Hi >> >> For macro need some input, is there gonna be space between two groups? >> ᐧ >> >> On Fri, Jan 30, 2015 at 5:19 PM, Ganesh Acharya < >> acharyaganesh...@gmail.com> wrote: >> >>> Thanks a lot for your help team >>> >>> Really you are amazing, >>> >>> I tried this before, but I want to highlight all the group at one go, >>> >>> Because file is huge, I have to create many formula, One which I >>> provided that is just an example >>> >>> If something sort of Macro would be really good >>> >>> Again Thanks a lot for this >>> On Fri, Jan 30, 2015 at 5:09 PM, Ashish Kumar < >>> kumar.ashish...@gmail.com> wrote: >>> >>>> Dear Ganesh, >>>> >>>> Go in Conditional Format tab and click on Manage Rules option and try >>>> to understand how the formula works. >>>> >>>> I think, you no need a macro for it. >>>> >>>> >>>> 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. >>>> >>> >>> >> > -- 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))
Re: $$Excel-Macros$$ Colour the Group Rows
Hello yes after every group there is one space On Fri, Jan 30, 2015 at 5:28 PM, Vaibhav Joshi wrote: > Hi > > For macro need some input, is there gonna be space between two groups? > ᐧ > > On Fri, Jan 30, 2015 at 5:19 PM, Ganesh Acharya < > acharyaganesh...@gmail.com> wrote: > >> Thanks a lot for your help team >> >> Really you are amazing, >> >> I tried this before, but I want to highlight all the group at one go, >> >> Because file is huge, I have to create many formula, One which I provided >> that is just an example >> >> If something sort of Macro would be really good >> >> Again Thanks a lot for this >> On Fri, Jan 30, 2015 at 5:09 PM, Ashish Kumar > > wrote: >> >>> Dear Ganesh, >>> >>> Go in Conditional Format tab and click on Manage Rules option and try to >>> understand how the formula works. >>> >>> I think, you no need a macro for it. >>> >>> >>> 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. >>> >> >> > -- 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$$ Colour the Group Rows
Thanks a lot for your help team Really you are amazing, I tried this before, but I want to highlight all the group at one go, Because file is huge, I have to create many formula, One which I provided that is just an example If something sort of Macro would be really good Again Thanks a lot for this On Fri, Jan 30, 2015 at 5:09 PM, Ashish Kumar wrote: > Dear Ganesh, > > Go in Conditional Format tab and click on Manage Rules option and try to > understand how the formula works. > > I think, you no need a macro for it. > > > 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. > -- 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.
Fwd: $$Excel-Macros$$ Colour the Group Rows
Hello, Attachment doesn't have any formula Is there any way to make a Macro for that Thanks Ganesh Acharya -- Forwarded message -- From: Vaibhav Joshi Date: Fri, Jan 30, 2015 at 2:29 PM Subject: Re: $$Excel-Macros$$ Colour the Group Rows To: "excel-macros@googlegroups.com" Hi You can do with countifs & count formula..for each group you need to have diff. conditional formatting.. Check this attachment.. ᐧ On Fri, Jan 30, 2015 at 1:50 PM, Ganesh Acharya wrote: > Hello Expert > > > I am having some issue in highlighting the rows with there in goup > > > Please find the attachment > > > From the Data, would like to highlight those row which has same* Product > Number and same Item side Name*. but it should be in the *same group* > > In the* group if it has* Same product number and different item. No > changes is required > > Product always remain same, but I want such Macro where it check the > Group, Group remain in different rows, Example Which I given you in the > scenario sheet and way I that in another required Sheet > > > > > Many thanks for your help in advance > > > Thanks > > > Ganesh Acharya > > > 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/ > <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@googleg
$$Excel-Macros$$ Colour the Group Rows
Hello Expert I am having some issue in highlighting the rows with there in goup Please find the attachment >From the Data, would like to highlight those row which has same* Product Number and same Item side Name*. but it should be in the *same group* In the* group if it has* Same product number and different item. No changes is required Product always remain same, but I want such Macro where it check the Group, Group remain in different rows, Example Which I given you in the scenario sheet and way I that in another required Sheet Many thanks for your help in advance Thanks Ganesh Acharya 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/ <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. Colour the Sheet.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Happy New 2015
Happy New Year to all Regards, Ganesh N On Thu, Jan 1, 2015 at 8:58 AM, Ashish Bhalara wrote: > A very very Happy New Year to all Group members. > > > On Wed, Dec 31, 2014 at 7:54 PM, Vaibhav Joshi wrote: > >> Joyous January –Fabulous February >> >> Magical March –Adorable April >> >> Magnificent May –Jolly June >> >> Jubilant July –Awesome August >> >> ScintillatingSeptember –Outstanding October >> >> Naughty November –Dazzling December >> >> This is how I sincerely wish your New Year to be! >> >> Yu Year – Happy Year.. >> >> A Very Happy New Year 2015! To all group members. >> >> 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 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$$ Sum downtime for equipment with overlap periods
Dear son nguyen, PFA Regards, Ganesh N On Wed, Nov 26, 2014 at 10:03 AM, Ganesh N wrote: > Dear son nguyen, > > Before putting the my formula just have sort in start time. > > Regards, > Ganesh N > > On Wed, Nov 26, 2014 at 10:01 AM, Ganesh N wrote: > >> Dear son nguyen, >> >> Try this formula... Let me know if you have any concern. >> >> Thanks & Regards, >> Ganesh N >> >> On Tue, Nov 25, 2014 at 7:07 PM, Paul Schreiner >> wrote: >> >>> Can you send me a sample file? >>> >>> Otherwise, I'll probably spend far too much time trying to recreate >>> something that doesn't apply to your situation. >>> >>> *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* >>> - >>> >>>*From:* son nguyen >>> *To:* excel-macros@googlegroups.com >>> *Sent:* Monday, November 24, 2014 11:22 PM >>> *Subject:* Re: $$Excel-Macros$$ Sum downtime for equipment with overlap >>> periods >>> >>> Mr Paul, >>> >>> Thank for your consider.Let me explain more : >>> There are lots of parts within machine so i would like to list detail of >>> their working stop time ,however when calculating downtime i only calculate >>> actual stop time and eliminate overlap time. >>> >>> Son >>> >>> 2014-11-24 20:47 GMT+07:00 Paul Schreiner : >>> >>> >>> What do these times represent? >>> Why would the equipment be recorded as down 9:00-12:00 AND 10:00-11:30? >>> >>> Is there a minimum recording increment? >>> as in: 5 minute minimum or is it (1) minute increments? >>> >>> I'm considering setting up an array of increments for 24 hours and >>> "flagging" the increment to avoid duplications. >>> But would prefer NOT to have 1440 increments (24 hrs * 60min/hr) >>> >>> >>> *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* >>> - >>> >>>*From:* son nguyen >>> *To:* excel-macros@googlegroups.com >>> *Sent:* Saturday, November 22, 2014 11:55 PM >>> *Subject:* $$Excel-Macros$$ Sum downtime for equipment with overlap >>> periods >>> >>> Dear all, >>> I have problem when calculate total equipment downtime as there are >>> overlap periods. >>> For example : >>> start time Finish time >>> 8:00 8:20 >>> 9:00 12:00 >>> 10:00 11:30 >>> ... >>> start time,finish time are flexible. >>> all of you might give me formula to total hours but exclude overlap. >>> >>> -- >>> Best Regards >>> Son >>> -- >>> 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
Re: $$Excel-Macros$$ Formula to find the month btwn the financial year
Thanks bro!! On Wed, Nov 26, 2014 at 10:45 AM, Vaibhav Joshi wrote: > hi > > when you multiply by 1, xl converts it to date. > > Try this in excel, put this formula cell E2 =DATE(20&RIGHT(D2,2),3,31), > now goto format cell & change date format to dd/mmm/yy or any other format, > result wont change. > > Now in next celll put formula =E2*1 & now goto format cell & change date > format to dd/mmm/yy or any other format. > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Wed, Nov 26, 2014 at 9:11 AM, Ganesh N wrote: > >> Thanks Vaibhav ji, >> >> Got it. But can you pls explain how this works >> =DATE(20&RIGHT(D2,2),3,31)*1 >> >> Thanks a lot! >> Regards, >> Ganesh N >> >> On Tue, Nov 25, 2014 at 8:17 PM, Vaibhav Joshi wrote: >> >>> hi >>> >>> check this... >>> >>> In blue i have given formula using helper columns & in yellow its direct >>> one.. >>> >>> Cheers!! >>> + >>> *I did not do this for you. God is here working through me for you.* >>> >>> On Fri, Nov 21, 2014 at 4:50 PM, Ganesh N wrote: >>> >>>> Dear Mandeep, >>>> >>>> Please see the header I mean the financial year if it is FY 15-16 that >>>> means I what to find the month in apr 15- Mar 16 in the given time period >>>> "1 april and 30 june 19". >>>> >>>> Im I clear or need more clarification ? >>>> >>>> Thanks & Regards, >>>> Ganesh N >>>> >>>> On Fri, Nov 21, 2014 at 3:30 PM, Mandeep Baluja >>>> wrote: >>>> >>>>> How can be the no of months between 1 april and 30 june 19 is 12 ????? >>>>> what you are saying. >>>>> >>>>> Regards, >>>>> Mandeep baluja >>>>> >>>>> >>>>> >>>>> *Month**End Month**FY 15-16**FY 16-17**FY 17-18**FY 18-19**FY 19-20**FY >>>>> 20-21* >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> *1-Apr-15**30-Jun-19**12**12**12**12**3**0* >>>>> >>>>> On Friday, November 21, 2014 3:27:20 PM UTC+5:30, Ganesh N wrote: >>>>>> >>>>>> Dear team, >>>>>> >>>>>> Any update on the request ? >>>>>> >>>>>> Thanks & Regards, >>>>>> Ganesh N >>>>>> >>>>>> On Fri, Nov 21, 2014 at 2:14 PM, Ganesh N wrote: >>>>>> >>>>>>> I tried but I not able to find the exact month btwn the year... So I >>>>>>> need the help on that... >>>>>>> >>>>>>> Regards, >>>>>>> Ganesh N >>>>>>> >>>>>>> On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey >>>>>>> wrote: >>>>>>> >>>>>>>> USE DATEDIF FUNCTION >>>>>>>> >>>>>>>> On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N >>>>>>>> wrote: >>>>>>>> >>>>>>>>> Dear team, >>>>>>>>> >>>>>>>>> Need a help on formula to find the month btwn the years.. pls find >>>>>>>>> the attachement. >>>>>>>>> >>>>>>>>> Note: its should calculate from Apr - Mar >>>>>>>>> >>>>>>>>> I tried but I not able to get the correct one. >>>>>>>>> >>>>>>>>> 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 Pr
Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods
Dear son nguyen, Before putting the my formula just have sort in start time. Regards, Ganesh N On Wed, Nov 26, 2014 at 10:01 AM, Ganesh N wrote: > Dear son nguyen, > > Try this formula... Let me know if you have any concern. > > Thanks & Regards, > Ganesh N > > On Tue, Nov 25, 2014 at 7:07 PM, Paul Schreiner > wrote: > >> Can you send me a sample file? >> >> Otherwise, I'll probably spend far too much time trying to recreate >> something that doesn't apply to your situation. >> >> *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* >> - >> >>*From:* son nguyen >> *To:* excel-macros@googlegroups.com >> *Sent:* Monday, November 24, 2014 11:22 PM >> *Subject:* Re: $$Excel-Macros$$ Sum downtime for equipment with overlap >> periods >> >> Mr Paul, >> >> Thank for your consider.Let me explain more : >> There are lots of parts within machine so i would like to list detail of >> their working stop time ,however when calculating downtime i only calculate >> actual stop time and eliminate overlap time. >> >> Son >> >> 2014-11-24 20:47 GMT+07:00 Paul Schreiner : >> >> >> What do these times represent? >> Why would the equipment be recorded as down 9:00-12:00 AND 10:00-11:30? >> >> Is there a minimum recording increment? >> as in: 5 minute minimum or is it (1) minute increments? >> >> I'm considering setting up an array of increments for 24 hours and >> "flagging" the increment to avoid duplications. >> But would prefer NOT to have 1440 increments (24 hrs * 60min/hr) >> >> >> *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* >> - >> >>*From:* son nguyen >> *To:* excel-macros@googlegroups.com >> *Sent:* Saturday, November 22, 2014 11:55 PM >> *Subject:* $$Excel-Macros$$ Sum downtime for equipment with overlap >> periods >> >> Dear all, >> I have problem when calculate total equipment downtime as there are >> overlap periods. >> For example : >> start time Finish time >> 8:00 8:20 >> 9:00 12:00 >> 10:00 11:30 >> ... >> start time,finish time are flexible. >> all of you might give me formula to total hours but exclude overlap. >> >> -- >> Best Regards >> Son >> -- >> 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 >> >
Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods
Dear son nguyen, Try this formula... Let me know if you have any concern. Thanks & Regards, Ganesh N On Tue, Nov 25, 2014 at 7:07 PM, Paul Schreiner wrote: > Can you send me a sample file? > > Otherwise, I'll probably spend far too much time trying to recreate > something that doesn't apply to your situation. > > *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* > - > >*From:* son nguyen > *To:* excel-macros@googlegroups.com > *Sent:* Monday, November 24, 2014 11:22 PM > *Subject:* Re: $$Excel-Macros$$ Sum downtime for equipment with overlap > periods > > Mr Paul, > > Thank for your consider.Let me explain more : > There are lots of parts within machine so i would like to list detail of > their working stop time ,however when calculating downtime i only calculate > actual stop time and eliminate overlap time. > > Son > > 2014-11-24 20:47 GMT+07:00 Paul Schreiner : > > > What do these times represent? > Why would the equipment be recorded as down 9:00-12:00 AND 10:00-11:30? > > Is there a minimum recording increment? > as in: 5 minute minimum or is it (1) minute increments? > > I'm considering setting up an array of increments for 24 hours and > "flagging" the increment to avoid duplications. > But would prefer NOT to have 1440 increments (24 hrs * 60min/hr) > > > *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* > - > >*From:* son nguyen > *To:* excel-macros@googlegroups.com > *Sent:* Saturday, November 22, 2014 11:55 PM > *Subject:* $$Excel-Macros$$ Sum downtime for equipment with overlap > periods > > Dear all, > I have problem when calculate total equipment downtime as there are > overlap periods. > For example : > start time Finish time > 8:00 8:20 > 9:00 12:00 > 10:00 11:30 > ... > start time,finish time are flexible. > all of you might give me formula to total hours but exclude overlap. > > -- > Best Regards > Son > -- > 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 r
Re: $$Excel-Macros$$ Formula to find the month btwn the financial year
Thanks Vaibhav ji, Got it. But can you pls explain how this works =DATE(20&RIGHT(D2,2),3,31)*1 Thanks a lot! Regards, Ganesh N On Tue, Nov 25, 2014 at 8:17 PM, Vaibhav Joshi wrote: > hi > > check this... > > In blue i have given formula using helper columns & in yellow its direct > one.. > > Cheers!! > + > *I did not do this for you. God is here working through me for you.* > > On Fri, Nov 21, 2014 at 4:50 PM, Ganesh N wrote: > >> Dear Mandeep, >> >> Please see the header I mean the financial year if it is FY 15-16 that >> means I what to find the month in apr 15- Mar 16 in the given time period >> "1 april and 30 june 19". >> >> Im I clear or need more clarification ? >> >> Thanks & Regards, >> Ganesh N >> >> On Fri, Nov 21, 2014 at 3:30 PM, Mandeep Baluja >> wrote: >> >>> How can be the no of months between 1 april and 30 june 19 is 12 ? >>> what you are saying. >>> >>> Regards, >>> Mandeep baluja >>> >>> >>> >>> *Month**End Month**FY 15-16**FY 16-17**FY 17-18**FY 18-19**FY 19-20**FY >>> 20-21* >>> >>> >>> >>> >>> >>> >>> >>> *1-Apr-15**30-Jun-19**12**12**12**12**3**0* >>> >>> On Friday, November 21, 2014 3:27:20 PM UTC+5:30, Ganesh N wrote: >>>> >>>> Dear team, >>>> >>>> Any update on the request ? >>>> >>>> Thanks & Regards, >>>> Ganesh N >>>> >>>> On Fri, Nov 21, 2014 at 2:14 PM, Ganesh N wrote: >>>> >>>>> I tried but I not able to find the exact month btwn the year... So I >>>>> need the help on that... >>>>> >>>>> Regards, >>>>> Ganesh N >>>>> >>>>> On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey >>>>> wrote: >>>>> >>>>>> USE DATEDIF FUNCTION >>>>>> >>>>>> On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N wrote: >>>>>> >>>>>>> Dear team, >>>>>>> >>>>>>> Need a help on formula to find the month btwn the years.. pls find >>>>>>> the attachement. >>>>>>> >>>>>>> Note: its should calculate from Apr - Mar >>>>>>> >>>>>>> I tried but I not able to get the correct one. >>>>>>> >>>>>>> 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...@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. >>>>>>> >>>>>> >>>>>> -- >>>&
Re: $$Excel-Macros$$ Re: How to select a range in vba ?
Dear Mandeep, Pls try this... Sub SelRows() Dim R Rows(1).EntireRow.Select For R = 2 To 100 Step 3 Range(Selection, Selection.Rows(R)).Select Next R End Sub Thanks & Regards, Ganesh N On Tue, Nov 25, 2014 at 9:41 AM, Mandeep Baluja wrote: > Sorry to say I was not looking for this , Try to run this code it will > select 1 to 10 rows. Lets change the code little bit run it and found it's > still selecting all what i want is select rows after every three and keep > the previous rows selected too. Every one can do a operation with alternate > rows even i can do the same. here the point is select next row keeping the > previous rows selected too. > > Sub SelRows() > Dim R > For R = 1 To 100 step 3 > Range(Cells(1, "A"), Cells(R, "A")).EntireRow.Select > Next R > End Sub > > > > > On Monday, November 24, 2014 5:05:14 PM UTC+5:30, Mandeep Baluja wrote: >> >> Dear All, >> >> I hope you have a correct idea for my question I am asking to select rows >> in data with the help of loop. Please note that what i want is to run a >> loop select a row move next and *keep the previous row selected too*. I >> need a efficient code for this. >> >> >> Regards, >> Mandeep Baluja. >> >> -- > 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$$ Formula to find the month btwn the financial year
Dear Mandeep, Please see the header I mean the financial year if it is FY 15-16 that means I what to find the month in apr 15- Mar 16 in the given time period "1 april and 30 june 19". Im I clear or need more clarification ? Thanks & Regards, Ganesh N On Fri, Nov 21, 2014 at 3:30 PM, Mandeep Baluja wrote: > How can be the no of months between 1 april and 30 june 19 is 12 ? > what you are saying. > > Regards, > Mandeep baluja > > > > *Month**End Month**FY 15-16**FY 16-17**FY 17-18**FY 18-19**FY 19-20**FY > 20-21* > > > > > > > > *1-Apr-15**30-Jun-19**12**12**12**12**3**0* > > On Friday, November 21, 2014 3:27:20 PM UTC+5:30, Ganesh N wrote: >> >> Dear team, >> >> Any update on the request ? >> >> Thanks & Regards, >> Ganesh N >> >> On Fri, Nov 21, 2014 at 2:14 PM, Ganesh N wrote: >> >>> I tried but I not able to find the exact month btwn the year... So I >>> need the help on that... >>> >>> Regards, >>> Ganesh N >>> >>> On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey >>> wrote: >>> >>>> USE DATEDIF FUNCTION >>>> >>>> On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N wrote: >>>> >>>>> Dear team, >>>>> >>>>> Need a help on formula to find the month btwn the years.. pls find the >>>>> attachement. >>>>> >>>>> Note: its should calculate from Apr - Mar >>>>> >>>>> I tried but I not able to get the correct one. >>>>> >>>>> 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...@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 responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "MS EXCEL AND VBA MACROS" group. >>>> To u
Re: $$Excel-Macros$$ Formula to find the month btwn the financial year
Dear team, Any update on the request ? Thanks & Regards, Ganesh N On Fri, Nov 21, 2014 at 2:14 PM, Ganesh N wrote: > I tried but I not able to find the exact month btwn the year... So I need > the help on that... > > Regards, > Ganesh N > > On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey wrote: > >> USE DATEDIF FUNCTION >> >> On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N wrote: >> >>> Dear team, >>> >>> Need a help on formula to find the month btwn the years.. pls find the >>> attachement. >>> >>> Note: its should calculate from Apr - Mar >>> >>> I tried but I not able to get the correct one. >>> >>> 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. 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$$ Formula to find the month btwn the financial year
I tried but I not able to find the exact month btwn the year... So I need the help on that... Regards, Ganesh N On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey wrote: > USE DATEDIF FUNCTION > > On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N wrote: > >> Dear team, >> >> Need a help on formula to find the month btwn the years.. pls find the >> attachement. >> >> Note: its should calculate from Apr - Mar >> >> I tried but I not able to get the correct one. >> >> 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. 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$$ Formula to find the month btwn the financial year
Dear team, Need a help on formula to find the month btwn the years.. pls find the attachement. Note: its should calculate from Apr - Mar I tried but I not able to get the correct one. 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. Sample data.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ mass change of URLs
Hi Thomas, If all the links you want to change only "4432" to "3106" just find and replace http://libproxy.library.unt.edu:3106 <http://libproxy.library.unt.edu:3106/hqoweb/library/do/census/results/image?surname=Reed&givenname=robert&series=8&state=3&sex=M&countyid=1073&hitcount=1&p=1&urn=urn%3Aproquest%3AUS%3Bcensus%3B8563629%3B50480442%3B8%3B3&searchtype=1&offset=0> instead of http://libproxy.library.unt.edu:4432 <http://libproxy.library.unt.edu:4432/hqoweb/library/do/census/results/image?surname=Reed&givenname=robert&series=8&state=3&sex=M&countyid=1073&hitcount=1&p=1&urn=urn%3Aproquest%3AUS%3Bcensus%3B8563629%3B50480442%3B8%3B3&searchtype=1&offset=0>, else share the worksheet to make the macro. Regards, Ganesh On Wed, Nov 12, 2014 at 8:09 AM, Thomas Mack wrote: > I have worksheet where my URL links where the text is "Yes' has a link > similar to this: > > > http://libproxy.library.unt.edu:4432/hqoweb/library/do/census/results/image?surname=Reed&givenname=robert&series=8&state=3&sex=M&countyid=1073&hitcount=1&p=1&urn=urn%3Aproquest%3AUS%3Bcensus%3B8563629%3B50480442%3B8%3B3&searchtype=1&offset=0 > > The website changed the "4432" to "3106" as such: > > > http://libproxy.library.unt.edu:3106/hqoweb/library/do/census/results/image?surname=Reed&givenname=robert&series=8&state=3&sex=M&countyid=1073&hitcount=1&p=1&urn=urn%3Aproquest%3AUS%3Bcensus%3B8563629%3B50480442%3B8%3B3&searchtype=1&offset=0 > > Instead of editing 517 links I was hoping I can do this in mass but the > VBA code I found online does not see me to work. > > I should note I am less than a novice at VBA and creating macros > > Thanks Tom > > > -- > 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$$ pls help -Required out[ut in a cell
Dear chandan,
PFA. If you have any concern let me know.
Regards,
Ganesh N
On Tue, Nov 4, 2014 at 3:41 PM, Chandan Bisht wrote:
>
> Hi Group
>
> i m creating a macro by vba but getting some error ...
>
> pls help i want to output in a cell.using below code ..
>
> example atteched..
>
>
>
> Private Sub CommandButton1_Click()
> Dim sh As Worksheet
> Dim rng As Range
> Dim i As Integer
> Set sh = ThisWorkbook.Sheets(1)
> Set rng = sh.Range("a1:A" & sh.Cells(Rows.Count, "a").Row)
> For i = 1 To 100
> sh.Range("B1") = sh.Range("a" & i) & i
> Next i
> End Sub
>
>
> Thankx & Rgds,
>
> Chandra Singh Bisht
>
>
> --
> 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.
Copy of example.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Sort VBA required
Dear Amar, PFA. Just try now. If you have any concern let me know. Regards, Ganesh N On Fri, Oct 10, 2014 at 4:38 PM, amar takale wrote: > Dear friend > Actially I want all result Show in one sheet.which you do this is like > hyperlink > Regards > Amar > > On Thu, Oct 9, 2014 at 4:54 PM, Ganesh N wrote: > > Hi amar, > > > > PFA. > > > > Regards, > > Ganesh N > > > > On Thu, Oct 9, 2014 at 11:52 AM, amar takale > wrote: > >> > >> Dear Sir > >> > >> Pls find attached another sheet for detailed clarification.Here I show > >> how to look output will show.Bos there are same one stock are under > >> different category. > >> > >> Like BHEL it show under both 3 categary so if l hit any button > >> (BSE,Nifty,PSU) it must show that under category.So if I hit button as > >> per my requirement then stocks will show as per that under > >> category.(note that one stock are under different 2 or 3 category) > >> > >> Regards > >> Amar > >> > >> On Tue, Oct 7, 2014 at 7:49 PM, Paul Schreiner > >> wrote: > >> > As I said, what you describe can be accomplished with the use of > >> > Filters. > >> > > >> > In the attached filters, I enabled filters on your data. > >> > > >> > I then recorded a macro (called Button_Nifty50) > >> > in which I filtered on the "Nifty 50" column, > >> > and hid the BSE column. > >> > > >> > I then recorded a macro (called Button_ShowAll) in which I unhid all > >> > columns > >> > and removed the filters. > >> > > >> > I then recorded a macro (called Button_BSE30) > >> > in which I filtered on the "BSE 30" column > >> > and hid the Nifty 50 column. > >> > > >> > I ran the Button_ShowAll macro and recorded a macro called > Button_Other > >> > in which I filtered the Nifty 50 column for a value of "Other" > >> > (your example seemed to suggest that "Other" was in the BSE column, > but > >> > you > >> > data has it in the Nifty50 column) > >> > > >> > Once I had these recorded macros, I cleaned them up a bit (by adding > an > >> > IF() > >> > test to the showall macro, and others) > >> > > >> > then assigned the macros to the buttons. > >> > > >> > It SEEMS to do what you're asking. > >> > > >> > > >> > 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 > >> > - > >> > > >> > From: amar takale > >> > To: excel-macros@googlegroups.com > >> > Sent: Tuesday, October 7, 2014 9:57 AM > >> > Subject: Re: $$Excel-Macros$$ Sort VBA required > >> > > >> > Dear sir > >> > > >> > Pls find attached sheet where I show how to look output.Actually I > >> > want after hit specific tab (like nifty,bse & other) will show that > >> > under category Stocks thats it. > >> > > >> > I hope clarify my issue > >> > > >> > Regards > >> > amar > >> > > >> > On Mon, Oct 6, 2014 at 7:14 PM, Paul Schreiner < > schreiner_p...@att.net> > >> > wrote: > >> >> I'm not sure about your requirement. > >> >> > >> >> You SAY you want to sort, but what you're describing is a filter. > >> >> > >> >> Sorting implies a change in sequence, > >> >> Filter implies hiding rows that do not meet specific criteria. > >> >> > >> >> And... why would it matter if a stock appears in both categories? > >> >> Even if you were sorting, if you sort on column D, it doesn't matter > >> >> what > >> >> is > >> >> is column E. > >> >> > >> >> as I said, I'm not sure about your requirement. > >> >> > >> >> Could you clarifiy by showing examples of what you'd expect to see > >> >> display
Re: $$Excel-Macros$$ Sort VBA required
Hi amar, PFA. Regards, Ganesh N On Thu, Oct 9, 2014 at 11:52 AM, amar takale wrote: > Dear Sir > > Pls find attached another sheet for detailed clarification.Here I show > how to look output will show.Bos there are same one stock are under > different category. > > Like BHEL it show under both 3 categary so if l hit any button > (BSE,Nifty,PSU) it must show that under category.So if I hit button as > per my requirement then stocks will show as per that under > category.(note that one stock are under different 2 or 3 category) > > Regards > Amar > > On Tue, Oct 7, 2014 at 7:49 PM, Paul Schreiner > wrote: > > As I said, what you describe can be accomplished with the use of Filters. > > > > In the attached filters, I enabled filters on your data. > > > > I then recorded a macro (called Button_Nifty50) > > in which I filtered on the "Nifty 50" column, > > and hid the BSE column. > > > > I then recorded a macro (called Button_ShowAll) in which I unhid all > columns > > and removed the filters. > > > > I then recorded a macro (called Button_BSE30) > > in which I filtered on the "BSE 30" column > > and hid the Nifty 50 column. > > > > I ran the Button_ShowAll macro and recorded a macro called Button_Other > > in which I filtered the Nifty 50 column for a value of "Other" > > (your example seemed to suggest that "Other" was in the BSE column, but > you > > data has it in the Nifty50 column) > > > > Once I had these recorded macros, I cleaned them up a bit (by adding an > IF() > > test to the showall macro, and others) > > > > then assigned the macros to the buttons. > > > > It SEEMS to do what you're asking. > > > > > > 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 > > - > > > > From: amar takale > > To: excel-macros@googlegroups.com > > Sent: Tuesday, October 7, 2014 9:57 AM > > Subject: Re: $$Excel-Macros$$ Sort VBA required > > > > Dear sir > > > > Pls find attached sheet where I show how to look output.Actually I > > want after hit specific tab (like nifty,bse & other) will show that > > under category Stocks thats it. > > > > I hope clarify my issue > > > > Regards > > amar > > > > On Mon, Oct 6, 2014 at 7:14 PM, Paul Schreiner > > wrote: > >> I'm not sure about your requirement. > >> > >> You SAY you want to sort, but what you're describing is a filter. > >> > >> Sorting implies a change in sequence, > >> Filter implies hiding rows that do not meet specific criteria. > >> > >> And... why would it matter if a stock appears in both categories? > >> Even if you were sorting, if you sort on column D, it doesn't matter > what > >> is > >> is column E. > >> > >> as I said, I'm not sure about your requirement. > >> > >> Could you clarifiy by showing examples of what you'd expect to see > >> displayed > >> if you hit the "Nifty 50" button, and what you'd see displayed when you > >> hit > >> the "BSE 30" button? > >> > >> > >> > >> 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 > >> - > >> > >> From: amar takale > >> To: excel-macros@googlegroups.com > >> Sent: Monday, October 6, 2014 9:25 AM > >> Subject: $$Excel-Macros$$ Sort VBA required > >> > >> Dear all experts > >> > >> I required VBA code for sorting.pls see with detailed in excel. > >> > >> Regards > >> Amar > >> > >> -- > >> 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
Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS
Dear Kumar, There are lot of tutorial / training documents. Just google it. Regards, Ganesh N On Wed, Oct 8, 2014 at 3:21 PM, Kumar Kishore wrote: > Dear Sir, > > Thank you for your kind co-operation and feedback and response. > > But i don't know Basics. > > Kindly advice us. > > Regards, > > Deva Rayudu > > On Tue, Oct 7, 2014 at 6:42 PM, Paul Schreiner > wrote: > >> That's what we're here for... (helping) >> But it's also guidance for "selp help". >> >> If we can show you where to FIND what you're looking for, you don't have >> to wait for one of us to respond! >> >> Plus, often when you're looking for a solution to the problem in front of >> you, >> you come across answers to questions you haven't even asked (yet)! >> >> let us know if you have trouble, or need an explanation as to how (or >> why) something works. >> >> *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* >> - >> >>*From:* Kumar Kishore >> *To:* excel-macros@googlegroups.com >> *Sent:* Tuesday, October 7, 2014 5:23 AM >> *Subject:* Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS >> >> Dear Sirs, >> >> Thank you so much. >> >> I Will learn from you. from today onwards. >> >> Regards, >> Kishore. >> >> >> >> On Mon, Oct 6, 2014 at 5:23 PM, Paul Schreiner >> wrote: >> >> I can probably handle explaining Vlookup and Hlookup, >> but to teach "macros"??? >> >> That's what this group is for! >> The techniques of using macros is a subject about which many books have >> been written >> and thousands (and thousands) of emails have been shared. >> >> There's really no single way to "teach macros". >> The first step is to have a PURPOSE. >> A task you want to accomplish. >> Usually, some repetative or tedious task you wish to automate. >> >> Then, you proceed to write VBA code to perform this task. >> (often by turning on the macro recorder while you perform some tasks >> manually) >> >> As for VLookup and HLookup: >> >> The fact that you turned to a group such as this, with such a general >> question is concerning. >> >> Have you ever used the Function Wizard? >> The "Help on this function" link at the bottom of the Insert Function >> panel is actually very helpful. >> >> for VLOOKUP, you get: >> Syntax >> >> VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) >> >> The VLOOKUP function syntax has the following arguments (argument: A >> value that provides information to an action, an event, a method, a >> property, a function, or a procedure.): >> >>- *lookup_value* Required. The value to search in the first column of >>the table or range. The *lookup_value* argument can be a value or a >>reference. If the value you supply for the l*ookup_value* argument is >>smaller than the smallest value in the first column of the >>*table_array* argument, *VLOOKUP* returns the #N/A error value. >>- *table_array* Required. The range of cells that contains the data. >>You can use a reference to a range (for example, *A2:D8*), or a range >>name. The values in the first column of *table_array* are the values >>searched by *lookup_value*. These values can be text, numbers, or >>logical values. Uppercase and lowercase text are equivalent. >>- *col_index_num* Required. The column number in the *table_array* >>argument from which the matching value must be returned. A >>*col_index_num* argument of 1 returns the value in the first column >>in *table_array*; a *col_index_num* of 2 returns the value in the >>second column in *table_array*, and so on. >> >> If the *col_index_num* argument is: >> >>- Less than 1, *VLOOKUP* returns the #VALUE! error value. >>- Greater than the number of columns in *table_array*, *VLOOKUP* >>returns the #REF! error value. >> >> >>- *range_lookup* Optional. A logical value that specifies whether you >>want *VLOOKUP* to find an exact match or an approximate match: >> >> >>- If *range_lookup* is eit
Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)
Hi sudhir, PFA. Just given if condition. Regards, Ganesh N On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA wrote: > Dear Experts, > > Kindly resolve my problem. > > Explanation in attached workbook. > > Thanking You > > Regards > Sudhir > > -- > 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. Copy of Urgent.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ for updating the worksheet through the user form
Dear Shankar, The modify will choose the particular row (enter the sn. no) and then wht ever change u want make (e.g out time) and then click the update button. Just try if you have doubt let me know. Regards, Ganesh N On Wed, Sep 24, 2014 at 1:07 PM, Shankar Bheema wrote: > Dear Ganesh > > I have tried just now and what I found is, when I enter rest of column > fields from the Form Entry and pressing the Modify, a message box asking > for the sl no to modify and I have supplied but nothing is happening. > Modify means, entered fields should reflect on the worksheet na. > > Please provide solution. > > On Wed, Sep 24, 2014 at 12:26 PM, Ganesh N wrote: > >> Hi Shankar, >> >> PFA, >> >> I have just added one more button (Modify) use that before update button. >> >> Thanks & Regards, >> Ganesh N >> >> On Wed, Sep 24, 2014 at 11:00 AM, Shankar Bheema >> wrote: >> >>> Good morning all, >>> >>> I am attaching an excel workbook which is meant for office file >>> tracking. On the worksheet I placed commandbutton namely Entry Form. >>> Which enables entry of the data into the sheet. >>> >>> Entry fields will be initially filled upto TIMEIN column. >>> >>> From the Timeout, entry of columns will be made at the end of the office >>> hours. Hence, I placed an update command button. I want to update the sl >>> no.1 without disturbing the previous / initial entries. >>> >>> Kindly provide solution. >>> >>> what is this .xlsm. I saved the file in .xls format but its showing as >>> .xlsm. However, its working on my machine. >>> >>> Thank you in advance >>> >>> regards >>> shankar sb >>> >>> -- >>> 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
Re: $$Excel-Macros$$ for updating the worksheet through the user form
Hi Shankar, PFA, I have just added one more button (Modify) use that before update button. Thanks & Regards, Ganesh N On Wed, Sep 24, 2014 at 11:00 AM, Shankar Bheema wrote: > Good morning all, > > I am attaching an excel workbook which is meant for office file tracking. > On the worksheet I placed commandbutton namely Entry Form. Which enables > entry of the data into the sheet. > > Entry fields will be initially filled upto TIMEIN column. > > From the Timeout, entry of columns will be made at the end of the office > hours. Hence, I placed an update command button. I want to update the sl > no.1 without disturbing the previous / initial entries. > > Kindly provide solution. > > what is this .xlsm. I saved the file in .xls format but its showing as > .xlsm. However, its working on my machine. > > Thank you in advance > > regards > shankar sb > > -- > 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. Copy of dak track tool.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Track the system Lock
i need VBA code for below task I want to do disable and the (windows lock) *window+L* or (lock workstation) or *Crtl+alt+Del*. can every one give the code for that...? -- 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$$ Amazing Excel formulas...
Got it sir!! Thanks One more help sir. Like formulas do you have sample files for macros ? just to learn. im a beginner to macro. Regards, Ganesh N On Thu, Sep 18, 2014 at 4:59 PM, Vaibhav Joshi wrote: > ok, COGS is named range, press Ctr + G you will see all defined cells. > Select COGS you will be taken to range. > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Thu, Sep 18, 2014 at 4:55 PM, Ganesh N wrote: > >> Yes sir no macro but can you tell me how the formula works ? >> >> e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more amount >> in addition row/col it not working >> >> Regards, >> Ganesh N >> >> On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi wrote: >> >>> Hi >>> >>> There is no Macro in this file, it contains formula only. >>> >>> Cheers!! >>> >>> + >>> *I did not do this for you. God is here working through me for you.* >>> >>> On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N wrote: >>> >>>> Hi Vaibhav Ji, >>>> >>>> Can you please explain how the attachment works because I cant even see >>>> any macro in that file. >>>> >>>> Note: Its in the amazing excel formulas file. >>>> >>>> Thanks & Regards, >>>> Ganesh N >>>> >>>> On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar < >>>> chandrashekarb@gmail.com> wrote: >>>> >>>>> Thanks Vaibhav >>>>> >>>>> 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 >>>
Re: $$Excel-Macros$$ Amazing Excel formulas...
Yes sir no macro but can you tell me how the formula works ? e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more amount in addition row/col it not working Regards, Ganesh N On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi wrote: > Hi > > There is no Macro in this file, it contains formula only. > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N wrote: > >> Hi Vaibhav Ji, >> >> Can you please explain how the attachment works because I cant even see >> any macro in that file. >> >> Note: Its in the amazing excel formulas file. >> >> Thanks & Regards, >> Ganesh N >> >> On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar < >> chandrashekarb@gmail.com> wrote: >> >>> Thanks Vaibhav >>> >>> 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. >>> >> >> -- >> 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,
Re: $$Excel-Macros$$ Amazing Excel formulas...
Hi Vaibhav Ji, Can you please explain how the attachment works because I cant even see any macro in that file. Note: Its in the amazing excel formulas file. Thanks & Regards, Ganesh N On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Thanks Vaibhav > > 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. > -- 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. Page038_NatLang.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Documents for web scraping
Dear team, I am learning web scraping where I can find the advanced documents/pdf books or file. 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.
Re: $$Excel-Macros$$ Text file to excel
Thanks Paul. let me try on that. thanks again
Regards,
Ganesh N
On Fri, Sep 5, 2014 at 7:38 PM, Paul Schreiner
wrote:
> That's a bit more involved.
> Have you ever used the filesystem object similar to:
>
>
> Const ForReading = 1, ForWriting = 2, ForAppending = 8
> Dim fs, f
> Set fs = CreateObject("Scripting.FileSystemObject")
> Set f = fs.OpenTextFile("c:\temp\testfile.txt", ForAppending, True)
> f.Write "Hello world!"
> f.Close
>
> You would open the text file, then loop through your worksheet and write
> each line.
> Usually, I build a string variable from the worksheet row and write the
> string.
>
> *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*
> -
>
>*From:* Ganesh N
> *To:* "excel-macros@googlegroups.com"
> *Sent:* Friday, September 5, 2014 8:12 AM
>
> *Subject:* Re: $$Excel-Macros$$ Text file to excel
>
> Hi Paul,
>
> Im fine with every thing but after saving the excel file to .txt it
> contain some additional (") quotes (unwanted). can you please help me to
> avoid that one ?
>
> Thanks & Regards,
> Ganesh N
>
>
> On Fri, Sep 5, 2014 at 8:58 AM, Ganesh N wrote:
>
> Thanks Paul. Let me check on this.
>
> Regards,
> Ganesh N
>
>
> On Thu, Sep 4, 2014 at 11:29 PM, Paul Schreiner
> wrote:
>
> Have you tried recording a macro?
>
> When I recorded macros, I came up with:
>
> Sub Open_Macro()
> Workbooks.OpenText Filename:="C:\temp\mfg_appl_log.txt", Origin:=437, _
> StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
> ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False,
> Comma:=False _
> , Space:=False, Other:=True, OtherChar:="|", _
> FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4,
> 1), _
> Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1)), _
> TrailingMinusNumbers:=True
> End Sub
>
> Sub Save_Macro()
> ActiveWorkbook.Save
> 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*
> -
>
>*From:* Ganesh N
> *To:* "excel-macros@googlegroups.com"
> *Sent:* Thursday, September 4, 2014 1:20 PM
> *Subject:* Re: $$Excel-Macros$$ Text file to excel
>
> Dear Paul,
>
> Thanks for your reply. your rite but i have to open by macro because i
> have to do some automation after i open the .txt file to excel.
>
> Kindly help me how to open the .txt file using macro. I mean code to open
> and save the same.
>
> Thanks & Regards,
> Ganesh N
>
>
> On Thu, Sep 4, 2014 at 10:45 PM, Paul Schreiner
> wrote:
>
> I'm sure I must be misunderstanding the question.
>
> Assuming your text file has a .txt extension:
>
> Why don't you simply:
> launch Excel
> File->Open
> Change file types to: "Text Files (*.prn;*.txt;*.csv)
>
> do whatever formatting is applicable
>
> when saving, the file should default to .txt
>
> so, what am I missing in this question?
>
> *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*
> -
>
>*From:* Ganesh N
> *To:* "excel-macros@googlegroups.com"
> *Sent:* Thursday, September 4, 2014 11:44 AM
> *Subject:* $$Excel-Macros$$ Text file to excel
>
> Dear expert,
>
> I want to open the text file in excel (copy all the data from text file)
> and have to do some computation on excel and again I need to save the excel
> file to text file. I need to know how to open the text file (or how to copy
> the data from text file) and how to save the excel data to text file.
> Required your help one that.
>
> 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
>
&
Re: $$Excel-Macros$$ Text file to excel
Hi Paul,
Im fine with every thing but after saving the excel file to .txt it contain
some additional (") quotes (unwanted). can you please help me to avoid that
one ?
Thanks & Regards,
Ganesh N
On Fri, Sep 5, 2014 at 8:58 AM, Ganesh N wrote:
> Thanks Paul. Let me check on this.
>
> Regards,
> Ganesh N
>
>
> On Thu, Sep 4, 2014 at 11:29 PM, Paul Schreiner
> wrote:
>
>> Have you tried recording a macro?
>>
>> When I recorded macros, I came up with:
>>
>> Sub Open_Macro()
>> Workbooks.OpenText Filename:="C:\temp\mfg_appl_log.txt", Origin:=437,
>> _
>> StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote,
>> _
>> ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False,
>> Comma:=False _
>> , Space:=False, Other:=True, OtherChar:="|", _
>> FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4,
>> 1), _
>> Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1)), _
>> TrailingMinusNumbers:=True
>> End Sub
>>
>> Sub Save_Macro()
>> ActiveWorkbook.Save
>> 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*
>> -
>>
>>*From:* Ganesh N
>> *To:* "excel-macros@googlegroups.com"
>> *Sent:* Thursday, September 4, 2014 1:20 PM
>> *Subject:* Re: $$Excel-Macros$$ Text file to excel
>>
>> Dear Paul,
>>
>> Thanks for your reply. your rite but i have to open by macro because i
>> have to do some automation after i open the .txt file to excel.
>>
>> Kindly help me how to open the .txt file using macro. I mean code to open
>> and save the same.
>>
>> Thanks & Regards,
>> Ganesh N
>>
>>
>> On Thu, Sep 4, 2014 at 10:45 PM, Paul Schreiner
>> wrote:
>>
>> I'm sure I must be misunderstanding the question.
>>
>> Assuming your text file has a .txt extension:
>>
>> Why don't you simply:
>> launch Excel
>> File->Open
>> Change file types to: "Text Files (*.prn;*.txt;*.csv)
>>
>> do whatever formatting is applicable
>>
>> when saving, the file should default to .txt
>>
>> so, what am I missing in this question?
>>
>> *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*
>> -----
>>
>>*From:* Ganesh N
>> *To:* "excel-macros@googlegroups.com"
>> *Sent:* Thursday, September 4, 2014 11:44 AM
>> *Subject:* $$Excel-Macros$$ Text file to excel
>>
>> Dear expert,
>>
>> I want to open the text file in excel (copy all the data from text file)
>> and have to do some computation on excel and again I need to save the excel
>> file to text file. I need to know how to open the text file (or how to copy
>> the data from text file) and how to save the excel data to text file.
>> Required your help one that.
>>
>> 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 MACRO
Re: $$Excel-Macros$$ Text file to excel
Thanks Paul. Let me check on this. Regards, Ganesh N On Thu, Sep 4, 2014 at 11:29 PM, Paul Schreiner wrote: > Have you tried recording a macro? > > When I recorded macros, I came up with: > > Sub Open_Macro() > Workbooks.OpenText Filename:="C:\temp\mfg_appl_log.txt", Origin:=437, _ > StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ > ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, > Comma:=False _ > , Space:=False, Other:=True, OtherChar:="|", _ > FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, > 1), _ > Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1)), _ > TrailingMinusNumbers:=True > End Sub > > Sub Save_Macro() > ActiveWorkbook.Save > 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* > - > >*From:* Ganesh N > *To:* "excel-macros@googlegroups.com" > *Sent:* Thursday, September 4, 2014 1:20 PM > *Subject:* Re: $$Excel-Macros$$ Text file to excel > > Dear Paul, > > Thanks for your reply. your rite but i have to open by macro because i > have to do some automation after i open the .txt file to excel. > > Kindly help me how to open the .txt file using macro. I mean code to open > and save the same. > > Thanks & Regards, > Ganesh N > > > On Thu, Sep 4, 2014 at 10:45 PM, Paul Schreiner > wrote: > > I'm sure I must be misunderstanding the question. > > Assuming your text file has a .txt extension: > > Why don't you simply: > launch Excel > File->Open > Change file types to: "Text Files (*.prn;*.txt;*.csv) > > do whatever formatting is applicable > > when saving, the file should default to .txt > > so, what am I missing in this question? > > *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* > - > >*From:* Ganesh N > *To:* "excel-macros@googlegroups.com" > *Sent:* Thursday, September 4, 2014 11:44 AM > *Subject:* $$Excel-Macros$$ Text file to excel > > Dear expert, > > I want to open the text file in excel (copy all the data from text file) > and have to do some computation on excel and again I need to save the excel > file to text file. I need to know how to open the text file (or how to copy > the data from text file) and how to save the excel data to text file. > Required your help one that. > > 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
Re: $$Excel-Macros$$ Text file to excel
Dear Paul, Thanks for your reply. your rite but i have to open by macro because i have to do some automation after i open the .txt file to excel. Kindly help me how to open the .txt file using macro. I mean code to open and save the same. Thanks & Regards, Ganesh N On Thu, Sep 4, 2014 at 10:45 PM, Paul Schreiner wrote: > I'm sure I must be misunderstanding the question. > > Assuming your text file has a .txt extension: > > Why don't you simply: > launch Excel > File->Open > Change file types to: "Text Files (*.prn;*.txt;*.csv) > > do whatever formatting is applicable > > when saving, the file should default to .txt > > so, what am I missing in this question? > > *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* > - > >*From:* Ganesh N > *To:* "excel-macros@googlegroups.com" > *Sent:* Thursday, September 4, 2014 11:44 AM > *Subject:* $$Excel-Macros$$ Text file to excel > > Dear expert, > > I want to open the text file in excel (copy all the data from text file) > and have to do some computation on excel and again I need to save the excel > file to text file. I need to know how to open the text file (or how to copy > the data from text file) and how to save the excel data to text file. > Required your help one that. > > 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
Re: $$Excel-Macros$$ Blank Cell Issue
Dear LJ, Can you please share the little detail about your requirement ? with some other sample ? Thanks & Regards, Ganesh N On Thu, Sep 4, 2014 at 10:40 PM, LJ wrote: > Ganesh, > > Thanks for the reply. When I do that the other products beneath are left > without values in columns 4 and 6. > > On Thursday, September 4, 2014 1:08:02 PM UTC-4, Ganesh N wrote: > >> Hi LJ, >> >> Just select the data -> ctrl + G -> special -> blanks -> ok - > right >> click - > delete - > Shift cells up. >> >> Thanks & Regards >> Ganesh N >> >> >> On Thu, Sep 4, 2014 at 10:27 PM, LJ wrote: >> >>> Hi Everyone! >>> >>> I am working on a sheet where I have the Product listed in Column A, app >>> in Column B and Cat 1 in Column C. These 3 columns are fine. The issue I >>> run into is column 4 and Column 5 have values that don't line up with >>> column 6. Basically, I don't want to have to drag all the values for Column >>> 6 up to meet Column 4. >>> >>> The attachment is an example of what the sheet currently looks like >>> versus what I want it to look like. The sheet I am working on has thousands >>> of these and I need a quick and easy way to align everything. Appreciate >>> any assistance. >>> >>> Best, >>> >>> LJ >>> >>> -- >>> 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 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 pos
Re: $$Excel-Macros$$ Blank Cell Issue
Hi LJ, Just select the data -> ctrl + G -> special -> blanks -> ok - > right click - > delete - > Shift cells up. Thanks & Regards Ganesh N On Thu, Sep 4, 2014 at 10:27 PM, LJ wrote: > Hi Everyone! > > I am working on a sheet where I have the Product listed in Column A, app > in Column B and Cat 1 in Column C. These 3 columns are fine. The issue I > run into is column 4 and Column 5 have values that don't line up with > column 6. Basically, I don't want to have to drag all the values for Column > 6 up to meet Column 4. > > The attachment is an example of what the sheet currently looks like versus > what I want it to look like. The sheet I am working on has thousands of > these and I need a quick and easy way to align everything. Appreciate any > assistance. > > Best, > > LJ > > -- > 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$$ Text file to excel
Dear expert, I want to open the text file in excel (copy all the data from text file) and have to do some computation on excel and again I need to save the excel file to text file. I need to know how to open the text file (or how to copy the data from text file) and how to save the excel data to text file. Required your help one that. 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.
Re: $$Excel-Macros$$ Need a help in Pivot
Hi, Thank. But there is any way to get the details without changing the structural ? Because the initial one is the format which use to have. Thanks Ganesh N On Sat, Jun 28, 2014 at 6:17 PM, Bé Trần Văn wrote: > Structural change, then use the AutoFilter to select PivotTable OFF. > > 2014-06-28 16:59 GMT+07:00 Ganesh N : > > Hi Team, >> >> I have the shift details. I want only the shift count excluding OFF days >> but when i try pivot i have dayend count including OFF's. Can any one help >> me out with the Pivot how to do it ? >> >> PFA >> >> 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. 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$$ Need a help in Pivot
Hi Team, I have the shift details. I want only the shift count excluding OFF days but when i try pivot i have dayend count including OFF's. Can any one help me out with the Pivot how to do it ? PFA 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. Pivot.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Doubt in Duplicates
HI Kannan, There is In-build option in excel to show the duplicates. Please find the below steps. Home->conditional formatting->highlight cells rules->Duplicate value (you can create whatever format u want to show the duplicate values) Thanks & Regards, Ganesh N On Wed, Apr 30, 2014 at 11:27 AM, Kannan Excel wrote: > Dear Friends, > > Please find the attached file of excel, I have a doubt in that excel. > > I checked the excel there is no formula and VBA coding but it is showing > duplicates. > > How to do this in other excel... Please help me > > -- > 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$$ formula issue with sample sheet
Hi Modi, Im not clear with Defaults month (column Q) because it does not match with due date and payment day. But Defaults Interest (column R) is calculate by if *defaults months*greater than 0 then *TDS amount * 1.5% * defaults months* else the defaults interest will be *0*. (=if(defaultsmonth>0,TDS amount * 1.5% * defaults months,0) Thanks & Regards, Ganesh N On Mon, Apr 28, 2014 at 7:15 PM, L.K. Modi wrote: > > > Dear Sir > > I have downloaded a file from the net but unable to understand the logic > in column Q AND R as the file is read only only so can anyone say me how > that delay had been calculated and interest is calculated... > > thanks in advance > > > regards > LKM > > > -- > 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$$ Need a code to update the non existing data
Thanks Vaibhav!!!
On Sun, Apr 27, 2014 at 3:07 PM, Vaibhav Joshi wrote:
> Here goes file as per your need..
>
> Cheers!!
>
>
> On Sun, Apr 27, 2014 at 12:59 PM, Vaibhav Joshi wrote:
>
>> Hi
>>
>> Use this code instead, this is simple & easy:
>>
>> Sub dataupdate()
>> Range("A2").Select
>> Range(ActiveCell.End(xlDown), Selection.End(xlToRight)).Select
>> Selection.Copy
>> Worksheets("Data update").Select
>> Range("A100").End(xlUp).Offset(1, 0).Select
>> ActiveCell.PasteSpecial
>> Application.CutCopyMode = False
>> ActiveSheet.Range("A:D").RemoveDuplicates Columns:=Array(1, 2, 3, 4), _
>> Header:=xlYes
>> Worksheets("To be update").Select
>>
>> End Sub
>>
>> Cheers!!
>>
>>
>> On Sun, Apr 27, 2014 at 12:00 PM, Ganesh N wrote:
>>
>>> Hi Ravinder sir,
>>>
>>> The Prj code mostly will repeat (week on week the Prj code will be same
>>> only date and value will change) . So I need to check the date and
>>> respective prj code so it wont be duplicate. If I already updated for
>>> current week I need a msg else it should update. Can you please help me on
>>> that ?
>>>
>>> Thanks & Regards,
>>> Ganesh N
>>>
>>>
>>> On Sun, Apr 27, 2014 at 11:20 AM, ravinder negi <
>>> ravindervbacli...@gmail.com> wrote:
>>>
>>>> hi, please visit below link for your solution, please advise if
>>>> anything else required.
>>>>
>>>> http://excelvbasupport.com/forum/showthread.php?tid=15
>>>>
>>>> Note I have checked only code number.
>>>>
>>>>
>>>> On Sat, Apr 26, 2014 at 7:20 PM, Ganesh N wrote:
>>>>
>>>>> Hi Team,
>>>>>
>>>>> I need to update the data in second sheet. before that i want to check
>>>>> the data is already updated or not if already updated i need a msg else
>>>>> the
>>>>> data needs to be update (I want to check the date and prj code, becoz week
>>>>> on week prj and date will change. so i dont want to make a duplicate ). I
>>>>> wrote coding for update the data. I need a code to check the condition.
>>>>> Kindly help me on that.
>>>>>
>>>>> Please find the attachment 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 t
Re: $$Excel-Macros$$ Need a code to update the non existing data
Hi Ravinder sir, The Prj code mostly will repeat (week on week the Prj code will be same only date and value will change) . So I need to check the date and respective prj code so it wont be duplicate. If I already updated for current week I need a msg else it should update. Can you please help me on that ? Thanks & Regards, Ganesh N On Sun, Apr 27, 2014 at 11:20 AM, ravinder negi wrote: > hi, please visit below link for your solution, please advise if anything > else required. > > http://excelvbasupport.com/forum/showthread.php?tid=15 > > Note I have checked only code number. > > > On Sat, Apr 26, 2014 at 7:20 PM, Ganesh N wrote: > >> Hi Team, >> >> I need to update the data in second sheet. before that i want to check >> the data is already updated or not if already updated i need a msg else the >> data needs to be update (I want to check the date and prj code, becoz week >> on week prj and date will change. so i dont want to make a duplicate ). I >> wrote coding for update the data. I need a code to check the condition. >> Kindly help me on that. >> >> Please find the attachment 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. 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$$ please help for consolidate in excel
Hi Yadav,
you can also use this. Just put the data files in separate folder and put
the path in cell "J2".
Thanks & Regards,
Ganesh N
On Sun, Apr 27, 2014 at 11:16 AM, Vaibhav Joshi wrote:
> Hi,
>
> You can try this excellent codes share by Ashish earlier this month:
>
> Sub merge()
>
> Dim fld As Object, fil As Object, fso As Object, fldpath
> With Application.FileDialog(msoFileDialogFolderPicker)
> .Title = "Choose the folder"
> .Show
> End With
> On Error Resume Next
> fldpath =
> Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1)
> & "\"
> If fldpath = False Then
> MsgBox "Folder Not Selected"
> Exit Sub
> End If
>
> Set fso = CreateObject("scripting.filesystemobject")
> Set fld = fso.getfolder(fldpath)
> Application.DisplayAlerts = False
> Application.ScreenUpdating = False
> For Each fil In fld.Files
> If Right(fil.Name, 4) = ".xls" And fil.Name <> ThisWorkbook.Name
> Then Call import_data(fil.Path)
> Next
> Application.DisplayAlerts = True
> Application.ScreenUpdating = True
>
> End Sub
>
>
>
> Sub import_data(filename As String)
> Dim wkb As Workbook
> Dim lastrow As Long
> lastrow = ThisWorkbook.Sheets("Sheet1").Range("a65356").End(xlUp).Row
> + 1
> Set wkb = Workbooks.Open(filename)
> wkb.Sheets("Summary Sheet").Range("e2:j2").Copy
> Destination:=ThisWorkbook.Sheets("Sheet1").Range("a" & lastrow)
> wkb.Sheets("Summary Sheet").Range("b13:f13").Copy
> Destination:=ThisWorkbook.Sheets("Sheet1").Range("g" & lastrow)
> wkb.Close
>
> End Sub
>
> Thanks
>
>
> On Sun, Apr 27, 2014 at 9:44 AM, Jitendra Yadav wrote:
>
>> Hi All,
>>
>> I have some data for date wise but I want all excel file in one sheet
>> through macro.
>>
>>
>>
>> Example.
>>
>>
>>
>>
>> Regards,
>> Jitendra//9650449202
>>
>> --
>> 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.
>
Re: $$Excel-Macros$$ Need a code to update the non existing data
Hi Team, Any update on my request ? Thanks & Regards, Ganesh N On Sun, Apr 27, 2014 at 7:50 AM, Ganesh N wrote: > Hi Team, > > I need to update the data in second sheet. before that i want to check the > data is already updated or not if already updated i need a msg else the > data needs to be update (I want to check the date and prj code, becoz week > on week prj and date will change. so i dont want to make a duplicate ). I > wrote coding for update the data. I need a code to check the condition. > Kindly help me on that. > > Please find the attachment 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.
$$Excel-Macros$$ Need a code to update the non existing data
Hi Team, I need to update the data in second sheet. before that i want to check the data is already updated or not if already updated i need a msg else the data needs to be update (I want to check the date and prj code, becoz week on week prj and date will change. so i dont want to make a duplicate ). I wrote coding for update the data. I need a code to check the condition. Kindly help me on that. Please find the attachment 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. Data to be update.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Need new Workbook create using Macros
Hi Ravinder sir,
Can you please explain about the collections and below line of code how it
works ? Becoz im not familiar with collections
For i = 2 To ws.Range("g1").End(xlDown).Row
col.Add ws.Range("g" & i), CStr(ws.Range("g" & i))
Thanks & Regards,
Ganesh N
On Tue, Apr 22, 2014 at 11:52 AM, Ganesh N wrote:
> Hi Gupta,
>
> Please find the attachment.
>
> Thanks & Regards,
> Ganesh N
>
>
> On Tue, Apr 22, 2014 at 11:43 AM, Ravinder
> wrote:
>
>> Pfa,…first click on button and then select where u want to save file.
>>
>>
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *kapil Gupta
>> *Sent:* Monday, April 21, 2014 8:48 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Need new Workbook create using Macros
>>
>>
>>
>> Hi,
>>
>>Kindly solve this query.
>> 1. I have attached one sheet all data in sheet according by name
>> 2 need create new workbook using macros according by name wise.. Means
>> Name is A then should be Create workbook A and other is B then create other
>> workbook Name is B. and data also Assign in name sheet. I have attached
>> the example
>>
>> Regards,
>> Kapil
>>
>> --
>> 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 respon
Re: $$Excel-Macros$$ Need new Workbook create using Macros
Hi Gupta, Please find the attachment. Thanks & Regards, Ganesh N On Tue, Apr 22, 2014 at 11:43 AM, Ravinder wrote: > Pfa,…first click on button and then select where u want to save file. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *kapil Gupta > *Sent:* Monday, April 21, 2014 8:48 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Need new Workbook create using Macros > > > > Hi, > >Kindly solve this query. > 1. I have attached one sheet all data in sheet according by name > 2 need create new workbook using macros according by name wise.. Means > Name is A then should be Create workbook A and other is B then create other > workbook Name is B. and data also Assign in name sheet. I have attached > the example > > Regards, > Kapil > > -- > 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. ramesh Work as per Name.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Need a help on sumproduct for MTD data
Hi team, any update on this ? Thanks & Regards, Ganesh N On Sat, Apr 12, 2014 at 9:26 PM, Ganesh N wrote: > Hi Ashish/Team, > > I need to do sumproduct for both forecast and AHT (2 type of data). Can > you please help me on that ? > > Thanks & Regards, > Ganesh N > > > On Fri, Apr 11, 2014 at 11:58 PM, ashish koul wrote: > >> =SUMPRODUCT(($B$2:$DC$2=B9)*($B$4:$DC$4)) >> >> >> On Fri, Apr 11, 2014 at 4:50 PM, Ganesh N wrote: >> >>> Hi Team, >>> >>> Kindly help me out to do sumproduct the data for MTD. (monthwise). >>> >>> Please find the attachment 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. >>> >> >> >> >> -- >> *Regards* >> >> *Ashish Koul* >> >> >> *Visit* >> http://www.excelvbamacros.in >> Like Us on >> Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897> >> Join Us on Facebook <http://www.facebook.com/groups/163491717053198/> >> >> >> P Before printing, think about the environment. >> >> >> >> -- >> 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$$ Need a help on sumproduct for MTD data
Hi Ashish/Team, I need to do sumproduct for both forecast and AHT (2 type of data). Can you please help me on that ? Thanks & Regards, Ganesh N On Fri, Apr 11, 2014 at 11:58 PM, ashish koul wrote: > =SUMPRODUCT(($B$2:$DC$2=B9)*($B$4:$DC$4)) > > > On Fri, Apr 11, 2014 at 4:50 PM, Ganesh N wrote: > >> Hi Team, >> >> Kindly help me out to do sumproduct the data for MTD. (monthwise). >> >> Please find the attachment 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. >> > > > > -- > *Regards* > > *Ashish Koul* > > > *Visit* > http://www.excelvbamacros.in > Like Us on > Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897> > Join Us on Facebook <http://www.facebook.com/groups/163491717053198/> > > > P Before printing, think about the environment. > > > > -- > 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$$ Need a help on sumproduct for MTD data
Hi Team, Kindly help me out to do sumproduct the data for MTD. (monthwise). Please find the attachment 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. sumproduct.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date
Thanks Paul & Ashish
Regards,
Ganesh N
On Wed, Apr 9, 2014 at 12:14 AM, ashish koul wrote:
> Sub sample()
> Dim i As Long
> Dim rng As Range
> Dim strng As Long
> Dim endrng As Long
> Sheets("Sheet1").Range("a1:b" &
> Sheets("Sheet1").Range("a1").End(xlDown).Row).Sort
> key1:=Sheets("Sheet1").Range("b:b"), order1:=xlDescending, Header:=xlYes
>
> On Error Resume Next
> i = Application.WorksheetFunction.Match(Sheets("Sheet2").Range("i3"),
> Sheets("Sheet1").Range("b:b"), 0)
> If i = 0 Then Exit Sub
>
>
> endrng = i +
> Application.WorksheetFunction.CountIf(Sheets("Sheet1").Range("b:b"),
> Sheets("Sheet2").Range("i3")) - 1
> Set rng = Sheets("Sheet1").Range("a" & i & ":a" & endrng)
>
> Sheets("Sheet2").Range("i6:i5000").Clear
> j = 6
> For i = 2 To Sheets("Sheet2").Range("a1").End(xlDown).Row
> If Application.WorksheetFunction.CountIf(rng,
> Sheets("Sheet2").Range("a" & i)) = 0 Then
> Sheets("Sheet2").Range("i" & j) = Sheets("Sheet2").Range("a" & i)
> j = j + 1
> End If
> Next
>
>
> End Sub
>
>
> On Tue, Apr 8, 2014 at 6:44 PM, Ganesh N wrote:
>
>> Hi Team,
>>
>> Any updates on the request ??
>>
>> Thanks & Regards,
>> Ganesh
>>
>>
>> On Tue, Apr 8, 2014 at 1:15 PM, Ganesh N wrote:
>>
>>> Hi Team,
>>>
>>> Need a help in find the missed emp id list.
>>>
>>> Sheet1 have the actual employee ids and date. In sheet2 have overall
>>> employee ids in that i need to find the employee missed on particular date.
>>> Please find the attachment 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+unsu
Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date
Hi Team, Any updates on the request ?? Thanks & Regards, Ganesh On Tue, Apr 8, 2014 at 1:15 PM, Ganesh N wrote: > Hi Team, > > Need a help in find the missed emp id list. > > Sheet1 have the actual employee ids and date. In sheet2 have overall > employee ids in that i need to find the employee missed on particular date. > Please find the attachment 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.
$$Excel-Macros$$ Need help to find the missing emp id on particular date
Hi Team, Need a help in find the missed emp id list. Sheet1 have the actual employee ids and date. In sheet2 have overall employee ids in that i need to find the employee missed on particular date. Please find the attachment 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. Missing emp id.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Arrow solution
Hi Amar, Please find the attachment. Let me know it helps you. Regards, Ganesh N On Thu, Apr 3, 2014 at 12:28 PM, amar takale wrote: > Dear Ravinder > Thanks for reply but this is not as per my solution,I want arrow like > H column in excel. > Regards > Amar > > -- > 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. arrow (1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: All text box need to be enter
Hi,
Please find the attachment.
Regards,
Ganesh N
On Wed, Apr 2, 2014 at 4:55 PM, rameshwari shyam
wrote:
> Dear Ganesh,
>
> Here active cell will be different, data need to fill as per
> textbox3 value in colostrum A first empty row
> textbox4 value in column B first empty row
> textbox5 value in column C first empty row
>
> Please help
>
> Regards,
> Rameshwari :)
>
>
> On Wed, Apr 2, 2014 at 3:04 PM, Ganesh N wrote:
>
>> Hi rameshwari,
>>
>> Please find the updated one.
>>
>> Regards,
>> Ganesh N
>>
>>
>> On Wed, Apr 2, 2014 at 4:18 PM, rameshwari shyam <
>> rameshwarish...@gmail.com> wrote:
>>
>>> Dear Ganesh,
>>> Thank you very much for quick reply.
>>>
>>> Once enter the data in all textbox after that hit the submit button. and
>>> after transfer the data to excel sheet all textbox need to be blank. as
>>> this very confidential data of user not suppose to be duplicate.
>>>
>>> Please help.
>>>
>>> Regards,
>>> Rameshwari :)
>>>
>>>
>>> On Wed, Apr 2, 2014 at 2:47 PM, rameshwari shyam <
>>> rameshwarish...@gmail.com> wrote:
>>>
>>>> Dear Ganesh,
>>>> Thank you very much for quick reply.
>>>>
>>>> Once enter the data in all textbox after that hit the submit button.
>>>> and after transfer the data to excel sheet all textbox need to be blank. as
>>>> this very confidential data of user not suppose to be duplicate.
>>>>
>>>> Please help.
>>>>
>>>> Regards,
>>>> Rameshwari :)
>>>>
>>>> On Wed, Apr 2, 2014 at 2:32 PM, Ganesh N wrote:
>>>>
>>>>> Hi Rameshwari,
>>>>>
>>>>> Please find the attached file.
>>>>>
>>>>> Regards,
>>>>> Ganesh N
>>>>>
>>>>>
>>>>> On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari
>>>>> wrote:
>>>>>
>>>>>> Dear Team,
>>>>>>
>>>>>> Forget to attached excel sheet. Please help on this
>>>>>>
>>>>>>
>>>>>> Regards,
>>>>>> Rameshwari :)
>>>>>>
>>>>>> On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Dear Team,
>>>>>>>
>>>>>>> I am creating one tool in user form, it contains 3 textboxes, need
>>>>>>> help on fallowing
>>>>>>>
>>>>>>> If textbox3 fill with information then check for textbox4, if filled
>>>>>>> with information then check for textbox5. If all textbox 3, 4 & 5 are
>>>>>>> filled with information then go to remaining process.
>>>>>>>
>>>>>>> If any of 1 from these textbox is empty then prompt with the
>>>>>>> msgbox("textbox (name)").
>>>>>>>
>>>>>> --
>>>>>> 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 a
Re: $$Excel-Macros$$ Re: All text box need to be enter
Hi rameshwari,
Please find the updated one.
Regards,
Ganesh N
On Wed, Apr 2, 2014 at 4:18 PM, rameshwari shyam
wrote:
> Dear Ganesh,
> Thank you very much for quick reply.
>
> Once enter the data in all textbox after that hit the submit button. and
> after transfer the data to excel sheet all textbox need to be blank. as
> this very confidential data of user not suppose to be duplicate.
>
> Please help.
>
> Regards,
> Rameshwari :)
>
>
> On Wed, Apr 2, 2014 at 2:47 PM, rameshwari shyam <
> rameshwarish...@gmail.com> wrote:
>
>> Dear Ganesh,
>> Thank you very much for quick reply.
>>
>> Once enter the data in all textbox after that hit the submit button. and
>> after transfer the data to excel sheet all textbox need to be blank. as
>> this very confidential data of user not suppose to be duplicate.
>>
>> Please help.
>>
>> Regards,
>> Rameshwari :)
>>
>> On Wed, Apr 2, 2014 at 2:32 PM, Ganesh N wrote:
>>
>>> Hi Rameshwari,
>>>
>>> Please find the attached file.
>>>
>>> Regards,
>>> Ganesh N
>>>
>>>
>>> On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari wrote:
>>>
>>>> Dear Team,
>>>>
>>>> Forget to attached excel sheet. Please help on this
>>>>
>>>>
>>>> Regards,
>>>> Rameshwari :)
>>>>
>>>> On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote:
>>>>>
>>>>>
>>>>>
>>>>> Dear Team,
>>>>>
>>>>> I am creating one tool in user form, it contains 3 textboxes, need
>>>>> help on fallowing
>>>>>
>>>>> If textbox3 fill with information then check for textbox4, if filled
>>>>> with information then check for textbox5. If all textbox 3, 4 & 5 are
>>>>> filled with information then go to remaining process.
>>>>>
>>>>> If any of 1 from these textbox is empty then prompt with the
>>>>> msgbox("textbox (name)").
>>>>>
>>>> --
>>>> 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'
Re: $$Excel-Macros$$ Re: All text box need to be enter
Hi Rameshwari,
Please find the attached file.
Regards,
Ganesh N
On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari wrote:
> Dear Team,
>
> Forget to attached excel sheet. Please help on this
>
>
> Regards,
> Rameshwari :)
>
> On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote:
>>
>>
>>
>> Dear Team,
>>
>> I am creating one tool in user form, it contains 3 textboxes, need help
>> on fallowing
>>
>> If textbox3 fill with information then check for textbox4, if filled with
>> information then check for textbox5. If all textbox 3, 4 & 5 are filled
>> with information then go to remaining process.
>>
>> If any of 1 from these textbox is empty then prompt with the
>> msgbox("textbox (name)").
>>
> --
> 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.
Book1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Record Macro to Filter out blanks
Hi Elaine,
Replace with Criteria1:="<>"
Note: For Blanks use the above. If you want to exclude some thing just use
*<>* before the things.
Regards,
Ganesh N
On Wed, Mar 5, 2014 at 5:11 AM, elaine chong wrote:
> Can someone please help me to guide to filter excluding particular
> blanks. Currently my recorded macro end up listing out all those I wanna
> include instead.
>
> Eg. in my fliter list, I have "0", "1" and "2" and I only wanna filter
> out blanks.
>
> The macros shows
> ActiveSheet.Range("$A$9:$U$2001").AutoFilter Field:=1,
> Criteria1:=Array("0"
> _
> , "1", "2"), Operator:=xlFilterValues
>
> can I replace the highlighted yellow to exclude blanks instead?
>
> --
> 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/groups/opt_out.
>
--
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/groups/opt_out.
$$Excel-Macros$$ Need help in filter
Hi Team, Can you please help me to guide to filter excluding particular name. Please find the attachment. e.g I want to filter excluding "South" region. but its not working. 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/groups/opt_out. Autofilter.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Request help on conditional formatting
Thanks Ravinder Thanks for your explanation :) On Mon, Feb 10, 2014 at 12:46 PM, Ravinder wrote: > NAME > > AMT > > FORMULA > > RESULT (TRUE/FALSE) > > Ganesh > > 20 > > =$F7=MAX($F$7:$F$11) > > FALSE > > Guna > > 90 > > =$F8=MAX($F$7:$F$11) > > TRUE > > Karthick > > 30 > > =$F9=MAX($F$7:$F$11) > > FALSE > > Kumar > > 50 > > =$F10=MAX($F$7:$F$11) > > FALSE > > Senthil > > 40 > > =$F11=MAX($F$7:$F$11) > > FALSE > > > > This will check the true condition and color if condition is True. > Actually this is no only F7 once we apply in all range this will change the > F7 to F8, F9, F10 ,F11 > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ganesh N > *Sent:* Monday, February 10, 2014 12:41 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Request help on conditional formatting > > > > Thanks Ravinder!!! > > > > Ravinder may i know why we are using $F7 ? before =Max. Else can you > explain how it works ? > > > > Thanks & Regards > > Ganesh N > > > > On Mon, Feb 10, 2014 at 10:16 AM, Ravinder > wrote: > > =$F7=MAX($F$7:$F$11) try this formula in condition formatting option or > pfa > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ganesh N > *Sent:* Sunday, February 09, 2014 9:16 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Request help on conditional formatting > > > > Hi team, > > > > Any one can help me to know how to highlight the name based on other > column value (need to highlight name based on the highest or lowest value > of other column). Please find sample example has been attached. > > > > 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/groups/opt_out. > > -- > 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/groups/opt_out. > > > > -- > 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 Faceb
Re: $$Excel-Macros$$ Request help on conditional formatting
Thanks Ravinder!!! Ravinder may i know why we are using $F7 ? before =Max. Else can you explain how it works ? Thanks & Regards Ganesh N On Mon, Feb 10, 2014 at 10:16 AM, Ravinder wrote: > =$F7=MAX($F$7:$F$11) try this formula in condition formatting option or > pfa > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ganesh N > *Sent:* Sunday, February 09, 2014 9:16 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Request help on conditional formatting > > > > Hi team, > > > > Any one can help me to know how to highlight the name based on other > column value (need to highlight name based on the highest or lowest value > of other column). Please find sample example has been attached. > > > > 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/groups/opt_out. > > -- > 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/groups/opt_out. > -- 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/groups/opt_out.
$$Excel-Macros$$ Request help on conditional formatting
Hi team, Any one can help me to know how to highlight the name based on other column value (need to highlight name based on the highest or lowest value of other column). Please find sample example has been attached. 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/groups/opt_out. conditional format.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Simple Sum Macro not working
Thanks Ashish On Sun, Oct 27, 2013 at 9:42 AM, Ganesh N wrote: > Hi Team, > > Im new to macro may i know why this macro not working. Please help me on > that. > > Sub MyFirstProgram() > Range(“B2”).Select > ActiveCell.Value = InputBox(“Enter value”) > Range(“B3”).Select > ActiveCell.Value = InputBox(“Enter value”) > Range(“B4”).Select > ActiveCell.Value = InputBox(“Enter value”) > Range(“B5”).Select > ActiveCell.Value = InputBox(“Enter value”) > Range(“B6”).Select > ActiveCell.Value = InputBox(“Enter value”) > Range(“B7”).Select > ActiveCell.Formula = “=Sum(B2..B6)” > ActiveWorkbook.SaveAs Filename:=”MyFirstProgram.xls” > End Sub > > 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/groups/opt_out. > -- 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/groups/opt_out.
$$Excel-Macros$$ Simple Sum Macro not working
Hi Team, Im new to macro may i know why this macro not working. Please help me on that. Sub MyFirstProgram() Range(“B2”).Select ActiveCell.Value = InputBox(“Enter value”) Range(“B3”).Select ActiveCell.Value = InputBox(“Enter value”) Range(“B4”).Select ActiveCell.Value = InputBox(“Enter value”) Range(“B5”).Select ActiveCell.Value = InputBox(“Enter value”) Range(“B6”).Select ActiveCell.Value = InputBox(“Enter value”) Range(“B7”).Select ActiveCell.Formula = “=Sum(B2..B6)” ActiveWorkbook.SaveAs Filename:=”MyFirstProgram.xls” End Sub 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/groups/opt_out. First.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Macro for Vlookup
Hi Anil, Thanks for that. But I dont need macro to put only formula. I need the macro to do the comparison of 2 list. Can you please help me on that ? Thanks & Regards, Ganesh N On Fri, Oct 25, 2013 at 12:48 PM, Anil Gawli wrote: > Dear Ganesh, > > Pl see the attached sheet. > > > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > > > On Fri, Oct 25, 2013 at 12:05 PM, Ganesh N wrote: > > Hi Team, > > > > I am learning macros. I have run macro to lookup 2 Employee ID list. But > > that is limited if the list extended the macro not running for the > extended > > ID's. Also I want to run that macro if the list in any cells. Please any > one > > help me on that. > > > > Also please tell me where I need to modify in the coding to run this ? > > > > Please find the attactment. > > > > 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/groups/opt_out. > -- 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/groups/opt_out.
$$Excel-Macros$$ Macro for Vlookup
Hi Team, I am learning macros. I have run macro to lookup 2 Employee ID list. But that is limited if the list extended the macro not running for the extended ID's. Also I want to run that macro if the list in any cells. Please any one help me on that. Also please tell me where I need to modify in the coding to run this ? Please find the attactment. 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/groups/opt_out. Vlookup2.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Counting Nos formula
Hi prabhakar, Please find the attachment. Regards, Ganesh N On Mon, Oct 21, 2013 at 2:31 PM, Prabhakar S H wrote: > Hi Team, > > need your help to get nos by using formula. I know how to get details > through pivot table but wanted to know formula also. Pls help. > > Rgds, > Prabhakar > > -- > 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/groups/opt_out. > -- 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/groups/opt_out. Formula Require for Counting.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$
Hi Raj, Please find the attachment. Regards, GN On Sat, Sep 7, 2013 at 11:28 AM, Raj Kumar wrote: > Hi Group, > > I need Pen Drives Count of the attached file. kindly help it. > > Regards > Raj Bharti > > -- > 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/groups/opt_out. > -- 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/groups/opt_out. Pen Drive Count V.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Different Excel file in one Excel file
>Hi, > Can someone please help me out with the macro for below thing > If I saved the different excel file in one folder for ex : - 15 excel > file with different name among them if i want to choose the 5 file as > per my choice If I want to only 6 file which I required so that it can > merge all the data into the one excel file. > For Example: As per below If I tick only 2 box it would extract only two > file into main file. It depends on my tick, if there is 3 tick than 3 > excel file as per my requirement . > > > > > > > > > > > > > > > > > > > > > > > > > > Thanks and Regards Ganesh Acharya > > > > > > > > > > > > > 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?hl=en.<http://groups.google.com/group/excel-macros?hl=en> > For > more options, visit > https://groups.google.com/groups/opt_out.<https://groups.google.com/groups/opt_out> > -- 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, 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?hl=en.<http://groups.google.com/group/excel-macros?hl=en> > For > more options, visit > https://groups.google.com/groups/opt_out.<https://groups.google.com/groups/opt_out> > > -- > 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?hl=en. > For more optio
Fwd: $$Excel-Macros$$ Different Excel file in one Excel file
-- Forwarded message -- From: Ganesh Acharya Date: Thu, Mar 28, 2013 at 12:35 PM Subject: $$Excel-Macros$$ Different Excel file in one Excel file To: excel-macros@googlegroups.com Hi, Can someone please help me out with the macro for below thing If I saved the different excel file in one folder for ex : - 15 excel file with different name among them if i want to choose the 5 file as per my choice If I want to only 6 file which I required so that it can merge all the data into the one excel file. For Example: As per below If I tick only 2 box it would extract only two file into main file. It depends on my tick, if there is 3 tick than 3 excel file as per my requirement . Thanks and Regards Ganesh Acharya 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?hl=en.<http://groups.google.com/group/excel-macros?hl=en> For more options, visit https://groups.google.com/groups/opt_out.<https://groups.google.com/groups/opt_out> -- 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, 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?hl=en.<http://groups.google.com/group/excel-macros?hl=en> For more options, visit https://groups.google.com/groups/opt_out.<https://groups.google.com/groups/opt_out> -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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 Probl
Re: $$Excel-Macros$$ Re: Need to convert the fax copy in Excel sheet.
Hi, Thanks for your reply I don not know the source of Scan copy, but if I want to convert any scan copy what would be the code. Thanks and regards On Sun, Dec 23, 2012 at 12:19 PM, Prince wrote: > Hi Ganesh, > > Plz tell us the source of Fax Data. > > Regards > Prince > > On Sunday, December 23, 2012 11:16:42 AM UTC+5:30, GANESH wrote: >> >> Hi, >> >> Can some please send me the Code for convert the Fax copy to Excel sheet. >> >> Thanks and Regards >> Ganesh Acha >> >> >> -- >> 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, 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 post to this group, send email to excel-...@googlegroups.com. >> To unsubscribe from this group, send email to excel-macros...@** >> googlegroups.com. >> Visit this group at >> http://groups.google.com/**group/excel-macros?hl=en<http://groups.google.com/group/excel-macros?hl=en> >> . >> > -- > 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Latest file copy using excelvba
PFA workbook for sample design to copy files from one directory to another. Please help me to get the same. -- Thanks & Regards, Ganesh -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Backup.xls Description: MS-Excel spreadsheet
Fwd: $$Excel-Macros$$ Re: Request Macro for Merge Text file
Hi Ashish, Please find attached text files and excel sheet for your reference. Please let me know if you have any clarifications. Regards, Ganesh -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. TEXT FILE MERGER.rar Description: application/rar
Re: $$Excel-Macros$$ Re: Request Macro for Merge Text file
Hi Pascal, I am not get correct solution from this coding Please help !!! On Sat, Nov 24, 2012 at 8:11 PM, bpascal123 wrote: > Another shorter programming solution would have been to autofilter column > B and copy visible cells into a table and do the same thing and > let CopyDataToTxtFile do the same thing. am I wrong? > > -- > 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Request Macro for Merge Text file
Hi Pascal, Your understanding is exactly correct, Kindly help to us. Thanks & Regards, Ganesh > > On Sat, Nov 24, 2012 at 4:24 AM, bpascal123 wrote: > >> Merge1.txt = consist of 1.txt, 2.txt and 3.txt also the same order (1, 2 >> & 3) to copy paste in Merge1.txt file. >> >> consist of the content of 1.txt, 2.txt ... not just what's on the >> spreadsheet. >> >> Tell each step of the macro i.e: >> >> 1. Open or create a file from path "C:\Merge\Merge1.txt" for the first >> file (if create, save in path) >> 2. Open 1.txt file and copy the content of the file >> 3. paste the content in Merge1.txt >> 4. open 2.txt and copy the content >> 5. paste into Merge1.txt as new content ... let say append 2.txt to >> Merge1.txt >> 6. until next Merge2.txt text in cell >> >> confirm, since coding with little information can be tremendous and in >> your request, the code will require objects like files... >> >> -- >> 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 post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> > > > > -- > Regards, > Ganesh > > > -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Request Macro for Merge Text file
Dear All, Please find below is my request to create excel macro. I have a list of files in local directory and file list located in A column and need to merge text file based on the B column listed files. A1---B1 C:\1.txt --- C:\Merge\1.txt C:\2.txt --- C:\3.txt --- C:\4.txt --- C:\Merge\4.txt C:\5.txt --- C:\6.txt --- C:\7.txt --- C:\8.txt --- C:\9.txt --- C:\Merge\9.txt C:\10.txt --- Result: C:\Merge\ 1.txt + Here 1.txt, 2.txt and 3.txt combined and named in 1.txt 4.txt 9.txt Kindly help us to get solution for my request. Thanks & Regards Ganesh -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012
Great Job Mr Noorain !!! Keep on your helps in this and we will expect you as world familiar in this expert ices. Thanks & Regards, Ganesh On Tue, Aug 14, 2012 at 2:21 PM, amar takale wrote: > This is Great Noorain Sir > > Thanks Noorain for your effort. > Also, thanks to all the people in the group for help. > > > On Mon, Aug 6, 2012 at 5:56 PM, Venkat CV wrote: > >> Congrats Noorain. >> >> -- >> *Best Regards,* >> *Venkat * >> *Chennai* >> * >> * >> >> >> On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain wrote: >> >>> Dear members, >>> >>> Noorain Ansari has been selected as 'Most Helpful Member' for the month >>> of July'12. He has posted 143 posts in July 2012 and helped many forum >>> members through his excel expertise. >>> >>> I truly appreciate his consistency and commitment to the group. He is >>> really doing great job. >>> >>> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince, >>> Sunita and other folks for helping excel enthusiasts voluntarily !! >>> Keep posting. >>> >>> Regards, >>> Ayush Jain >>> Group Manager >>> Microsoft MVP >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@googlegroups.com >>> >>> >>> >> >> >> >> * >> * >> * >> * >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> >> > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > >
$$Excel-Macros$$ My Self - Introduction
Hi All, My Name is Ganesh from India - Chennai, I am working with Inscribe - BPO for last 7 years as a Project Leader. In our office most the works processed by ms excel, so it is most important to our daily work. Mr Ashish referred to join this forum and it was more useful and reduced our routing works too Thanks a lot for everyone in this forum :) Thanks & Regards, Ganesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
