Re: $$Excel-Macros$$ Job Opening for MIS profile.
Hi All. I have also one Opning in my company. As MIS profile. Salary 19 k and pickup and drop and also meals . Regards Pramod Pramod On 8 Oct 2014 09:51, "Ashish Kumar" wrote: > Hi Friends > > We have 2 Openings for MIS profile. > > Experience - 1 to 2 Yrs > Salary - 10 K (Take Home) + ESI + PF + Gratuity > Job Location - Gurgaon. > Freshers are Welcome but have Good Hands on Excel. > > 1 Vacancy is for Gurgaon and 1 for Mundka (New Delhi). [Peeragarhi - > Rohtak Road] > > Interested Candidates please send your resumes. > > > 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$$ Job Opening for MIS profile.
Hi Guys, 3 more openings we have for this profile. Interested Candidates please send your resume Asap. Regards Ashish On 8 October 2014 09:50, Ashish Kumar wrote: > Hi Friends > > We have 2 Openings for MIS profile. > > Experience - 1 to 2 Yrs > Salary - 10 K (Take Home) + ESI + PF + Gratuity > Job Location - Gurgaon. > Freshers are Welcome but have Good Hands on Excel. > > 1 Vacancy is for Gurgaon and 1 for Mundka (New Delhi). [Peeragarhi - > Rohtak Road] > > Interested Candidates please send your resumes. > > > 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.
$$Excel-Macros$$ Job Opening for MIS profile.
Hi Friends We have 2 Openings for MIS profile. Experience - 1 to 2 Yrs Salary - 10 K (Take Home) + ESI + PF + Gratuity Job Location - Gurgaon. Freshers are Welcome but have Good Hands on Excel. 1 Vacancy is for Gurgaon and 1 for Mundka (New Delhi). [Peeragarhi - Rohtak Road] Interested Candidates please send your resumes. 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.
$$Excel-Macros$$ MF NAV Auto update from website
Dear excel experts, Please find attached .xls file. In that i have some mutual funds are listed. i need to auto update the NAV for the regular basis. NAV is available in the AMFI & money control websites. please help me on this. Regards, M Solaiyappan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’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. MF current NAV.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Sort VBA required
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) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will >> not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is 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
Re: $$Excel-Macros$$ Sort VBA required
Dear sir Also I required if i hit show all button then show all stocks Regards Amar On Tue, Oct 7, 2014 at 7:27 PM, amar takale wrote: > 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) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will >> not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is 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 wo
Re: $$Excel-Macros$$ Sort VBA required
where you want output? Same sheet or diff sheet? + *I did not do this for you. God is here working through me for you.* On Tue, Oct 7, 2014 at 7:27 PM, amar takale wrote: > 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) Use concise, accurate thread titles. Poor thread titles, like Please > > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will > > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Jobs posting is 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 y
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) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is 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 e
Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS
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 lookup_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 either TRUE or is omitted, an exact or approximate >> match is returned. If an exact match is not found, the next largest value >> that is less than lookup_value is returned. >> >>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: Sunday, October 5, 2014 6:13 AM >>>Subject: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS >>> >>> >>> >>>Dear Masters, >>> >>>Please teach the following functions:- >>> >>>1. VLOOKUP >>>2. HLOOKUP and >>>3. MACROS >>> >>> >>> >>>Thank in advance >>> >>> >>> >>>Regards, >>> >>> >>>Kishore >>> -- >>>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’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 m
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 either TRUE or is omitted, an exact or > approximate match is returned. If an exact match is not found, the next > largest value that is less than *lookup_value* is returned. > > > *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:* Sunday, October 5, 2014 6:13 AM > *Subject:* $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS > > Dear Masters, > > Please teach the following functions:- > > 1. VLOOKUP > 2. HLOOKUP and > 3. MACROS > > > Thank in advance > > > Regards, > > Kishore > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’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 p
