$$Excel-Macros$$ WDV Method
Dear All, I am trying to calculate Written Down Value Rate for calculating depreciation on the basis of WDV method by using the following formula. Rate = [1 - (Scrap Value / Total Cost ) ^ (1/Life) ] * 100 If the life is in Number of Exact years, the rate derived is accurate, but if the life of the asset is in fractions, i.e., 2 Year 2 months, the rate does not depreciate the asset accurately and the salvage value is different than the actual salvage value. Please guide me how to solve it. I have attached a file. -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google 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. WDV Method.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN
Hi, Assuming yours values are in range A1:A10, you need to enter the following as an Array Formula =MAX(--RIGHT(A1:A10,8)) To enter the same as an Array Formula, you need to press Ctrl+Shift+Enter after entering the formula in the Cell. On Thu, Oct 9, 2014 at 6:34 PM, manu kashyap wrote: > Hi Frd, > > =max(substitute(cellvalue ya cell reference,"IT","",1)) > > Try kro bhai > On Oct 9, 2014 6:25 PM, "Sundarvelan N" wrote: > >> Dear Friends, >> >> Please help me in finding the maximum value in a non numeric column, >> example below >> >> Answer needed is IT20140010 >> >> >> IT20140001 IT20140002 IT20140003 IT20140004 IT20140005 IT20140006 >> IT20140007 IT20140008 IT20140009 IT20140010 >> >> >> Thanks >> N.Sundarvelan >> 9600160150 >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ FINDING THE MAXIMUM VALUE IN A NON NUMBERIC COLUMN
Have a Look ! I hope you are aware of how to enter an Array Formula ! On Thu, Oct 9, 2014 at 9:07 PM, Sundarvelan N wrote: > Friends. > > I tried all your suggestions i did not got the answer > > Thanks > N.Sundarvelan > 9600160150 > > On Thu, Oct 9, 2014 at 8:14 PM, Kanwaljit Singh Dhunna < > kanwal...@gmail.com> wrote: > >> Hi, >> >> Assuming yours values are in range A1:A10, you need to enter the >> following as an Array Formula >> >> =MAX(--RIGHT(A1:A10,8)) >> >> To enter the same as an Array Formula, you need to press Ctrl+Shift+Enter >> after entering the formula in the Cell. >> >> On Thu, Oct 9, 2014 at 6:34 PM, manu kashyap >> wrote: >> >>> Hi Frd, >>> >>> =max(substitute(cellvalue ya cell reference,"IT","",1)) >>> >>> Try kro bhai >>> On Oct 9, 2014 6:25 PM, "Sundarvelan N" wrote: >>> >>>> Dear Friends, >>>> >>>> Please help me in finding the maximum value in a non numeric column, >>>> example below >>>> >>>> Answer needed is IT20140010 >>>> >>>> >>>> IT20140001 IT20140002 IT20140003 IT20140004 IT20140005 IT20140006 >>>> IT20140007 IT20140008 IT20140009 IT20140010 >>>> >>>> >>>> Thanks >>>> N.Sundarvelan >>>> 9600160150 >>>> >>>> -- >>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>> https://www.facebook.com/discussexcel >>>> >>>> FORUM RULES >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> 2) Don't post a question in the thread of another member. >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> 4) Acknowledge the responses you receive, good or bad. >>>> 5) Jobs posting is not allowed. >>>> 6) Sharing copyrighted material and their links is not allowed. >>>> >>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>> and members are not responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "MS EXCEL AND VBA MACROS" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to excel-macros+unsubscr...@googlegroups.com. >>>> To post to this group, send email to excel-macros@googlegroups.com. >>>> Visit this group at http://groups.google.com/group/excel-macros. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Sincere Regards >> CA Kanwaljit Singh Dh
Re: $$Excel-Macros$$ Help Required.
There is no difference between Vlookup in Excel 2003 and Excel 2007 and above. Please elaborate what is the actual issue. On Mon, Nov 24, 2014 at 9:55 PM, sriram ji wrote: > Dear Excel Guru's, > > Is there any possible to vlookup in 2003 excel to 2007 excel or above.. If > possible please provide the excel vlookup formula. > > Thanks in advance. > > Sriram G(chennai) > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google 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 suggest
Dear Sir, A sample file would help to understand the issue. On Wed, Jan 21, 2015 at 4:45 PM, Rajeev Ranjan <06raj...@gmail.com> wrote: > Dear All, > > I have a one issue. I want the define in particular category. > > eg:- >Value Category > Emp_code+Emp Name "new code" > Emp_name_Mob_No "Old Code" > > > Means:- Pre Numerical + Any String then write the* "New Code*" in > Category columns >Any String + Numerical Value then Write the *"Old Code"* > in category columns > > please help ,if possible from any excel formulas. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google 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$$ Little Macro
Dear Experts, I am assessing the following site for a pre-defined list by entering the requited two field like *PTLP10490E and 091189600169286.* https://onlineservices.tin.egov-nsdl.com/TIN/JSP/tds/linktoUnAuthorizedInput.jsp The resuting page returns No Records found. But if the result is found then I need to print the page otherwise I will move to the next page. If the values are correct the resulting page contains the string "*Assessment Year*" I request a macro so that if the string "*Assessment Year"* is found on the page there is some alerting sound and the page is sent to printer automatically. Otherwise the page is not sent to printer and I can feed the next value. Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google 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$$ Little Macro
Hi Vaibhav, Thanks for the reply. I found some sample values. AGRS11370C - 01026025086 AGRS11370C - 01174026662 AGRS11370C - 01026053751 Above are correct values with me. You can use any incremental number with AGRS11370C to check for incorrect values. On Sat, Jan 31, 2015 at 8:02 PM, Vaibhav Joshi wrote: > hi > > can you send combination of sample data which has value to create macro > for sending result to printer.. > > On Sat, Jan 31, 2015 at 7:35 PM, Kanwaljit Singh Dhunna < > kanwal...@gmail.com> wrote: > >> Dear Experts, >> >> I am assessing the following site for a pre-defined list by entering the >> requited two field like >> >> *PTLP10490E and 091189600169286.* >> >> >> https://onlineservices.tin.egov-nsdl.com/TIN/JSP/tds/linktoUnAuthorizedInput.jsp >> >> The resuting page returns No Records found. But if the result is found >> then I need to print the page otherwise I will move to the next page. >> If the values are correct the resulting page contains the string "*Assessment >> Year*" >> >> I request a macro so that if the string "*Assessment Year"* is found on >> the page there is some alerting sound and the page is sent to printer >> automatically. Otherwise the page is not sent to printer and I can feed the >> next value. >> >> Sincere Regards >> CA Kanwaljit Singh Dhunna >> +91-987 6739 911 >> +91-950 1031 007 >> P*Please don't print this e-mail unless you really need to.* >> *IF U LOSE, DON'T LOSE THE LESSON.* >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurat
Re: $$Excel-Macros$$ Little Macro
:)) You can see the smile ! May God bless you with Bigger Smiley Moments in Yours Life ! A curious point. Why the column C needs to be blanked *manually* before running anything ! Is there some issue in doing it via Coding ? On Sun, Feb 1, 2015 at 12:12 PM, Vaibhav Joshi wrote: > Dear Kanwaljit Singh Dhunna, > > Check attachment, you need to fill data in col. A & B, keep col C > blank b4 running macro. > > Check that you have set correct printer as your default printer as > data will be sent directly for print. > > Press blue button to run Macro & Macro will one Internet Explorer & by > one open send data to page & do as you wanted. > > Cheers!! > > On 1/31/15, Kanwaljit Singh Dhunna wrote: > > Hi Vaibhav, > > > > Thanks for the reply. > > > > I found some sample values. > > AGRS11370C - 01026025086 > > AGRS11370C - 01174026662 > > AGRS11370C - 01026053751 > > > > Above are correct values with me. You can use any incremental number with > > AGRS11370C to check for incorrect values. > > > > On Sat, Jan 31, 2015 at 8:02 PM, Vaibhav Joshi wrote: > > > >> hi > >> > >> can you send combination of sample data which has value to create macro > >> for sending result to printer.. > >> > >> On Sat, Jan 31, 2015 at 7:35 PM, Kanwaljit Singh Dhunna < > >> kanwal...@gmail.com> wrote: > >> > >>> Dear Experts, > >>> > >>> I am assessing the following site for a pre-defined list by entering > the > >>> requited two field like > >>> > >>> *PTLP10490E and 091189600169286.* > >>> > >>> > >>> > https://onlineservices.tin.egov-nsdl.com/TIN/JSP/tds/linktoUnAuthorizedInput.jsp > >>> > >>> The resuting page returns No Records found. But if the result is found > >>> then I need to print the page otherwise I will move to the next page. > >>> If the values are correct the resulting page contains the string > >>> "*Assessment > >>> Year*" > >>> > >>> I request a macro so that if the string "*Assessment Year"* is found on > >>> the page there is some alerting sound and the page is sent to printer > >>> automatically. Otherwise the page is not sent to printer and I can feed > >>> the > >>> next value. > >>> > >>> Sincere Regards > >>> CA Kanwaljit Singh Dhunna > >>> +91-987 6739 911 > >>> +91-950 1031 007 > >>> P*Please don't print this e-mail unless you really need to.* > >>> *IF U LOSE, DON'T LOSE THE LESSON.* > >>> > >>> -- > >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? > >>> It’s > >>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > >>> https://www.facebook.com/discussexcel > >>> > >>> FORUM RULES > >>> > >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please > >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > >>> will not get quick attention or may not be answered. > >>> 2) Don't post a question in the thread of another member. > >>> 3) Don't post questions regarding breaking or bypassing any security > >>> measure. > >>> 4) Acknowledge the responses you receive, good or bad. > >>> 5) Jobs posting is not allowed. > >>> 6) Sharing copyrighted material and their links is not allowed. > >>> > >>> NOTE : Don't ever post confidential data in a workbook. Forum owners > and > >>> members are not responsible for any loss. > >>> --- > >>> You received this message because you are subscribed to the Google > >>> 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 @ > &
Re: $$Excel-Macros$$ Little Macro
Got it Now ! Thanks a Lot ! On Sun, Feb 1, 2015 at 4:21 PM, Vaibhav Joshi wrote: > It gives status. Even if you dont do, excel will overwrite it. > > Cheers!! > On Feb 1, 2015 4:13 PM, "Kanwaljit Singh Dhunna" > wrote: > >> :)) >> >> You can see the smile ! >> May God bless you with Bigger Smiley Moments in Yours Life ! >> >> A curious point. Why the column C needs to be blanked *manually* before >> running anything ! >> Is there some issue in doing it via Coding ? >> >> On Sun, Feb 1, 2015 at 12:12 PM, Vaibhav Joshi wrote: >> >>> Dear Kanwaljit Singh Dhunna, >>> >>> Check attachment, you need to fill data in col. A & B, keep col C >>> blank b4 running macro. >>> >>> Check that you have set correct printer as your default printer as >>> data will be sent directly for print. >>> >>> Press blue button to run Macro & Macro will one Internet Explorer & by >>> one open send data to page & do as you wanted. >>> >>> Cheers!! >>> >>> On 1/31/15, Kanwaljit Singh Dhunna wrote: >>> > Hi Vaibhav, >>> > >>> > Thanks for the reply. >>> > >>> > I found some sample values. >>> > AGRS11370C - 01026025086 >>> > AGRS11370C - 01174026662 >>> > AGRS11370C - 01026053751 >>> > >>> > Above are correct values with me. You can use any incremental number >>> with >>> > AGRS11370C to check for incorrect values. >>> > >>> > On Sat, Jan 31, 2015 at 8:02 PM, Vaibhav Joshi wrote: >>> > >>> >> hi >>> >> >>> >> can you send combination of sample data which has value to create >>> macro >>> >> for sending result to printer.. >>> >> >>> >> On Sat, Jan 31, 2015 at 7:35 PM, Kanwaljit Singh Dhunna < >>> >> kanwal...@gmail.com> wrote: >>> >> >>> >>> Dear Experts, >>> >>> >>> >>> I am assessing the following site for a pre-defined list by entering >>> the >>> >>> requited two field like >>> >>> >>> >>> *PTLP10490E and 091189600169286.* >>> >>> >>> >>> >>> >>> >>> https://onlineservices.tin.egov-nsdl.com/TIN/JSP/tds/linktoUnAuthorizedInput.jsp >>> >>> >>> >>> The resuting page returns No Records found. But if the result is >>> found >>> >>> then I need to print the page otherwise I will move to the next page. >>> >>> If the values are correct the resulting page contains the string >>> >>> "*Assessment >>> >>> Year*" >>> >>> >>> >>> I request a macro so that if the string "*Assessment Year"* is found >>> on >>> >>> the page there is some alerting sound and the page is sent to printer >>> >>> automatically. Otherwise the page is not sent to printer and I can >>> feed >>> >>> the >>> >>> next value. >>> >>> >>> >>> Sincere Regards >>> >>> CA Kanwaljit Singh Dhunna >>> >>> +91-987 6739 911 >>> >>> +91-950 1031 007 >>> >>> P*Please don't print this e-mail unless you really need to.* >>> >>> *IF U LOSE, DON'T LOSE THE LESSON.* >>> >>> >>> >>> -- >>> >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> >>> It’s >>> >>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> >>> https://www.facebook.com/discussexcel >>> >>> >>> >>> FORUM RULES >>> >>> >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like >>> Please >>> >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>> Advice >>> >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Jobs posting is not allowed. >>>
$$Excel-Macros$$ Macro Required
Hi Experts, I have attached a sheet. I wish there could be a macro which when run --assess the website given in column A1, --copy the value given in cell A4 in the input box --wait for me to enter the Captcha MANUALLY (as I have learnt that it is quite a tedious process via code) --copy the resulting values and paste them into the required columns in the sheet (if the input value is invalid then only Mark INVALIDPAN in column B) --copy and value given in Next Cell i.e., A5 and so on till the List is exhausted. Hope I am clear ! Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Auto-Fetch-EM.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Macro Required
Hi Experts, I have attached a sheet. I wish there could be a macro which when run --assess the website given in column A1, --copy the value given in cell A4 in the input box --wait for me to enter the Captcha MANUALLY (as I have learnt that it is quite a tedious process via code) --copy the resulting values and paste them into the required columns in the sheet (if the input value is invalid then only Mark INVALIDPAN in column B) --copy *the *value given in Next Cell i.e., A5 and so on till the List is exhausted. Hope I am clear ! -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Auto-Fetch-EM.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Understanding the macro code
Hi Masters of the VBA Want some Competition :) Kindly guide what should be the Starting point to learn VBA ! On Wed, Feb 4, 2015 at 9:55 PM, Paul Schreiner wrote: > Your file utilizes a "Data Dictionary" object to collect unique records > and concatenate all values from column "B" for each unique value in column > "A". > > the attached file adds some additional comments to the code. > > *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:* Nur Hossain > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, February 4, 2015 9:44 AM > *Subject:* $$Excel-Macros$$ Understanding the macro code > > Dear all, > Would you please spare some time to understand the attached macro > code line by line with details each single parameters explanation ? > . though it has short heading but still I am confused , what > actually did the each line along with its single parameter also . > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > >-- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post con
Re: $$Excel-Macros$$ Little Macro
Hi Vaibhav, A little tweak would do wonders ! In Column F1 I have a Validation List "Yes,No" If I select Yes, then the result is printed, but I have selected No, then only Status is updated in Sheet but no printing is done. On Sun, Feb 1, 2015 at 4:21 PM, Vaibhav Joshi wrote: > It gives status. Even if you dont do, excel will overwrite it. > > Cheers!! > On Feb 1, 2015 4:13 PM, "Kanwaljit Singh Dhunna" > wrote: > >> :)) >> >> You can see the smile ! >> May God bless you with Bigger Smiley Moments in Yours Life ! >> >> A curious point. Why the column C needs to be blanked *manually* before >> running anything ! >> Is there some issue in doing it via Coding ? >> >> On Sun, Feb 1, 2015 at 12:12 PM, Vaibhav Joshi wrote: >> >>> Dear Kanwaljit Singh Dhunna, >>> >>> Check attachment, you need to fill data in col. A & B, keep col C >>> blank b4 running macro. >>> >>> Check that you have set correct printer as your default printer as >>> data will be sent directly for print. >>> >>> Press blue button to run Macro & Macro will one Internet Explorer & by >>> one open send data to page & do as you wanted. >>> >>> Cheers!! >>> >>> On 1/31/15, Kanwaljit Singh Dhunna wrote: >>> > Hi Vaibhav, >>> > >>> > Thanks for the reply. >>> > >>> > I found some sample values. >>> > AGRS11370C - 01026025086 >>> > AGRS11370C - 01174026662 >>> > AGRS11370C - 01026053751 >>> > >>> > Above are correct values with me. You can use any incremental number >>> with >>> > AGRS11370C to check for incorrect values. >>> > >>> > On Sat, Jan 31, 2015 at 8:02 PM, Vaibhav Joshi wrote: >>> > >>> >> hi >>> >> >>> >> can you send combination of sample data which has value to create >>> macro >>> >> for sending result to printer.. >>> >> >>> >> On Sat, Jan 31, 2015 at 7:35 PM, Kanwaljit Singh Dhunna < >>> >> kanwal...@gmail.com> wrote: >>> >> >>> >>> Dear Experts, >>> >>> >>> >>> I am assessing the following site for a pre-defined list by entering >>> the >>> >>> requited two field like >>> >>> >>> >>> *PTLP10490E and 091189600169286.* >>> >>> >>> >>> >>> >>> >>> https://onlineservices.tin.egov-nsdl.com/TIN/JSP/tds/linktoUnAuthorizedInput.jsp >>> >>> >>> >>> The resuting page returns No Records found. But if the result is >>> found >>> >>> then I need to print the page otherwise I will move to the next page. >>> >>> If the values are correct the resulting page contains the string >>> >>> "*Assessment >>> >>> Year*" >>> >>> >>> >>> I request a macro so that if the string "*Assessment Year"* is found >>> on >>> >>> the page there is some alerting sound and the page is sent to printer >>> >>> automatically. Otherwise the page is not sent to printer and I can >>> feed >>> >>> the >>> >>> next value. >>> >>> >>> >>> Sincere Regards >>> >>> CA Kanwaljit Singh Dhunna >>> >>> +91-987 6739 911 >>> >>> +91-950 1031 007 >>> >>> P*Please don't print this e-mail unless you really need to.* >>> >>> *IF U LOSE, DON'T LOSE THE LESSON.* >>> >>> >>> >>> -- >>> >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> >>> It’s >>> >>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> >>> https://www.facebook.com/discussexcel >>> >>> >>> >>> FORUM RULES >>> >>> >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like >>> Please >>> >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>> Advice >>> >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or
Re: $$Excel-Macros$$ Little Macro
That Was Amazing Indeed ! How do you do it ! Kindly share what should be the First step in Learning VBA. I am seriously into this now... On Thu, Feb 5, 2015 at 12:19 PM, Vaibhav Joshi wrote: > Yes, check this... > > Cheers!! > > > On Wed, Feb 4, 2015 at 11:49 PM, Kanwaljit Singh Dhunna < > kanwal...@gmail.com> wrote: > >> Hi Vaibhav, >> >> A little tweak would do wonders ! >> >> In Column F1 I have a Validation List "Yes,No" >> If I select Yes, then the result is printed, but I have selected No, then >> only Status is updated in Sheet but no printing is done. >> >> On Sun, Feb 1, 2015 at 4:21 PM, Vaibhav Joshi wrote: >> >>> It gives status. Even if you dont do, excel will overwrite it. >>> >>> Cheers!! >>> On Feb 1, 2015 4:13 PM, "Kanwaljit Singh Dhunna" >>> wrote: >>> >>>> :)) >>>> >>>> You can see the smile ! >>>> May God bless you with Bigger Smiley Moments in Yours Life ! >>>> >>>> A curious point. Why the column C needs to be blanked *manually* >>>> before running anything ! >>>> Is there some issue in doing it via Coding ? >>>> >>>> On Sun, Feb 1, 2015 at 12:12 PM, Vaibhav Joshi wrote: >>>> >>>>> Dear Kanwaljit Singh Dhunna, >>>>> >>>>> Check attachment, you need to fill data in col. A & B, keep col C >>>>> blank b4 running macro. >>>>> >>>>> Check that you have set correct printer as your default printer as >>>>> data will be sent directly for print. >>>>> >>>>> Press blue button to run Macro & Macro will one Internet Explorer & by >>>>> one open send data to page & do as you wanted. >>>>> >>>>> Cheers!! >>>>> >>>>> On 1/31/15, Kanwaljit Singh Dhunna wrote: >>>>> > Hi Vaibhav, >>>>> > >>>>> > Thanks for the reply. >>>>> > >>>>> > I found some sample values. >>>>> > AGRS11370C - 01026025086 >>>>> > AGRS11370C - 01174026662 >>>>> > AGRS11370C - 01026053751 >>>>> > >>>>> > Above are correct values with me. You can use any incremental number >>>>> with >>>>> > AGRS11370C to check for incorrect values. >>>>> > >>>>> > On Sat, Jan 31, 2015 at 8:02 PM, Vaibhav Joshi wrote: >>>>> > >>>>> >> hi >>>>> >> >>>>> >> can you send combination of sample data which has value to create >>>>> macro >>>>> >> for sending result to printer.. >>>>> >> >>>>> >> On Sat, Jan 31, 2015 at 7:35 PM, Kanwaljit Singh Dhunna < >>>>> >> kanwal...@gmail.com> wrote: >>>>> >> >>>>> >>> Dear Experts, >>>>> >>> >>>>> >>> I am assessing the following site for a pre-defined list by >>>>> entering the >>>>> >>> requited two field like >>>>> >>> >>>>> >>> *PTLP10490E and 091189600169286.* >>>>> >>> >>>>> >>> >>>>> >>> >>>>> https://onlineservices.tin.egov-nsdl.com/TIN/JSP/tds/linktoUnAuthorizedInput.jsp >>>>> >>> >>>>> >>> The resuting page returns No Records found. But if the result is >>>>> found >>>>> >>> then I need to print the page otherwise I will move to the next >>>>> page. >>>>> >>> If the values are correct the resulting page contains the string >>>>> >>> "*Assessment >>>>> >>> Year*" >>>>> >>> >>>>> >>> I request a macro so that if the string "*Assessment Year"* is >>>>> found on >>>>> >>> the page there is some alerting sound and the page is sent to >>>>> printer >>>>> >>> automatically. Otherwise the page is not sent to printer and I can >>>>> feed >>>>> >>> the >>>>> >>> next value. >>>>> >>> >>>>> >>> Sincere Regards >>>>> >>> CA Kanwa
$$Excel-Macros$$ Macro Required
Hi Experts, I have attached a sheet. I wish there could be a macro which when run --assess the website given in column A1, --copy the value given in cell A4 in the input box --wait for me to enter the Captcha MANUALLY (as I have learnt that it is quite a tedious process via code) --copy the resulting values and paste them into the required columns in the sheet (if the input value is invalid then only Mark INVALIDPAN in column B) --copy and value given in Next Cell i.e., A5 and so on till the List is exhausted. Hope I am clear ! -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Auto-Fetch-EM.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Macro Required
Ok Sir, I will do that. I hope I am clear on my present question. On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi wrote: > You want to learn VBA then start modifying last code which i sent to you > to accommodate it.. > > Start & letus know when you get error.. > > Cheers!! > > > On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna < > kanwal...@gmail.com> wrote: > >> Hi Experts, >> >> I have attached a sheet. >> I wish there could be a macro which when run >> --assess the website given in column A1, >> --copy the value given in cell A4 in the input box >> --wait for me to enter the Captcha MANUALLY (as I have learnt that it is >> quite a tedious process via code) >> --copy the resulting values and paste them into the required columns in >> the sheet (if the input value is invalid then only Mark INVALIDPAN in >> column B) >> --copy and value given in Next Cell i.e., A5 and so on till the List is >> exhausted. >> >> Hope I am clear ! >> >> >> -- >> Sincere Regards >> CA Kanwaljit Singh Dhunna >> +91-987 6739 911 >> +91-950 1031 007 >> P*Please don't print this e-mail unless you really need to.* >> *IF U LOSE, DON'T LOSE THE LESSON.* >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Ackno
Re: $$Excel-Macros$$ Macro Required
Ok Vaibhav. Even though I have very little idea about VB (Just read the codes and try to understand them) I will give it a shot. On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi wrote: > i want you to work on present requirement... > > On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna < > kanwal...@gmail.com> wrote: > >> Ok Sir, I will do that. >> >> I hope I am clear on my present question. >> >> On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi wrote: >> >>> You want to learn VBA then start modifying last code which i sent to you >>> to accommodate it.. >>> >>> Start & letus know when you get error.. >>> >>> Cheers!! >>> >>> >>> On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna < >>> kanwal...@gmail.com> wrote: >>> >>>> Hi Experts, >>>> >>>> I have attached a sheet. >>>> I wish there could be a macro which when run >>>> --assess the website given in column A1, >>>> --copy the value given in cell A4 in the input box >>>> --wait for me to enter the Captcha MANUALLY (as I have learnt that it >>>> is quite a tedious process via code) >>>> --copy the resulting values and paste them into the required columns in >>>> the sheet (if the input value is invalid then only Mark INVALIDPAN in >>>> column B) >>>> --copy and value given in Next Cell i.e., A5 and so on till the List is >>>> exhausted. >>>> >>>> Hope I am clear ! >>>> >>>> >>>> -- >>>> Sincere Regards >>>> CA Kanwaljit Singh Dhunna >>>> +91-987 6739 911 >>>> +91-950 1031 007 >>>> P*Please don't print this e-mail unless you really need to.* >>>> *IF U LOSE, DON'T LOSE THE LESSON.* >>>> >>>> -- >>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>> https://www.facebook.com/discussexcel >>>> >>>> FORUM RULES >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> 2) Don't post a question in the thread of another member. >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> 4) Acknowledge the responses you receive, good or bad. >>>> 5) Jobs posting is not allowed. >>>> 6) Sharing copyrighted material and their links is not allowed. >>>> >>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>> and members are not responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "MS EXCEL AND VBA MACROS" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to excel-macros+unsubscr...@googlegroups.com. >>>> To post to this group, send email to excel-macros@googlegroups.com. >>>> Visit this group at http://groups.google.com/group/excel-macros. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group.
Re: $$Excel-Macros$$ Macro Required
Hi Vaibhav, Thanks for the Concern ! I understand everyone here is engaged in some profession but even then Some people like you spare time out of their busy schedule to help people out of trouble. I am a CA by profession and can do some good things in Excel but not in VBA. I tried learning VBA at some centres but none imparts VBA in the traditional sense of the learning. Also bought two books, one by John Walkenbach and other by Bill Jelen. Read some 150 pages of it. Gained some knowledge but yet I do not feel confident enough to deal with Web applications. Due to high stress of TDS returns now a days, I often come to Excel-Macros groups to find helps on issues I cannot deal with. These returns consuming a major portion of available time, even family time. So honestly even though I long to do experiments in VBA, I couldn't spare time yesterday to work on that. I understand that If I can't spend time on my issues then why anyone else should be interested in it. That's why I don't even requested again for anyone to solve it. I would certainly give it a shot, Not sure with present skills I can conclude it, but certainly there won't be any lack of efforts. Have you tried your hands on it ? On Fri, Feb 6, 2015 at 2:20 PM, Vaibhav Joshi wrote: > Hi Kanwaljit > > Any luck? > > On Thu, Feb 5, 2015 at 5:06 PM, Vaibhav Joshi wrote: > >> yes, you an do it... >> >> >> >> On Thu, Feb 5, 2015 at 5:02 PM, Kanwaljit Singh Dhunna < >> kanwal...@gmail.com> wrote: >> >>> Ok Vaibhav. Even though I have very little idea about VB (Just read the >>> codes and try to understand them) I will give it a shot. >>> >>> On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi wrote: >>> >>>> i want you to work on present requirement... >>>> >>>> On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna < >>>> kanwal...@gmail.com> wrote: >>>> >>>>> Ok Sir, I will do that. >>>>> >>>>> I hope I am clear on my present question. >>>>> >>>>> On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi wrote: >>>>> >>>>>> You want to learn VBA then start modifying last code which i sent to >>>>>> you to accommodate it.. >>>>>> >>>>>> Start & letus know when you get error.. >>>>>> >>>>>> Cheers!! >>>>>> >>>>>> >>>>>> On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna < >>>>>> kanwal...@gmail.com> wrote: >>>>>> >>>>>>> Hi Experts, >>>>>>> >>>>>>> I have attached a sheet. >>>>>>> I wish there could be a macro which when run >>>>>>> --assess the website given in column A1, >>>>>>> --copy the value given in cell A4 in the input box >>>>>>> --wait for me to enter the Captcha MANUALLY (as I have learnt that >>>>>>> it is quite a tedious process via code) >>>>>>> --copy the resulting values and paste them into the required columns >>>>>>> in the sheet (if the input value is invalid then only Mark INVALIDPAN in >>>>>>> column B) >>>>>>> --copy and value given in Next Cell i.e., A5 and so on till the List >>>>>>> is exhausted. >>>>>>> >>>>>>> Hope I am clear ! >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Sincere Regards >>>>>>> CA Kanwaljit Singh Dhunna >>>>>>> +91-987 6739 911 >>>>>>> +91-950 1031 007 >>>>>>> P*Please don't print this e-mail unless you really need to.* >>>>>>> *IF U LOSE, DON'T LOSE THE LESSON.* >>>>>>> >>>>>>> -- >>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>>>> https://www.facebook.com/discussexcel >>>>>>> >>>>>>> FORUM RULES >>>>>>> >>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>>> Advice will not get quick attention or may not be answered. >>>>>>> 2) Don't post a question in the threa
Re: $$Excel-Macros$$ Macro Required
Hi Vaibhav, Nice to know that you are a CA ! Feeling proud that poeple in our Profession are so Proficient in other Fields too ! I am certainly working on sharpening my VBA skills though at the speed I would desire too. Seems I am in the right Company :) On Fri, Feb 6, 2015 at 3:00 PM, Vaibhav Joshi wrote: > By profession i am in to CA too, n it is once personal interest n desire > to learn, since VBA is magical tool for everyone & if you expand your > knowledge it can be boon to CA office. > > Also believe me those not belonging to core VBA are also replying & > solving Queries at par with VBA experts.. > > Yes i did had hands on it & I have trial ready with me, wanted to see your > work before posting... > > Appreciate your positive response! > > Cheers!! > > > On Fri, Feb 6, 2015 at 2:51 PM, Kanwaljit Singh Dhunna < > kanwal...@gmail.com> wrote: > >> Hi Vaibhav, Thanks for the Concern ! >> >> I understand everyone here is engaged in some profession but even then >> Some people like you spare time out of their busy schedule to help people >> out of trouble. I am a CA by profession and can do some good things in >> Excel but not in VBA. I tried learning VBA at some centres but none imparts >> VBA in the traditional sense of the learning. Also bought two books, one by >> John Walkenbach and other by Bill Jelen. Read some 150 pages of it. Gained >> some knowledge but yet I do not feel confident enough to deal with Web >> applications. >> >> Due to high stress of TDS returns now a days, I often come to >> Excel-Macros groups to find helps on issues I cannot deal with. These >> returns consuming a major portion of available time, even family time. So >> honestly even though I long to do experiments in VBA, I couldn't spare time >> yesterday to work on that. I understand that If I can't spend time on my >> issues then why anyone else should be interested in it. That's why I don't >> even requested again for anyone to solve it. I would certainly give it a >> shot, Not sure with present skills I can conclude it, but certainly there >> won't be any lack of efforts. >> >> Have you tried your hands on it ? >> >> On Fri, Feb 6, 2015 at 2:20 PM, Vaibhav Joshi wrote: >> >>> Hi Kanwaljit >>> >>> Any luck? >>> >>> On Thu, Feb 5, 2015 at 5:06 PM, Vaibhav Joshi wrote: >>> >>>> yes, you an do it... >>>> >>>> >>>> >>>> On Thu, Feb 5, 2015 at 5:02 PM, Kanwaljit Singh Dhunna < >>>> kanwal...@gmail.com> wrote: >>>> >>>>> Ok Vaibhav. Even though I have very little idea about VB (Just read >>>>> the codes and try to understand them) I will give it a shot. >>>>> >>>>> On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi wrote: >>>>> >>>>>> i want you to work on present requirement... >>>>>> >>>>>> On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna < >>>>>> kanwal...@gmail.com> wrote: >>>>>> >>>>>>> Ok Sir, I will do that. >>>>>>> >>>>>>> I hope I am clear on my present question. >>>>>>> >>>>>>> On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi wrote: >>>>>>> >>>>>>>> You want to learn VBA then start modifying last code which i sent >>>>>>>> to you to accommodate it.. >>>>>>>> >>>>>>>> Start & letus know when you get error.. >>>>>>>> >>>>>>>> Cheers!! >>>>>>>> >>>>>>>> >>>>>>>> On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna < >>>>>>>> kanwal...@gmail.com> wrote: >>>>>>>> >>>>>>>>> Hi Experts, >>>>>>>>> >>>>>>>>> I have attached a sheet. >>>>>>>>> I wish there could be a macro which when run >>>>>>>>> --assess the website given in column A1, >>>>>>>>> --copy the value given in cell A4 in the input box >>>>>>>>> --wait for me to enter the Captcha MANUALLY (as I have learnt that >>>>>>>>> it is quite a tedious process via code) >>>>>>>>> --copy the resulting values and paste them into the required >>>>>>>>> column
Re: $$Excel-Macros$$ Macro Required
Hi Mr. Ashu, That's Great ! Thanks a Lot for the Encouraging Words! Definitely I want to learn VBA. Any guidance in this regard is Most Welcome ! On Fri, Feb 6, 2015 at 3:10 PM, Ashu k wrote: > Hi Mr. Kanwaljit, > > By profession I am CA and Successfully completed Phd. too > > You want to lean VBA. > > Reply me, I am ready to help you personally and professionally. > > Regards > Ashu Kenith > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google 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$$ Macro Required
I am from Zira, District Ferozepur, Punjab Presently residing in Sirhind, Near Chandigarh. On Fri, Feb 6, 2015 at 3:32 PM, Ashu k wrote: > Hi Mr. Dhunna, > > Where are you from..? > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google 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$$ Allocating plots of Lands
Hello Sir, 2858 hectares to be allocated between three surveyors. i.e., approx 952 hectares for each surveyors. http://summatch.com/Admin_Pages/DownloadSumMatch.aspx might help you. Have a Look. On Mon, Feb 2, 2015 at 4:09 AM, Salvation wrote: > Hi there i have twenty two plots of land and i want to allocate as much as > possible equal number of hectare of land to three land surveyors for > processing. the solution should group the allocated lands to the three > surveyors so that when you sum the number of hectares allocated to each > surveyor you get equal or nearly equal distribution. attached is an excel > sheet with the problem please. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google 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. plot to allocate.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Macro Required
Thanks ! Any tip on how to the Debugger in VBA ? On Fri, Feb 6, 2015 at 4:11 PM, Ashu k wrote: > Hi Mr. Kanwaljeet, > > Find the attachment. See the power of VBA. > > And try to make this. > > > > Regards > Ashu Kenith > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google 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$$ Allocating plots of Lands
Yes Vaibhav ! As Usual you are right ! On Sun, Feb 8, 2015 at 10:47 PM, Vaibhav Joshi wrote: > Also you can do using solver > > On Sun, Feb 8, 2015 at 12:00 AM, Kanwaljit Singh Dhunna < > kanwal...@gmail.com> wrote: > >> Hello Sir, >> >> 2858 hectares to be allocated between three surveyors. i.e., approx 952 >> hectares for each surveyors. >> >> http://summatch.com/Admin_Pages/DownloadSumMatch.aspx >> might help you. >> >> Have a Look. >> >> On Mon, Feb 2, 2015 at 4:09 AM, Salvation wrote: >> >>> Hi there i have twenty two plots of land and i want to allocate as much >>> as possible equal number of hectare of land to three land surveyors for >>> processing. the solution should group the allocated lands to the three >>> surveyors so that when you sum the number of hectares allocated to each >>> surveyor you get equal or nearly equal distribution. attached is an excel >>> sheet with the problem please. >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Sincere Regards >> CA Kanwaljit Singh Dhunna >> +91-987 6739 911 >> +91-950 1031 007 >> P*Please don't print this e-mail unless you really need to.* >> *IF U LOSE, DON'T LOSE THE LESSON.* >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google 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
Re: $$Excel-Macros$$ find exact value contains special characters like *, ?, #, " excel cells using match function
Try the following *Array* Formula
=MATCH(SUBSTITUTE("aaa*","*","|",1),SUBSTITUTE(A1:A2,"*","|",1),0)
On Wed, May 6, 2015 at 11:06 PM, Divaker Pandey wrote:
> say if cell a1 contains a text
> and a2 contains aaa*
> and i used match function =match("aaa*",A1:A2",0)
> it should return 2
>
> 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.
>
--
Sincere Regards
CA Kanwaljit Singh Dhunna
+91-987 6739 911
+91-950 1031 007
P*Please don't print this e-mail unless you really need to.*
*IF U LOSE, DON'T LOSE THE LESSON.*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google 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$$ Macro Required
Hi Vaibhav, Can You refer any good article where I can understand how to use the Debugger in VBA ? On Fri, Feb 6, 2015 at 2:20 PM, Vaibhav Joshi wrote: > Hi Kanwaljit > > Any luck? > > On Thu, Feb 5, 2015 at 5:06 PM, Vaibhav Joshi wrote: > >> yes, you an do it... >> >> >> >> On Thu, Feb 5, 2015 at 5:02 PM, Kanwaljit Singh Dhunna < >> kanwal...@gmail.com> wrote: >> >>> Ok Vaibhav. Even though I have very little idea about VB (Just read the >>> codes and try to understand them) I will give it a shot. >>> >>> On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi wrote: >>> >>>> i want you to work on present requirement... >>>> >>>> On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna < >>>> kanwal...@gmail.com> wrote: >>>> >>>>> Ok Sir, I will do that. >>>>> >>>>> I hope I am clear on my present question. >>>>> >>>>> On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi wrote: >>>>> >>>>>> You want to learn VBA then start modifying last code which i sent to >>>>>> you to accommodate it.. >>>>>> >>>>>> Start & letus know when you get error.. >>>>>> >>>>>> Cheers!! >>>>>> >>>>>> >>>>>> On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna < >>>>>> kanwal...@gmail.com> wrote: >>>>>> >>>>>>> Hi Experts, >>>>>>> >>>>>>> I have attached a sheet. >>>>>>> I wish there could be a macro which when run >>>>>>> --assess the website given in column A1, >>>>>>> --copy the value given in cell A4 in the input box >>>>>>> --wait for me to enter the Captcha MANUALLY (as I have learnt that >>>>>>> it is quite a tedious process via code) >>>>>>> --copy the resulting values and paste them into the required columns >>>>>>> in the sheet (if the input value is invalid then only Mark INVALIDPAN in >>>>>>> column B) >>>>>>> --copy and value given in Next Cell i.e., A5 and so on till the List >>>>>>> is exhausted. >>>>>>> >>>>>>> Hope I am clear ! >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Sincere Regards >>>>>>> CA Kanwaljit Singh Dhunna >>>>>>> +91-987 6739 911 >>>>>>> +91-950 1031 007 >>>>>>> P*Please don't print this e-mail unless you really need to.* >>>>>>> *IF U LOSE, DON'T LOSE THE LESSON.* >>>>>>> >>>>>>> -- >>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>>>> https://www.facebook.com/discussexcel >>>>>>> >>>>>>> FORUM RULES >>>>>>> >>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>>> Advice will not get quick attention or may not be answered. >>>>>>> 2) Don't post a question in the thread of another member. >>>>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>>>> measure. >>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>> 5) Jobs posting is not allowed. >>>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>>> >>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>>>> and members are not responsible for any loss. >>>>>>> --- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> 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. >&g
Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
t;>>>> https://groups.google.com/**grou**ps/opt_out<https://groups.google.com/groups/opt_out> >>>>> . >>>>> >>>>> >>>>> >>>> >>>> >>>> >>>> -- >>>> With Regards, >>>> Noorain Ansari >>>> http:// >>>> <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> >>>> http:// >>>> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com><http://accesssqclinic.blogspot.in/> >>>> >>>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And 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...@**googlegroups.com. >>> To post to this group, send email to excel-...@googlegroups.com. >>> Visit this group at >>> http://groups.google.com/**group/excel-macros<http://groups.google.com/group/excel-macros> >>> . >>> 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. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google 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.
Re: $$Excel-Macros$$ Re: Vlookup Choose Query - HELP
Dear Ashish,
I couldn't make out why you chose to use Choose function here. Am I missing
something ?
On Tue, Jul 16, 2013 at 7:35 PM, Kuldeep Singh wrote:
> Your Welcome Ashish.
>
> Regards,
> Kuldeep Singh
> Assistant Manager Quality
> Game Zone India Limited
> Phone.: +91-9716615535
> || naukrikuld...@gmail.com ||
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
>
> On Tue, Jul 16, 2013 at 7:33 PM, Ashish Kumar
> wrote:
>
>> Dear Kuldeep Sir,
>>
>> As per your instruction, I'll put the formula and follow the steps which
>> is suggested by you, and i'll get the wright output. Thanks for your
>> response and support.
>>
>>
>> Thanks a lot sir..!!! :)
>>
>> Thanks,
>> Ashish
>>
>>
>> On 16 July 2013 19:13, Kuldeep Singh wrote:
>>
>>> Hi Ashish,
>>>
>>> First : Select 4 Rows like : J, K, L, M & Paste this formula
>>> *=VLOOKUP(I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0)
>>> & Press Ctrl + Shift + Enter then select J3:M20 & **Drag formula like
>>> Ctrl + D. It's working fine.*
>>>
>>> Regards,
>>> Kuldeep Singh
>>> Assistant Manager Quality
>>> Game Zone India Limited
>>> Phone.: +91-9716615535
>>> || naukrikuld...@gmail.com ||
>>> *Please* *Consider the environment. Please don't print this e-mail
>>> unless you really need to.*
>>>
>>> On Tue, Jul 16, 2013 at 7:05 PM, Ashish Kumar >> > wrote:
>>>
>>>> Dear Kuldeep Sir,
>>>>
>>>> Thanks for your response, but again I'hve getting same error in
>>>> formula, I'hve getting wrigh output when i put the formula in Name Column,
>>>> but when i paste the same formula in rest of fields like address, process,
>>>> salary...!! the formula is not working and I'hve use this formula with CSE.
>>>> Please suggest me, how i am resolve this.
>>>>
>>>>
>>>> Thanks
>>>> 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/groups/opt_out.
>
>
>
--
Sincere Regards
CA Kanwaljit Singh Dhunna
+91-987 6739 911
+91-950 1031 007
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google 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.
Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
a question in the thread of another member. >>>>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>>>> measure. >>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>> 5) Jobs posting is not allowed. >>>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>>> >>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>>>> and members are not responsible for any loss. >>>>>>> --- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> 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.**c**om. >>>>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>>>> >>>>>>> Visit this group at http://groups.google.com/**group >>>>>>> /excel-macros <http://groups.google.com/group/excel-macros>. >>>>>>> For more options, visit https://groups.google.com/**grou >>>>>>> ps/opt_out <https://groups.google.com/groups/opt_out>. >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> With Regards, >>>>>> Noorain Ansari >>>>>> http:// >>>>>> <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> >>>>>> http:// >>>>>> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com><http://accesssqclinic.blogspot.in/> >>>>>> >>>>>> -- >>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>> https://www.facebook.com/**discu**ssexcel<https://www.facebook.com/discussexcel> >>>>> >>>>> FORUM RULES >>>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>> Advice will not get quick attention or may not be answered. >>>>> 2) Don't post a question in the thread of another member. >>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>> measure. >>>>> 4) Acknowledge the responses you receive, good or bad. >>>>> 5) Jobs posting is not allowed. >>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>> >>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>> and members are not responsible for any loss. >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> 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<http://groups.google.com/group/excel-macros> >>>>> . >>>>> For more options, visit >>>>> https://groups.google.com/**grou**ps/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.
Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
So In nutshell Choose Function was used here as per choice of the person
and not out of any compulsion or requirement !
On Tue, Jul 16, 2013 at 8:12 PM, wrote:
> **
> Thanks Noorain Bhai and Kuldeep Bhai for the explanation.
>
>
> Sandeep Chhajer.
> Sent on my BlackBerry® from Vodafone
> --
> *From: * NOORAIN ANSARI
> *Sender: * excel-macros@googlegroups.com
> *Date: *Tue, 16 Jul 2013 20:08:00 +0530
> *To: *excel-macros@googlegroups.com
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
>
> Dear Sandeep,
>
> Your question is correct, why we are using choose function, because it is
> possible through only vlookup Function, no need to using choose Function.
>
> But As per Question of Mr. Ashish Kumar, He want to use Choose function
> with Vlookup.
> We often use Choose function with vlookup to extract left side value,
> although it is also
> Possible through.. Index, Offset, Lookup and Indirect function.
>
>
> Hope you will understand, we used Choose function as per user requirement.
>
>
>
>
>
>
>
>
> On Tue, Jul 16, 2013 at 7:51 PM, wrote:
>
>> **
>> Dear All,
>> My question is also the same why we are using choose funtion here! If any
>> one please explain the same then will be very thankful.
>>
>>
>> Sandeep Chhajer.
>> Sent on my BlackBerry® from Vodafone
>> --
>> *From: * Kanwaljit Singh Dhunna
>> *Sender: * excel-macros@googlegroups.com
>> *Date: *Tue, 16 Jul 2013 19:46:02 +0530
>> *To: *
>> *ReplyTo: * excel-macros@googlegroups.com
>> *Subject: *Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
>>
>> Dear Ashish,
>>
>> Still Curious to know why do you use Choose here ?
>>
>> On Tue, Jul 16, 2013 at 7:40 PM, Ashish Kumar
>> wrote:
>>
>>> Dear Seniors,
>>>
>>> Formula is working fine.
>>> Thanks for your help and support specially Noorain Sir, Kuldeep Sir and
>>> kanwaljit sir.
>>>
>>> Thanks
>>> Ashish
>>>
>>>
>>> On Tuesday, July 16, 2013 7:26:49 PM UTC+5:30, kanwal_no1 wrote:
>>>
>>>> As told by Kuldeep Ji with a small change, which might be causing
>>>> trouble for you.
>>>> First : Select 4 Rows like : J, K, L, M & Paste this formula *=VLOOKUP(
>>>> **$**I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$
>>>> B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0) & Press Ctrl + Shift
>>>> + Enter then select J2:M20 & **Drag formula like Ctrl + D. It's
>>>> working fine.*
>>>>
>>>> BTW what is the issue in choosing simple Vlookup here ?
>>>>
>>>> On Tue, Jul 16, 2013 at 7:10 PM, Ashish Kumar wrote:
>>>>
>>>>> Dear Seniors,
>>>>>
>>>>> Thanks for your help, but again i'hve geting same error. querry
>>>>> attached please find. and help me to crack the query.
>>>>>
>>>>> I'hve getting wrigh output when i put the formula in Name Column, but
>>>>> when i paste the same formula in rest of fields like address, process,
>>>>> salary...!! the formula is not working and I'hve use this formula with
>>>>> CSE.
>>>>> Please suggest me, how i am resolve this.
>>>>>
>>>>>
>>>>>
>>>>> Thanks
>>>>> Ashish
>>>>>
>>>>>
>>>>> On Tuesday, July 16, 2013 6:49:40 PM UTC+5:30, Kuldeep Singh wrote:
>>>>>
>>>>>> Hi Ashish,
>>>>>>
>>>>>> Formula is working fine. Please find the attachment.
>>>>>>
>>>>>> *Use formula with Ctrl + Shift + Enter (Select All Rows & Press Ctrl
>>>>>> + Shift + Enter).*
>>>>>>
>>>>>> Regards,
>>>>>> Kuldeep Singh
>>>>>> Assistant Manager Quality
>>>>>> Game Zone India Limited
>>>>>> Phone.: +91-9716615535
>>>>>> || naukri...@gmail.com ||
>>>>>>
>>>>>> *Please* *Consider the environment. Please don't print this e-mail
>>>>>> unless you really need to.*
>>>>>>
>>>>>> On Tue, Jul 16, 2013 at 6:42 PM, Ashish Kumar
>>>>>> wrote:
>>>>>>
>>>>>>> Dear Seniors,
>>>>>>>
Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
Thanks Ashwin,
That was an interesting one.
I never came across any such alternative.
Thanks Again !
On Wed, Jul 17, 2013 at 12:21 AM, ashwani agnihotri <
ashwani.agniho...@gmail.com> wrote:
> hey plz go through this link for better understanding of using choose with
> vlookup..
>
> http://www.myonlinetraininghub.com/excel-vlookup-to-the-left-using-choose
>
>
> On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar
> wrote:
>
>>
>>
>> Dear Seniors,
>>
>> kindly find attached vlookup query, I want get output thru vlookup choose
>> function. please help me on this query and please explain me why we use
>> {1,2,3,4,} in formula.
>> Thanks in advance.
>>
>>
>>
>> Thanks
>> 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/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.
>
>
>
--
Sincere Regards
CA Kanwaljit Singh Dhunna
+91-987 6739 911
+91-950 1031 007
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google 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.
