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 <kishore...@gmail.com> 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 <schreiner_p...@att.net> > 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 <kishore...@gmail.com> >> *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 <schreiner_p...@att.net> >> 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 <kishore...@gmail.com> >> *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 page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are 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. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are 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.
