Re: $$Excel-Macros$$ Dairy 2012
Thanks Murali On Mon, Jan 16, 2012 at 2:21 PM, muralidhar e emuralidha...@gmail.comwrote: Hi, Dear all wish u happy sankranti(Pongal) and a digital dairy gift for all. -- *Thanks Regards,* ** *Muralidhar E.* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ convert numbers into words
Dear Team Can we have a formula which converts numbers in to word? E.g. I have 23 in A1 so by formula we need Twenty Three Only We do not need Rupees or pound any just simple word -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Dairy 2012
thank you Muralidhar, It is nice. sanjib On Mon, Jan 16, 2012 at 2:21 PM, muralidhar e emuralidha...@gmail.comwrote: Hi, Dear all wish u happy sankranti(Pongal) and a digital dairy gift for all. -- *Thanks Regards,* ** *Muralidhar E.* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- - -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ convert numbers into words
Thanks Noorain On Mon, Jan 16, 2012 at 4:54 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Priyanka, Please see attached sheet with Excel VBA both -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Jan 16, 2012 at 4:42 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Team Can we have a formula which converts numbers in to word? E.g. I have 23 in A1 so by formula we need Twenty Three Only We do not need Rupees or pound any just simple word -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Running/Moving Statement
Hi Friend, Yes this is exactly I wanted. However I am unable to use the MS Excel when I click the Start button. It seems the Excel gets hanged. Any solution for that. Mover what do we call these moving lines in excel. Regards Santosh santoshkumar.subu...@gmail.com Date: Sat, 14 Jan 2012 20:46:32 +0530 Subject: Re: $$Excel-Macros$$ Running/Moving Statement From: xlst...@gmail.com To: excel-macros@googlegroups.com Hi Santosh, yes it is possible, please find the attachment On Sat, Jan 14, 2012 at 4:56 PM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hi Group, Is it possible to show a statement moving from right to left in MS Excel that we usually see in websites or in our system screen savers. If yes please help me with this. -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Copy of marque.xlsm Description: Binary data
Re: $$Excel-Macros$$ Running/Moving Statement
That is what will happen with xl2003. Don Guillett SalesAid Software dguille...@gmail.com From: santosh subudhi Sent: Monday, January 16, 2012 8:15 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Running/Moving Statement Hi Friend, Yes this is exactly I wanted. However I am unable to use the MS Excel when I click the Start button. It seems the Excel gets hanged. Any solution for that. Mover what do we call these moving lines in excel. Regards Santosh santoshkumar.subu...@gmail.com Date: Sat, 14 Jan 2012 20:46:32 +0530 Subject: Re: $$Excel-Macros$$ Running/Moving Statement From: xlst...@gmail.com To: excel-macros@googlegroups.com Hi Santosh, yes it is possible, please find the attachment On Sat, Jan 14, 2012 at 4:56 PM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hi Group, Is it possible to show a statement moving from right to left in MS Excel that we usually see in websites or in our system screen savers. If yes please help me with this. -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Vlookup Help
Dear Team, I am creating macro for Recon of prices where facing problem in multiple vlookup. Find attached Recon file. Please any one help me the multiple vlookup function/coding multiple vlookup. Thanking in Advance. Regards, Shrinivas -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Recon.xls Description: Recon.xls
Re: $$Excel-Macros$$ Re: Help On Print
Here's how you do it. Regards, Sam Mathai Chacko On Mon, Jan 16, 2012 at 12:26 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear Rohan I was trying to do it for me but I could not I am attaching the work sheet Please do it and please let me know what is the problem Why I could not do it? If I am doing it I can see only heading Please help Thanks in advanced Regards Shrinivas On Tue, Dec 20, 2011 at 7:11 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: Very very thanks for help On Mon, Dec 19, 2011 at 1:10 PM, Rohan bittu.ro...@gmail.com wrote: If you can replicate this for your own sheetwell and good. Else send the worksheet over the group as an attachemnt and I will work that out. !! Thank you ! Sub Test() Dim SDate As DateDim EDate As DateLR = Range(A1).End(xlDown).RowSDate = InputBox(Put the date from when you want to take print out?)EDate = InputBox(Put the last date till what you want to take print out?) Sheets(Sheet1).SelectFor i = SDate To EDate Rows(1:1).SelectSelection.AutoFilter ActiveSheet.Range(A1:B LR).AutoFilter Field:=1, Criteria1:=i ActiveWindow.SelectedSheets.PrintOut Copies:=1 Rows(1:1).SelectSelection.AutoFilterNext i End Sub Regards, Rohan -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Shrini -- Shrini -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com shrinidata16012012.xlsm Description: Binary data
Re: $$Excel-Macros$$ Vlookup Help
All your records in Equity, Debentures and Mutual fund are unique. Why don't you just put everything in one sheet and do a lookup using sumproduct. Check attached You can refer to sheets using INDIRECT. However, I wouldn't recommend using INDIRECT until absolutely necessary. Regards, Sam Mathai Chacko On Mon, Jan 16, 2012 at 9:51 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.com wrote: Dear Team, I am creating macro for Recon of prices where facing problem in multiple vlookup. Find attached Recon file. Please any one help me the multiple vlookup function/coding multiple vlookup. Thanking in Advance. Regards, Shrinivas -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Recon.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Running/Moving Statement
It is more to do with the single thread working of VBA. Your code execution will always be sequential, and that the limitation that many VBA developers have a grudge about. Coming to your original request, you could use a marquee using HTML, embedded in to a user form. I am not sure if an HTML object can be embedded on a sheet, but I have seen it work on a user form. Regards, Sam Mathai Chacko On Mon, Jan 16, 2012 at 8:34 PM, dguillett1 dguille...@gmail.com wrote: That is what will happen with xl2003. Don Guillett SalesAid Software dguille...@gmail.com *From:* santosh subudhi santoshkumar.subu...@gmail.com *Sent:* Monday, January 16, 2012 8:15 AM *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ Running/Moving Statement Hi Friend, Yes this is exactly I wanted. However I am unable to use the MS Excel when I click the Start button. It seems the Excel gets hanged. Any solution for that. Mover what do we call these moving lines in excel. Regards Santosh santoshkumar.subu...@gmail.com Date: Sat, 14 Jan 2012 20:46:32 +0530 Subject: Re: $$Excel-Macros$$ Running/Moving Statement From: xlst...@gmail.com To: excel-macros@googlegroups.com Hi Santosh, yes it is possible, please find the attachment On Sat, Jan 14, 2012 at 4:56 PM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hi Group, Is it possible to show a statement moving from right to left in MS Excel that we usually see in websites or in our system screen savers. If yes please help me with this. -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
$$Excel-Macros$$ Re: ACCESS QUERY
use AutoReport: Columnar wizard On Mon, Jan 16, 2012 at 12:52 PM, vivek vivek.j...@gmail.com wrote: I tried to prepare the report in Access . But the problem is that the schemes details do not display vertically as required. They are displayed horizontally. The number of schemes is about 100 , so horizontal report printing is not possible not presentable as well. If I try to put scheme details vertically one below the other in the report design view manually, it takes a lot of time and the chances of missing out some scheme is also there. So please guide if it is possible to prepare the report as desired by using some kind of report wizard. Further is it possible that the sum of total earning is also calculated automatically in the report. ** ** Thanks Regards... CA Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road, Guwahati-781001 0361-2603895,9435019908 [image: save earth] ** ** -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com image001.jpg
Re: $$Excel-Macros$$ Formula required
Ravi Kumar, The solution provided was for the previous attachment you sent. Not this attachment. For your new requirement, you should be ideally starting a new post. Now, can you please show example of more than 2, columns. Multiple columns. That will help the volunteers here understand what you need better, and provide an apt solution. Sam On Mon, Jan 16, 2012 at 10:13 PM, Kumar Punnam mr.ravikumar@gmail.comwrote: Hi Friends , I am happy for your support , the solution which was provided was not satisfying my requirement Please find the attached sheet, which show in detailed my requirement Thanks in Advance P V Ravi kumar Ph : 9440801124 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Retaining headers and footers when creating a new worksheet
Thank you Sam! That's exactly what I wanted. Steve On 1/13/2012 9:17 PM, Sam Mathai Chacko wrote: Regards, Sam Mathai Chacko On Fri, Jan 13, 2012 at 10:58 PM, Steve Weaver stevebwea...@comcast.net mailto:stevebwea...@comcast.net wrote: Greetings, Several months ago I received help from this group on a project to separate transactions from a single Excel worksheet into three different worksheets based on the rep number. Your assistance was and still is very much appreciated. I would like to improve on this process even more and need further help. The problem I have is that each month when I create a new worksheet I lose the headers and footers established for each rep report along with the report totals on the last page. Please refer to the attached file. Is there some way to retain the headers and footers, along with the total on the last page, when creating the individual rep worksheet? Is it possible to overwrite the existing rep worksheet, thereby retaining the headers and footers, rather than creating a new worksheet? Thank you very much for your help! Steve -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ formula
Hello Members i want grow my excel formula knowledge. Please provide help and some notes . regards Manoj -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ how to create a list based on query or some kind of compound list
Send your file with a complete explanation and examples. Don Guillett SalesAid Software dguillett1 @gmail.com -Original Message- From: John Sent: Sunday, January 15, 2012 10:04 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ how to create a list based on query or some kind of compound list I am working on project assignment workbook. I have a PROJECT worksheet that define project and task, I will get the data from project managers about the hours per week for the each of the project tasks.So the worksheet structure like below: Project Name | Task Name | Jan-12 (hr)|Feb-12(hr)|Mar-20(hr) --- Proj-A1000 | App Dev |160 |160| 80 Proj-A1000 | App Test|40|80 |100 Proj-B1011 | Test |80|80| 40 Then I want to have a worksheet to assign a person to the task and then inherit the work hours for the project task. So the TASK ASSIGNMENT worksheet will look like: Resource Name|Project Name|Task Name |Jan-12 (hr)|Feb-12(hr)| Mar-20(hr) - Paul |Proj-A1000 | App Dev | 160 | 160| 80 Alex |Proj-B1011 | Test | 80 | 80| 40 I want to be able to select value from Project Name and Task Name from PROJECT WORKSHEET when I am on the Project Name and Task Name from TASK ASSIGNMENT worksheet. I can use the list Data Validation feature for Excel 2010 for creating a drop down list for for Project Name column. But I don't know how to do that for the Task Name column on the TASK ASSIGNMENT worksheet as the list will have to be based on Project Name selected for the person. I am not a Excel or VBA developer, and I cannot figure out here. Can experts in this group provide some direction? Many thanks, John -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please
Does this help? .Rows(12:22).Hidden = True Don Guillett SalesAid Software dguille...@gmail.com From: Christopher Kevin Sent: Sunday, January 15, 2012 4:16 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please Can you experts help me with my problem? What I want is: When the previous button is clicked, I want only records up untill row 7 to show on the Form Sheet as per the attached Room Reservation Sheet. And the same should be applied to the go to last record button. That is I want row 7 to be the last row and not going back beyond row 7 to row 1. How can that be done as per the attached file? The that I currently have is included in file. Additional Explaination: When I clcik the and buttons, column headers and blank rows above row 7 are also populated on to the Form. How can this be avoided? I hope I have explained myself clearly. Thank you all you experts in advance for any help that may be provided. Chris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please
Don, Thank you for the help but it does'nt work. Regards Chris On Tue, Jan 17, 2012 at 4:46 AM, dguillett1 dguille...@gmail.com wrote: Does this help? .Rows(12:22).Hidden = True Don Guillett SalesAid Software dguille...@gmail.com *From:* Christopher Kevin christopher@gmail.com *Sent:* Sunday, January 15, 2012 4:16 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please Can you experts help me with my problem? What I want is: When the previous button is clicked, I want only records up untill row 7 to show on the Form Sheet as per the attached Room Reservation Sheet. And the same should be applied to the go to last record button. That is I want row 7 to be the last row and not going back beyond row 7 to row 1. How can that be done as per the attached file? The that I currently have is included in file. Additional Explaination: When I clcik the and buttons, column headers and blank rows above row 7 are also populated on to the Form. How can this be avoided? I hope I have explained myself clearly. Thank you all you experts in advance for any help that may be provided. Chris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please
Can you re-explain what you want. Perhaps with an example of what it should look like. Don Guillett SalesAid Software dguille...@gmail.com From: Christopher Kevin Sent: Monday, January 16, 2012 4:13 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please Don, Thank you for the help but it does'nt work. Regards Chris On Tue, Jan 17, 2012 at 4:46 AM, dguillett1 dguille...@gmail.com wrote: Does this help? .Rows(12:22).Hidden = True Don Guillett SalesAid Software dguille...@gmail.com From: Christopher Kevin Sent: Sunday, January 15, 2012 4:16 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please Can you experts help me with my problem? What I want is: When the previous button is clicked, I want only records up untill row 7 to show on the Form Sheet as per the attached Room Reservation Sheet. And the same should be applied to the go to last record button. That is I want row 7 to be the last row and not going back beyond row 7 to row 1. How can that be done as per the attached file? The that I currently have is included in file. Additional Explaination: When I clcik the and buttons, column headers and blank rows above row 7 are also populated on to the Form. How can this be avoided? I hope I have explained myself clearly. Thank you all you experts in advance for any help that may be provided. Chris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group,
Re: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please
Didn’t get a chance to fully look at it but have you tried simply deleting rows on the source sheet? Shutting down. Where are you and what is this for? Don Guillett SalesAid Software dguille...@gmail.com From: Christopher Kevin Sent: Monday, January 16, 2012 6:17 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please Don, OK I'll try to explain it more clearly: As per the file attached: 1) Data is entered into the RoomReservations Sheet using the Form Sheet as an excel userform. This Form Sheet contains the Following Fields as shown below: Booking Ref Ref001 Guest First Name Chris Guest Surname Kevin Guest Phone No 309 0478 Guest Email Address cke...@gmail.com Guest Country PNG Check In Date 15/01/2012 Check Out Date 17/01/2012 Adult Guests 2 Children Guests 2 Room Type Suite Room No 601 Booking Status Confirmed No of Nights 2 Rate 350 % Discount 0.25 Total Payment 700 Remarks Paid 2) After entering the data the Add Bookings button on the Form Sheet is clicked to transfer the data from the FormSheet to the RoomReservation Sheet. The Headers start at row 6. The first entry is added to row 7. 3) To view previously added bookings the the following bottons on the Form Sheet are clicked. first record, previous record, next record, last record .This brings up or populates the previous record from the RoomReservation Sheet to the Form Sheet for viewing 4) When I click on the the first record button it goes beyond row7 to row 1, showing blanks cells on the Form Sheet and not row 7. What I want is, when I click on the first record button, record on row 7 to show on the Form Sheet instead of going to row 1 and showing blank cells. 5) When I click on the the previous record button it goes beyond row 7, row 6, row 5 etc, etc, to row 1. What I want is, when I click on the previous record button, view records untill row 7 and not row 6 etc, etc to row 1. 6) To get to the field of it try clicking these buttons to see how it works currently. Please refeer to the attached file. I hope I have explained myself clearly and thanks you once again in advance for any help that I may recieve. On Tue, Jan 17, 2012 at 9:08 AM, dguillett1 dguille...@gmail.com wrote: Can you re-explain what you want. Perhaps with an example of what it should look like. Don Guillett SalesAid Software dguille...@gmail.com From: Christopher Kevin Sent: Monday, January 16, 2012 4:13 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please Don, Thank you for the help but it does'nt work. Regards Chris On Tue, Jan 17, 2012 at 4:46 AM, dguillett1 dguille...@gmail.com wrote: Does this help? .Rows(12:22).Hidden = True Don Guillett SalesAid Software dguille...@gmail.com From: Christopher Kevin Sent: Sunday, January 15, 2012 4:16 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please Can you experts help me with my problem? What I want is: When the previous button is clicked, I want only records up untill row 7 to show on the Form Sheet as per the attached Room Reservation Sheet. And the same should be applied to the go to last record button. That is I want row 7 to be the last row and not going back beyond row 7 to row 1. How can that be done as per the attached file? The that I currently have is included in file. Additional Explaination: When I clcik the and buttons, column headers and blank rows above row 7 are also populated on to the Form. How can this be avoided? I hope I have explained myself clearly. Thank you all you experts in advance for any help that may be provided. Chris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES
Re: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please
I cannot delete rows on the source sheet I'm based in Port Moresby and my old man (dad) has a small guest house that he is renting out to his guests that I went to help him do it using excel Regards Chris On Tue, Jan 17, 2012 at 10:46 AM, dguillett1 dguille...@gmail.com wrote: Didn’t get a chance to fully look at it but have you tried simply deleting rows on the source sheet? Shutting down. Where are you and what is this for? Don Guillett SalesAid Software dguille...@gmail.com *From:* Christopher Kevin christopher@gmail.com *Sent:* Monday, January 16, 2012 6:17 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please Don, OK I'll try to explain it more clearly: As per the file attached: 1) Data is entered into the RoomReservations Sheet using the Form Sheet as an excel userform. This Form Sheet contains the Following Fields as shown below: Booking Ref Ref001 Guest First Name Chris Guest Surname Kevin Guest Phone No 309 0478 Guest Email Address * * *cke...@gmail.com* Guest Country PNG Check In Date 15/01/2012 Check Out Date 17/01/2012 Adult Guests * * *2* Children Guests 2 Room Type Suite Room No 601 Booking Status Confirmed No of Nights 2 Rate 350 % Discount 0.25 Total Payment 700 Remarks Paid 2) After entering the data the Add Bookings button on the Form Sheet is clicked to transfer the data from the FormSheet to the RoomReservation Sheet. The Headers start at row 6. The first entry is added to row 7. 3) To view previously added bookings the the following bottons on the Form Sheet are clicked. first record, previous record, next record, last record .This brings up or populates the previous record from the RoomReservation Sheet to the Form Sheet for viewing 4) When I click on the the first record button it goes beyond row7 to row 1, showing blanks cells on the Form Sheet and not row 7. *What I want is, when I click on the first record button, record on row 7 to show on the Form Sheet instead of going to row 1 and showing blank cells. * 5) When I click on the the previous record button it goes beyond row 7, row 6, row 5 etc, etc, to row 1. *What I want is, when I click on the previous record button, view records untill row 7 and not row 6 etc, etc to row 1.* 6) To get to the field of it try clicking these buttons to see how it works currently. Please refeer to the attached file. I hope I have explained myself clearly and thanks you once again in advance for any help that I may recieve. On Tue, Jan 17, 2012 at 9:08 AM, dguillett1 dguille...@gmail.com wrote: Can you re-explain what you want. Perhaps with an example of what it should look like. Don Guillett SalesAid Software dguille...@gmail.com *From:* Christopher Kevin christopher@gmail.com *Sent:* Monday, January 16, 2012 4:13 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please Don, Thank you for the help but it does'nt work. Regards Chris On Tue, Jan 17, 2012 at 4:46 AM, dguillett1 dguille...@gmail.com wrote: Does this help? .Rows(12:22).Hidden = True Don Guillett SalesAid Software dguille...@gmail.com *From:* Christopher Kevin christopher@gmail.com *Sent:* Sunday, January 15, 2012 4:16 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please Can you experts help me with my problem? What I want is: When the previous button is clicked, I want only records up untill row 7 to show on the Form Sheet as per the attached Room Reservation Sheet. And the same should be applied to the go to last record button. That is I want row 7 to be the last row and not going back beyond row 7 to row 1. How can that be done as per the attached file? The that I currently have is included in file. Additional Explaination: When I clcik the and buttons, column headers and blank rows above row 7 are also populated on to the Form. How can this be avoided? I hope I have explained myself clearly. Thank you all you experts in advance for any help that may be provided. Chris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ formula
Thanks for Noorain reading notes, some tricks i even dun know. 2012/1/17 NOORAIN ANSARI noorain.ans...@gmail.com Dear Manoj, Please study attached material and follow this Excel-Macro group regularly. Hope it will help to u -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Jan 16, 2012 at 11:51 PM, Manoj Kumar kmrmanoj1...@gmail.comwrote: Hello Members i want grow my excel formula knowledge. Please provide help and some notes . regards Manoj -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Question in Excel
Hi, I make dummy sheet to get to know , where i am facing problem , and I marked as Yellow Color . I also give my solution , but that is only half , I need complete solution. I need your help . Please find the attached sheet. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com LyndaMam-Question.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Question in Excel
*Find the attachment...* On Tue, Jan 17, 2012 at 8:34 AM, neil johnson neil.jh...@googlemail.comwrote: Hi, I make dummy sheet to get to know , where i am facing problem , and I marked as Yellow Color . I also give my solution , but that is only half , I need complete solution. I need your help . Please find the attached sheet. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com LyndaMam-Solution.xls.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Question in Excel
Thanks a lots . On Tue, Jan 17, 2012 at 10:41 AM, Maries talk2mar...@gmail.com wrote: *Find the attachment...* On Tue, Jan 17, 2012 at 8:34 AM, neil johnson neil.jh...@googlemail.comwrote: Hi, I make dummy sheet to get to know , where i am facing problem , and I marked as Yellow Color . I also give my solution , but that is only half , I need complete solution. I need your help . Please find the attached sheet. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Question in Excel
Dear Kapil, Pls see attached sheet with Index+Small On Tue, Jan 17, 2012 at 11:08 AM, neil johnson neil.jh...@googlemail.comwrote: Thanks a lots . On Tue, Jan 17, 2012 at 10:41 AM, Maries talk2mar...@gmail.com wrote: *Find the attachment...* On Tue, Jan 17, 2012 at 8:34 AM, neil johnson neil.jh...@googlemail.comwrote: Hi, I make dummy sheet to get to know , where i am facing problem , and I marked as Yellow Color . I also give my solution , but that is only half , I need complete solution. I need your help . Please find the attached sheet. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Copy of LyndaMam-Question(with Index).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Dairy 2012
Thank you Mr.murali. Its an excellent gift... With Regards, Haris na.har...@gmail.com On 16 January 2012 15:17, Sanjib Chatterjee chatterjee.kolk...@gmail.comwrote: thank you Muralidhar, It is nice. sanjib On Mon, Jan 16, 2012 at 2:21 PM, muralidhar e emuralidha...@gmail.comwrote: Hi, Dear all wish u happy sankranti(Pongal) and a digital dairy gift for all. -- *Thanks Regards,* ** *Muralidhar E.* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- - -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ formula
Most Welcome Darwin.. On Tue, Jan 17, 2012 at 9:59 AM, Darwin Chan darwin.chankaw...@gmail.comwrote: Thanks for Noorain reading notes, some tricks i even dun know. 2012/1/17 NOORAIN ANSARI noorain.ans...@gmail.com Dear Manoj, Please study attached material and follow this Excel-Macro group regularly. Hope it will help to u -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Jan 16, 2012 at 11:51 PM, Manoj Kumar kmrmanoj1...@gmail.comwrote: Hello Members i want grow my excel formula knowledge. Please provide help and some notes . regards Manoj -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Question in Excel
Thanks Noor Ji, For your quick reply. On Tue, Jan 17, 2012 at 11:38 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Kapil, Pls see attached sheet with Index+Small On Tue, Jan 17, 2012 at 11:08 AM, neil johnson neil.jh...@googlemail.comwrote: Thanks a lots . On Tue, Jan 17, 2012 at 10:41 AM, Maries talk2mar...@gmail.com wrote: *Find the attachment...* On Tue, Jan 17, 2012 at 8:34 AM, neil johnson neil.jh...@googlemail.com wrote: Hi, I make dummy sheet to get to know , where i am facing problem , and I marked as Yellow Color . I also give my solution , but that is only half , I need complete solution. I need your help . Please find the attached sheet. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum
$$Excel-Macros$$ simple Macro need -SAP data
Dear all can you please help me . which i attached excell sheet having two sheets one SAP sheet and output we need product wise sum Qty and Value if you suggest simple macro Thanks Chandru -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com sap.XLS Description: MS-Excel spreadsheet
$$Excel-Macros$$ Excel formula for Dates
I have date 17-Jan-12. I want formula to get only Jan-12. Please help me. Regards, Imran -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Excel formula for Dates
*=TEXT(A1,MMM-YY) * On Tue, Jan 17, 2012 at 10:55 AM, Imran khan ikha...@gmail.com wrote: I have date 17-Jan-12. I want formula to get only Jan-12. Please help me. Regards, Imran -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Excel formula for Dates
Dear Imran, Please try =text(17-Jan-12,mmm-yy) On Tue, Jan 17, 2012 at 12:25 PM, Imran khan ikha...@gmail.com wrote: I have date 17-Jan-12. I want formula to get only Jan-12. Please help me. Regards, Imran -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Urgent Required.xlsx
Dear Experts Kindly find the attached sheet. I want to name only -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Urgent Required.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Urgent Required.xlsx
Dear Neeraj, You can use Text to Column StepSelect required data Goto Data-Text to column-Delimeters -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Tue, Jan 17, 2012 at 12:29 PM, Neeraj Chauhan neerajchauhan...@gmail.com wrote: Dear Experts Kindly find the attached sheet. I want to name only -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ regarding number to text
Dear NOORAIN ANSARI, This is great. Would you please explain why it is showing just thiousant, (e.i. If i put the figure as 123654.59, I like to display as one lakh twenty three thousand six hundred fifty four and paise fifty nine only) why lakh is not coming here? regards, Sanjib -- - -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com