RE: $$Excel-Macros$$ What is Ylookup in Excel...
I have year only two dimension in excel. One is vertical another one horizontal , for that we have Vlookup and HLookup , I don't think if any Ylookup is there J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kuldeep Singh Sent: 16 February 2013 12:58 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ What is Ylookup in Excel... @ Vijay: No, is this not a typing mistake because Vlookup Hlookup also type correct IIIrd Ylookup is specify in job posting in moster site. Regards, Kuldeep Singh Info Edge India Limited (naukri.com http://naukri.com/ ) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com http://www.naukri.com/ Please Consider the environment. Please don't print this e-mail unless you really need to. On Sat, Feb 16, 2013 at 12:54 PM, vijayajith VA vijayajith...@gmail.com wrote: looks typo On Sat, Feb 16, 2013 at 12:52 PM, Kuldeep Singh naukrikuld...@gmail.com wrote: Hi Vijay, I know Ylookup is not available in Any Excel. For more information please see below URL: http://jobs.monsterindia.com/details/12696222.html Same Line in URL : Knwoledge:- V-look up, Y-look up, H-look up (in excel master ) SENSYS EASY PAY . TDS. Regards, Kuldeep Singh Info Edge India Limited (naukri.com http://naukri.com/ ) Phone.: +91-0120-4841100 tel:%2B91-0120-4841100 , Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com http://www.naukri.com/ Please Consider the environment. Please don't print this e-mail unless you really need to. On Sat, Feb 16, 2013 at 12:48 PM, vijayajith VA vijayajith...@gmail.com wrote: Hi Kuldeep, Where did you got ths information. pls share. i dont have idea. Thr is no Ylookup in excel..thanks On Sat, Feb 16, 2013 at 12:00 PM, Kuldeep Singh naukrikuld...@gmail.com wrote: Hi Experts, What is Ylookup in Excel. I know only Vlookup, Hlookup Lookup. If you know, please give some examples of Ylookup. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100 tel:%2B91-0120-4841100 , Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com http://www.naukri.com/ Please Consider the environment. Please don't print this e-mail unless you really need to. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros%2bunsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros%2bunsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit
RE: $$Excel-Macros$$ Query
Shortest is this Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: 15 February 2013 4:34 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query Hi Chauan, Use ths UDF.. Function RevStr(Rng As Range) RevStr = StrReverse(Rng.Text) End Function On Fri, Feb 15, 2013 at 4:23 PM, neeraj chauhan neerajchauhan...@gmail.com wrote: Dear Experts, kindly find the attached sheet and send the formula in excel for reverse value -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros%2bunsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ how to get cumulative sum in a cell
I suggest restarting the computer. In win8 it is not obvious how to do this. I type the Windows key and then type Shutdown. this brings up the shutdown App. Then you click Commands in the menu and restart. Regards David Grugeon On 16 February 2013 03:23, anton a...@kwic.com wrote: Hi Dave, I am afraid there is something weird going on. even in a blank spreadsheet, if I try to open the VB editor, it gives me an out of memory error. I don't believe it. I have 8 GB ram. also the macro you sent me works in excel 97 and exel 2010. but I can't open it or edit it in my accounting spreadsheet under windows 8?? I was able to open the macro on the old computer with excel 97 and its name is private sub worksheet_change(byval target as range) any suggestions greatly appreciated. anton On Friday, 25 June 2010 13:09:45 UTC-4, Dave wrote: Hi Anton, Glad it works well for you. To keep the cursor in the same cell, add the following line to your code: Target.Select So the macro will now look like this: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then Target.Offset(0, 1) = Target.Offset(0, 1) + Target Target.Select End Sub Regards - Dave. Date: Thu, 24 Jun 2010 10:25:48 -0700 Subject: Re: $$Excel-Macros$$ how to get cumulative sum in a cell From: a...@kwic.com To: excel-...@googlegroups.com Hi Dave, your code works very well. it seems to work for text in col B which gives the same text in col C. I decided to make 2 columns for every month of the year. so i just added more similar lines if target =4 etc, if target =6 etc in your code. we still have all the accounts on paper for every month if needed.(we write down expenses etc in a book each day but only enter data in spreadsheet once a year) This will save us the trouble of adding up each grocery expense etc by hand for each month and then entering it in the spreadsheet. Thanks very much for your help. Anton ps one more question. when i press the enter key, the cursor moves down one cell. how do i make the cursor stay on the same cell so i can enter a series of grocery expenses without moving the cursor up one cell each time? On Jun 24, 9:54 am, Dave Bonallack davebonall...@hotmail.com wrote: Hi Anton,Attached is a sheet with very simple code. Enter a value into a cell in Column B, and you will see the adjacent cell in Col C increase by that amount. Since this is done by VBA, there is no formula in the Col C cells, so you can make manual corrections there if you want. You should note that using this method gives you no record of past entries, since only the last entry is retained in Col B cells. Previous entries are constantly over-writtenIf you enter non-numeric data into Col B, the macro will fault. If this sheet is just for personal use, then it doesn't really matter, but we could test for non-numeric input if needed. Regards - Dave. Date: Thu, 24 Jun 2010 03:36:37 -0700 Subject: Re: $$Excel-Macros$$ how to get cumulative sum in a cell From: a...@kwic.com To: excel-...@googlegroups.com Hi Dave, Thanks very much for your reply. Yes this would be sufficient. Your suggestion that XL can monitor changes to A2 and store the cumulative total in A3 would be great. I would have about 50 similar accounts such as gas, books, donations, repairs etc. Would you be able to construct this macro? Best Regards, anton On Jun 24, 1:49 am, Dave Bonallack davebonall...@hotmail.com wrote: Hi Anton, XL can almost do what you want, which may be sufficient for you. If you want to be able to enter your grocery expenditure always in the same cell, XL can accumulate those entries in another cell using VBA. For example, You may enter your grocery expenditure always into A2, but the actual accumulated total would appear in A3 (or any other cell you like). This can be done by clicking a button after each entry into A2, or XL can monitor changes to A2 and do the accumulation automatically. If this suits your purpose, there are lots of us in the group who could help you achieve this. Regards - Dave. Date: Wed, 23 Jun 2010 11:22:58 -0700 Subject: $$Excel-Macros$$ how to get cumulative sum in a cell From: a...@kwic.com To: excel-...@googlegroups.com Dear Group, I am constructing a single entry accounting spreadsheet in excel. i would like to input numbers for, say grocery expenses, in a cell of fixed location. when I buy more groceries i would like to type in the new expense in the same cell so that the output of that cell is the cumulative total expenses for groceries. any way to do this in excel? Thanks for reading, anton -- --**--* *------ Some important links for excel
Re: $$Excel-Macros$$ What is Ylookup in Excel...
Perhaps it is an employment test. Anyone who knew Excel would know there is no Ylookup. Someone who was not familiar with excel might invent a menaing for it! Regards David Grugeon On 16 February 2013 18:57, Rajan_Verma rajanverma1...@gmail.com wrote: *I have year only two dimension in excel. One is vertical another one horizontal , for that we have Vlookup and HLookup , I don’t think if any Ylookup is there **J*** * * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kuldeep Singh *Sent:* 16 February 2013 12:58 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ What is Ylookup in Excel... ** ** ** ** @ Vijay: ** ** No, is this not a typing mistake because Vlookup Hlookup also type correct IIIrd Ylookup is specify in job posting in moster site. ** ** Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* ** ** On Sat, Feb 16, 2013 at 12:54 PM, vijayajith VA vijayajith...@gmail.com wrote: looks typo ** ** On Sat, Feb 16, 2013 at 12:52 PM, Kuldeep Singh naukrikuld...@gmail.com wrote: ** ** Hi Vijay, ** ** I know Ylookup is not available in Any Excel. For more information please see below URL: ** ** http://jobs.monsterindia.com/details/12696222.html ** ** Same Line in URL : Knwoledge:- *V-look up, Y-look up, H-look up (in excel master ) SENSYS EASY PAY . TDS.* ** ** Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* ** ** On Sat, Feb 16, 2013 at 12:48 PM, vijayajith VA vijayajith...@gmail.com wrote: Hi Kuldeep, ** ** Where did you got ths information. pls share. i dont have idea. ** ** Thr is no Ylookup in excel..thanks ** ** On Sat, Feb 16, 2013 at 12:00 PM, Kuldeep Singh naukrikuld...@gmail.com wrote: ** ** Hi Experts, ** ** What is *Ylookup in Excel*. I know only Vlookup, Hlookup Lookup. If you know, please give some examples of Ylookup. ** ** Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. ** ** -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS
Re: $$Excel-Macros$$ What is Ylookup in Excel...
Is this correct reason. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* * * On Sat, Feb 16, 2013 at 2:39 PM, David Grugeon da...@grugeon.com.au wrote: Perhaps it is an employment test. Anyone who knew Excel would know there is no Ylookup. Someone who was not familiar with excel might invent a menaing for it! Regards David Grugeon On 16 February 2013 18:57, Rajan_Verma rajanverma1...@gmail.com wrote: *I have year only two dimension in excel. One is vertical another one horizontal , for that we have Vlookup and HLookup , I don’t think if any Ylookup is there **J*** * * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kuldeep Singh *Sent:* 16 February 2013 12:58 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ What is Ylookup in Excel... ** ** ** ** @ Vijay: ** ** No, is this not a typing mistake because Vlookup Hlookup also type correct IIIrd Ylookup is specify in job posting in moster site. ** ** Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* ** ** On Sat, Feb 16, 2013 at 12:54 PM, vijayajith VA vijayajith...@gmail.com wrote: looks typo ** ** On Sat, Feb 16, 2013 at 12:52 PM, Kuldeep Singh naukrikuld...@gmail.com wrote: ** ** Hi Vijay, ** ** I know Ylookup is not available in Any Excel. For more information please see below URL: ** ** http://jobs.monsterindia.com/details/12696222.html ** ** Same Line in URL : Knwoledge:- *V-look up, Y-look up, H-look up (in excel master ) SENSYS EASY PAY . TDS.* ** ** Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* ** ** On Sat, Feb 16, 2013 at 12:48 PM, vijayajith VA vijayajith...@gmail.com wrote: Hi Kuldeep, ** ** Where did you got ths information. pls share. i dont have idea. ** ** Thr is no Ylookup in excel..thanks ** ** On Sat, Feb 16, 2013 at 12:00 PM, Kuldeep Singh naukrikuld...@gmail.com wrote: ** ** Hi Experts, ** ** What is *Ylookup in Excel*. I know only Vlookup, Hlookup Lookup. If you know, please give some examples of Ylookup. ** ** Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. ** ** -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security
Re: $$Excel-Macros$$ What is Ylookup in Excel...
Perhaps it is an employment test. Anyone who knew Excel would know there is no Ylookup. Someone who was not familiar with excel might invent a meaning for it! Regards David Grugeon -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ What is Ylookup in Excel...
Okay Thanks. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Sat, Feb 16, 2013 at 2:46 PM, David Grugeon da...@grugeon.com.au wrote: Perhaps it is an employment test. Anyone who knew Excel would know there is no Ylookup. Someone who was not familiar with excel might invent a meaning for it! Regards David Grugeon -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ add in for chart
hi is there a macro or add in for an CONTROL Charts in Excel? please advise -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ how to get cumulative sum in a cell
Hi David, I restarted the computer and now when I try to open VB editor, it tells me VBE6EXT.OLB could not be loaded. I guess I will have to take the computer back to the store so they can reload excel? Thanks for your suggestion, anton On Saturday, 16 February 2013 04:02:26 UTC-5, David Grugeon wrote: I suggest restarting the computer. In win8 it is not obvious how to do this. I type the Windows key and then type Shutdown. this brings up the shutdown App. Then you click Commands in the menu and restart. Regards David Grugeon On 16 February 2013 03:23, anton a...@kwic.com javascript: wrote: Hi Dave, I am afraid there is something weird going on. even in a blank spreadsheet, if I try to open the VB editor, it gives me an out of memory error. I don't believe it. I have 8 GB ram. also the macro you sent me works in excel 97 and exel 2010. but I can't open it or edit it in my accounting spreadsheet under windows 8?? I was able to open the macro on the old computer with excel 97 and its name is private sub worksheet_change(byval target as range) any suggestions greatly appreciated. anton On Friday, 25 June 2010 13:09:45 UTC-4, Dave wrote: Hi Anton, Glad it works well for you. To keep the cursor in the same cell, add the following line to your code: Target.Select So the macro will now look like this: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then Target.Offset(0, 1) = Target.Offset(0, 1) + Target Target.Select End Sub Regards - Dave. Date: Thu, 24 Jun 2010 10:25:48 -0700 Subject: Re: $$Excel-Macros$$ how to get cumulative sum in a cell From: a...@kwic.com To: excel-...@googlegroups.com Hi Dave, your code works very well. it seems to work for text in col B which gives the same text in col C. I decided to make 2 columns for every month of the year. so i just added more similar lines if target =4 etc, if target =6 etc in your code. we still have all the accounts on paper for every month if needed.(we write down expenses etc in a book each day but only enter data in spreadsheet once a year) This will save us the trouble of adding up each grocery expense etc by hand for each month and then entering it in the spreadsheet. Thanks very much for your help. Anton ps one more question. when i press the enter key, the cursor moves down one cell. how do i make the cursor stay on the same cell so i can enter a series of grocery expenses without moving the cursor up one cell each time? On Jun 24, 9:54 am, Dave Bonallack davebonall...@hotmail.com wrote: Hi Anton,Attached is a sheet with very simple code. Enter a value into a cell in Column B, and you will see the adjacent cell in Col C increase by that amount. Since this is done by VBA, there is no formula in the Col C cells, so you can make manual corrections there if you want. You should note that using this method gives you no record of past entries, since only the last entry is retained in Col B cells. Previous entries are constantly over-writtenIf you enter non-numeric data into Col B, the macro will fault. If this sheet is just for personal use, then it doesn't really matter, but we could test for non-numeric input if needed. Regards - Dave. Date: Thu, 24 Jun 2010 03:36:37 -0700 Subject: Re: $$Excel-Macros$$ how to get cumulative sum in a cell From: a...@kwic.com To: excel-...@googlegroups.com Hi Dave, Thanks very much for your reply. Yes this would be sufficient. Your suggestion that XL can monitor changes to A2 and store the cumulative total in A3 would be great. I would have about 50 similar accounts such as gas, books, donations, repairs etc. Would you be able to construct this macro? Best Regards, anton On Jun 24, 1:49 am, Dave Bonallack davebonall...@hotmail.com wrote: Hi Anton, XL can almost do what you want, which may be sufficient for you. If you want to be able to enter your grocery expenditure always in the same cell, XL can accumulate those entries in another cell using VBA. For example, You may enter your grocery expenditure always into A2, but the actual accumulated total would appear in A3 (or any other cell you like). This can be done by clicking a button after each entry into A2, or XL can monitor changes to A2 and do the accumulation automatically. If this suits your purpose, there are lots of us in the group who could help you achieve this. Regards - Dave. Date: Wed, 23 Jun 2010 11:22:58 -0700 Subject: $$Excel-Macros$$ how to get cumulative sum in a cell From: a...@kwic.com To: excel-...@googlegroups.com Dear Group, I am constructing a single entry accounting spreadsheet in excel. i would like to input numbers for, say grocery expenses, in a cell of fixed location. when I buy more groceries i would like
Re: $$Excel-Macros$$ add in for chart
Hi Sara I don't quite understand. Could you Tell us what you want to do, and why you cannot do it with standard Excel tools? On Sunday, 17 February 2013, Sara Lee wrote: hi is there a macro or add in for an CONTROL Charts in Excel? please advise -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com javascript:_e({}, 'cvml', 'excel-macros%2bunsubscr...@googlegroups.com');. To post to this group, send email to excel-macros@googlegroups.comjavascript:_e({}, 'cvml', 'excel-macros@googlegroups.com'); . Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards David Grugeon -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.