Re: $$Excel-Macros$$ Delete text only
Dear Noorain, it, ok but if i want to remove number/disite? Regards LAKSHMAN From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 13 January 2012 8:25 PM Subject: Re: $$Excel-Macros$$ Delete text only Dear Lokesh, Please try it.. Sub Copy_and_Delete_Text() Dim rng, rng1, rng2 As Range Dim i, j As Long Set rng = Sheet1.Range(A1:A Sheet1.Range(A65536).End(xlUp).Row) rng.Copy Sheet1.Range(D1) Set rng1 = Sheet1.Range(D2:D Sheet1.Range(D65536).End(xlUp).Row) For Each rng2 In rng1 If Application.WorksheetFunction.IsText(rng2) Then rng2.Delete End If Next End Sub and see attached sheet.. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ www.noorainansari.com On Fri, Jan 13, 2012 at 3:12 PM, Lokesh Loki lokeshsmg2...@gmail.com wrote: Hi All, First i need to copy the Cell A and paste it to Cell D and delete the names (i.e.text) in Cell D through VBA. Find the attached excel file. Regards Lokesh.M-- 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$$ help
*Find the attached file...* On Sat, Jan 14, 2012 at 11:08 AM, Sam Mathai Chacko samde...@gmail.comwrote: You can use COUNTIFS, but SUMPRODUCT, should be an easy option since it will work in Excel 2003 or 2007+ Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 12:30 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi Gurus, Please find the attached querY Thanks in adv. -- 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 -- 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 Sum.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Running/Moving Statement
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
Re: $$Excel-Macros$$ Delete text only
*Use below code: * Sub OnlyNumric() Dim rng As Range Set rng = Range(Sheet1!A1:A1000) For i = 1 To 1000 With rng If IsNumeric(rng.Cells(i, 1).Value) Then .Cells(i, 4).Value = .Cells(i, 1).Value End If End With Next i End Sub* * Regards, MARIES* * On Sat, Jan 14, 2012 at 1:26 PM, Lakshman Prasad lakshman...@yahoo.comwrote: Dear Noorain, it, ok but if i want to remove number/disite? Regards LAKSHMAN From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 13 January 2012 8:25 PM Subject: Re: $$Excel-Macros$$ Delete text only Dear Lokesh, Please try it.. Sub Copy_and_Delete_Text() Dim rng, rng1, rng2 As Range Dim i, j As Long Set rng = Sheet1.Range(A1:A Sheet1.Range(A65536).End(xlUp).Row) rng.Copy Sheet1.Range(D1) Set rng1 = Sheet1.Range(D2:D Sheet1.Range(D65536).End(xlUp).Row) For Each rng2 In rng1 If Application.WorksheetFunction.IsText(rng2) Then rng2.Delete End If Next End Sub and see attached sheet.. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ www.noorainansari.com On Fri, Jan 13, 2012 at 3:12 PM, Lokesh Loki lokeshsmg2...@gmail.com wrote: Hi All, First i need to copy the Cell A and paste it to Cell D and delete the names (i.e.text) in Cell D through VBA. Find the attached excel file. Regards Lokesh.M-- 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, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Delete text only
Thanx From: Maries talk2mar...@gmail.com To: excel-macros@googlegroups.com Sent: Saturday, 14 January 2012 5:51 PM Subject: Re: $$Excel-Macros$$ Delete text only Use below code: Sub OnlyNumric() Dim rng As Range Set rng = Range(Sheet1!A1:A1000) For i = 1 To 1000 With rng If IsNumeric(rng.Cells(i, 1).Value) Then .Cells(i, 4).Value = .Cells(i, 1).Value End If End With Next i End Sub Regards, MARIES On Sat, Jan 14, 2012 at 1:26 PM, Lakshman Prasad lakshman...@yahoo.com wrote: Dear Noorain, it, ok but if i want to remove number/disite? Regards LAKSHMAN From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 13 January 2012 8:25 PM Subject: Re: $$Excel-Macros$$ Delete text only Dear Lokesh, Please try it.. Sub Copy_and_Delete_Text() Dim rng, rng1, rng2 As Range Dim i, j As Long Set rng = Sheet1.Range(A1:A Sheet1.Range(A65536).End(xlUp).Row) rng.Copy Sheet1.Range(D1) Set rng1 = Sheet1.Range(D2:D Sheet1.Range(D65536).End(xlUp).Row) For Each rng2 In rng1 If Application.WorksheetFunction.IsText(rng2) Then rng2.Delete End If Next End Sub and see attached sheet.. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ www.noorainansari.com On Fri, Jan 13, 2012 at 3:12 PM, Lokesh Loki lokeshsmg2...@gmail.com wrote: Hi All, First i need to copy the Cell A and paste it to Cell D and delete the names (i.e.text) in Cell D through VBA. Find the attached excel file. Regards Lokesh.M-- 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
Re: $$Excel-Macros$$ help
Sumproduct should work as well withOUT array entering Don Guillett SalesAid Software dguille...@gmail.com From: Maries Sent: Saturday, January 14, 2012 5:15 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help Find the attached file... On Sat, Jan 14, 2012 at 11:08 AM, Sam Mathai Chacko samde...@gmail.com wrote: You can use COUNTIFS, but SUMPRODUCT, should be an easy option since it will work in Excel 2003 or 2007+ Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 12:30 PM, vijayajith VA vijayajith...@gmail.com wrote: Hi Gurus, Please find the attached querY Thanks in adv. -- 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 -- 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$$ Need Macro in VBA excel or vbs
Thank you sam Can you please try in vb script on same On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Sub DelRows() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets With wks .Range(A2, .UsedRange.SpecialCells(xlCellTypeLastCell)(2)).EntireRow.Delete End With Next wks End Sub Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 8:07 AM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Dear All, Congrats for all excel macros group users , I have a excel where data is in Sheet1 to Sheet4. I would expect from any one of you to provide macro for getting rows delete from row 2 to till end Only Header should remain when macros runs. (i.e Range A1 should remain) Please try to help out through excel VBA or VBS Regards Yogananda Muthaiah Ph : 973 123 7267 -- 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 -- Sent from my mobile device Regards Yogananda Muthaiah Ph : 973 123 7267 -- 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$$ Need Macro in VBA excel or vbs
Try in vb script? I have no idea what you are trying to convey. On Sat, Jan 14, 2012 at 6:30 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Thank you sam Can you please try in vb script on same On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Sub DelRows() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets With wks .Range(A2, .UsedRange.SpecialCells(xlCellTypeLastCell)(2)).EntireRow.Delete End With Next wks End Sub Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 8:07 AM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Dear All, Congrats for all excel macros group users , I have a excel where data is in Sheet1 to Sheet4. I would expect from any one of you to provide macro for getting rows delete from row 2 to till end Only Header should remain when macros runs. (i.e Range A1 should remain) Please try to help out through excel VBA or VBS Regards Yogananda Muthaiah Ph : 973 123 7267 -- 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 -- Sent from my mobile device Regards Yogananda Muthaiah Ph : 973 123 7267 -- 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$$ Running/Moving Statement
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 Copy of marque.xlsm Description: Binary data
Re: $$Excel-Macros$$ Job
2012/1/13 NOORAIN ANSARI noorain.ans...@gmail.com Dear Satvik, One of my friend provided me below link to prepare MIS Resume.. Hope it may help to you.. http://career-resources.dice.com/technical-resume/sample_resumes/vba_developer.shtml On Fri, Jan 13, 2012 at 10:27 PM, Satvik satvik...@gmail.com wrote: ** Some one please send me the mis resume template... I'm attending an interview on monday... Please!!! Regards, Satvik Sent from BlackBerry® on Airtel -- *From: *NOORAIN ANSARI noorain.ans...@gmail.com *Sender: *excel-macros@googlegroups.com *Date: *Thu, 12 Jan 2012 19:17:42 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ Job The sender of this email is registered with Naukri.com as Harjai Computers Pvt Ltd *Experience required for the Job:* 5 - 8 years *Annual Salary of the Job:* 2.0 - 5.0 Lacs *Job Location:* Bengaluru/Bangalore *Dear Candidate,* HI!! This is Sanjeev from Harjai Computers Pvt Ltd.(ISO 9001 2008 certified) We are an ISO 9001 : 2008 IT Consulting company. We are currently providing IT Services to almost 200 Companies, which I Includes CMM, PCMM, CMMI and some reputed Companies in India and International. One of our clients, a large CMM L5 Co. is looking for Programmer Analyst(Lead Developer - MSAccess) in Bangalore Location. Skills : Programmer Analyst(Lead Developer - MSAccess) Exp : 5+yrs Job Location : Bangalore Job description : 1. Own projects; understand and create business requirements for reporting and database solutions assigned to the team in partnership with business users, Business Analyst and Project Leader BI/Managers. 2. Communication point for US business users, Project lead/mangers and team for the project's feasibility, estimation, progress, issues and development alternatives. 3. Creation and modification of mock ups, high level design documents that meet business requirements and ensure these get validated by business users. 4. Validation and verification of reporting and database solutions developed by team to meet business needs before delivering it to the business users. 5. Review the code, design and requirement document created by peers and suggesting changes for continuous improvement of team's deliveries. 6. Build a deep understanding of the business supported and a broad understanding of its role in the company; need to gain insights into overall reporting needs of the pyramid or project aligned and be able to link current projects deliveries to the goals objectives of the pyramid. 7. Building relationships with business users, end users of reports/databases, peers and management. 8. Guide team and self develop and support reporting and database solutions as per discussion with business users, requirements and design documents Please send us your latest detailed resume with the following details : Current ctc Expected ctc Notice Period Location Preferences Passport Details (PP Number / Valid date) Thanks Regards Sanjeev K Shukla - HR Executive For our current hot openings Click Here. 4th Floor, Business Park, Near Bajaj Bhavan , SV Road, Malad (West), Mumbai- 400064. : (+91-22-)28787955 | Ext:434 | Fax: (+91-22-)28737077 | Mobile - 9594966102 sanj...@harjaicomputers.com | www.harjai.com Follow Us On Go Green - Print this mail, only if you need to... Is this job relevant to you? Yeshttp://jobsearch.naukri.com/mynaukri/jobs_feedback.php?response=yesmid=S4454829 Nohttp://jobsearch.naukri.com/mynaukri/jobs_feedback.php?response=nomid=S4454829 Your feedback would help us in sending you the most relevant job opportunities Disclaimer: The sender of this email is registered with naukri.com as *Harjai Computers Pvt Ltd* (ni...@harjaicomputers.com, 4th Floor,Business Park, Near Bajaj Bhavan,, S.V.Road, Malad(West), MUMBAI, Maharashtra - 400064) using Naukri.com services. The responsibility of checking the authenticity of offers/correspondence lies with you. If you consider the content of this email inappropriate or spam, you may: 1. Report abuse by forwarding this email to: complia...@naukri.com 2. You can also Block this Companyhttp://my.naukri.com/BlockCompany/edit/cid/16065from searching your resume in the database. Advisory: Please do not pay any money to anyone who promises to find you a job. This could be in the form of a registration fee, or document processing fee or visa charges or any other pretext. The money could be asked for upfront or it could be asked after trust has been built after some correspondence has been exchanged. Also please note that in case you get a job offer or a letter of intent without having been through an interview process it is probably a scam and you should contact complia...@naukri.com for advise. *To be on the top of Employer's Resume Search Update Your Resume
RES: $$Excel-Macros$$ Form to datasheet
Yes! Works! Thank you very, very much. De: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] Em nome de Sam Mathai Chacko Enviada em: sábado, 14 de janeiro de 2012 02:26 Para: excel-macros@googlegroups.com Assunto: Re: $$Excel-Macros$$ Form to datasheet Try this, Cells(Ultimalinha, 15).Value = BemImovel ^ 1 Regards, Sam Mathai Chacko On Fri, Jan 13, 2012 at 10:40 PM, Marcio Bandeira marciobandeir...@gmail.com wrote: Hi, thanks for any help. I have a form to input data in a worksheet. One of this data is a number, but when I put in the excel this data, the calculation doens´t work. The formula in the field is: Cells(Ultimalinha, 15).Value = BemImovel There is a value in the form (Bem Imovel), USD 5000 for example, but in the excel (datasheet) it´s only a data “5000” and I can´t SUM in a formula for example. Can someone try to give me a hint how I do this? TKs Atenciosamente, Marcio Bandeira de Azevedo -- 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 mailto:excel-macros@googlegroups.com 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$$ Need Application for Invoice Managment Tracker..
2012/1/13 Rajan_Verma rajanverma1...@gmail.com Hi Please explain what kind of invoice management application are you looking for.. what will that do? ** ** ** ** Rajan. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Amresh Maurya *Sent:* Jan/Fri/2012 11:33 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need Application for Invoice Managment Tracker.. ** ** Hi Guys, I need a Excel application for Invoice Managment Tracker ..if you have any excel , access application for invoice managment pls send me.. Thanks in Advance Regards Amresh -- 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 Welcome amreshkushwaha You download the file up, understand that what you want to help. -- 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$$ Need Macro in VBA excel or vbs
Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 9:48 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Hi sam As you provided in excel vba .. I would need the same to run through vb script. keep 1 xl in desktop with records which we need *.vbs to run delete rows from range A2 to till end in xl On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Try in vb script? I have no idea what you are trying to convey. On Sat, Jan 14, 2012 at 6:30 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Thank you sam Can you please try in vb script on same On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Sub DelRows() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets With wks .Range(A2, .UsedRange.SpecialCells(xlCellTypeLastCell)(2)).EntireRow.Delete End With Next wks End Sub Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 8:07 AM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Dear All, Congrats for all excel macros group users , I have a excel where data is in Sheet1 to Sheet4. I would expect from any one of you to provide macro for getting rows delete from row 2 to till end Only Header should remain when macros runs. (i.e Range A1 should remain) Please try to help out through excel VBA or VBS Regards Yogananda Muthaiah Ph : 973 123 7267 -- 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 -- Sent from my mobile device Regards Yogananda Muthaiah Ph : 973 123 7267 -- 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,
Re: $$Excel-Macros$$ Need Macro in VBA excel or vbs
$uperb sam... Really ur great. Thank you and regards Yogananda Muthaiah On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 9:48 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Hi sam As you provided in excel vba .. I would need the same to run through vb script. keep 1 xl in desktop with records which we need *.vbs to run delete rows from range A2 to till end in xl On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Try in vb script? I have no idea what you are trying to convey. On Sat, Jan 14, 2012 at 6:30 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Thank you sam Can you please try in vb script on same On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Sub DelRows() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets With wks .Range(A2, .UsedRange.SpecialCells(xlCellTypeLastCell)(2)).EntireRow.Delete End With Next wks End Sub Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 8:07 AM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Dear All, Congrats for all excel macros group users , I have a excel where data is in Sheet1 to Sheet4. I would expect from any one of you to provide macro for getting rows delete from row 2 to till end Only Header should remain when macros runs. (i.e Range A1 should remain) Please try to help out through excel VBA or VBS Regards Yogananda Muthaiah Ph : 973 123 7267 -- 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 -- Sent from my mobile device Regards Yogananda Muthaiah Ph : 973 123 7267 -- 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
$$Excel-Macros$$ Re: access query
I will once again explain my query. I have a table which contains data relating to about 100 schemes for 2500 dealers in the following format DEALER CODE DEALER NAME RDS NAME SCH-1 SCH-2 SCH-100 TOTAL EARNING 1 A AA 100 90 190 2 B BB 150 85 17 252 3 C AA 200 200 4 D CC 150 10 0 160 N E BB 700 80 15 795 Now I want the report in the following format for each dealer in a new page DEALER CODE : 1 DEALER NAME: A RDS : AA SCH-1100 SCH-290 TOTAL 190 DEALER CODE : 2 DEALER NAME: B RDS : BB SCH-1150 SCH-285 SCH-317 TOTAL 252 Etc. for each dealer. If any scheme is blank for a dealer it should be omitted. I hope I am clear this time. 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 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