Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012
Good work Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Wednesday, May 02, 2012 11:40 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012 Congrats Cheetah Regards, Sam On Wed, May 2, 2012 at 10:04 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: यूँ ही बरकरार रखो भाई अपने Expertise के छाप को. और अपनी तरक्की से छोटा कर दो आसमा के माप को. हम दोस्तों की दुआए,छोड़े ना हरगिज़ साथ, मेरे ओर से लाख-लाख बधाई, राजन बाबु आपको. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Wed, May 2, 2012 at 9:30 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of April'2012 He has posted 185 posts in April 2012 and helped many people through his expertise. He has been consistent contributor to this excel forum and has acheived this recognition many times. Thanks to Don, Noorain, Asa, Maries, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- 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 -- 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
Re: $$Excel-Macros$$ Rising lagna-astrology
What do you want where and why. Explanations are always nice. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Nemi Gandhi Sent: Thursday, May 03, 2012 5:47 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Rising lagna-astrology Attached herewith sheet for solution. Please help. -- Nemi Gandhi 98204 92963 -- 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$$ Automatic insert of row at each change in particular data
I thought I answered this once already Use this macro in a macro enabled workbook Sub insertrows() Dim i As Long On Error Resume Next For i = Cells(Rows.Count, c).End(xlUp).Row To 2 Step -1 If Cells(i, c) Cells(i - 1, c) Then Rows(i).Insert Next i End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: vaibhav joshi Sent: Thursday, May 03, 2012 12:36 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Automatic insert of row at each change in particular data Hi i wanted to insert a row between cell A1 A2 at each change in column A text On Thu, May 3, 2012 at 10:39 AM, Maries talk2mar...@gmail.com wrote: Can you share sample file... On Wed, May 2, 2012 at 9:58 PM, vaibhav joshi vaibhav...@gmail.com wrote: Dear all I am having a sheet ,which contains data of various parties. I want to insert row at each change in party name automatically ,whether it can be done automatically or i have to make it manually Regards Vaibhav -- 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$$ Split file individually -Need macro
This is a a better approach than looping Filtercopy visible to new workbooksave as close Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Rajan_Verma Sent: Thursday, May 03, 2012 8:27 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Split file individually -Need macro Hi Try the Blow Code to Split Date with in multiple workbook Please find the attached File Sub SplitAllbyCode() Dim rngRangeAs Range Dim wksSheetAs Worksheet Dim ArrUniqe Dim lngUniqeCount As Long Dim wbkNew As Workbook Set wksSheet = ThisWorkbook.Worksheets(Sheet1) With wksSheet Set rngRange = Intersect(Range(rngStart).CurrentRegion, Range(rngStart).CurrentRegion.Offset(2)) Application.ScreenUpdating = False rngRange.Columns(4).Copy Range(rngRemoveDuplicate) Range(rngRemoveDuplicate).CurrentRegion.RemoveDuplicates 1 ArrUniqe = Range(rngRemoveDuplicate).CurrentRegion For lngUniqeCount = LBound(ArrUniqe) To UBound(ArrUniqe) Range(rngStart).CurrentRegion.Rows(2).AutoFilter 4, ArrUniqe(lngUniqeCount, 1) Range(rngStart).CurrentRegion.SpecialCells(xlCellTypeVisible).Copy Set wbkNew = Workbooks.Add wbkNew.Worksheets(1).Paste wbkNew.SaveAs ThisWorkbook.Path \ ArrUniqe(lngUniqeCount, 1) wbkNew.Close 1 Next lngUniqeCount End With wksSheet.AutoFilterMode = False Application.ScreenUpdating = True Range(rngRemoveDuplicate).CurrentRegion.ClearContents MsgBox lngUniqeCountFiles has been splited, Plase find your files at vbCrLf ThisWorkbook.Path 'Free Memory Set rngRange = Nothing Set wksSheet = Nothing Erase ArrUniqe Set wbkNew = Nothing End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 03 May 2012 15:12 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Split file individually -Need macro Dear Murali, Please see attached sheet, Hope it will useful to you. Kindly change path in the code then run. Wait 5 minute after run the program. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, May 3, 2012 at 2:19 PM, MURALI NAGARAJAN muralin...@gmail.com wrote: Dear experts. We want to split the data individually and the same file should save individually ascode name in new folder(Desktop/My document). Thanks in advance. Thanks@Regards Murali.N Chennai -- 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.
Re: $$Excel-Macros$$ help Pls for creating graph,
Without too much looking it should be easy enough to fill in your source data cells using formulas for A,B,C, etc. and use ONE chart that changes with a change in name.. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Harkesh Kumar Sent: Friday, May 04, 2012 3:07 AM To: NOORAIN ANSARI ; rajanverma1987 ; dguillett1 ; excel-macros Subject: $$Excel-Macros$$ help Pls for creating graph, Dear experts. Please help for creating graphs of multipls person. please help.. -- Forwarded message -- From: Harkesh Kumar harkesh.kuma...@gmail.com Date: Fri, 4 May 2012 12:10:22 +0530 Subject: help Pls To: NOORAIN ANSARI noorain.ans...@gmail.com, rajanverma1...@gmail.com, dguille...@gmail.com Hi, we need to create Graph on the base of row data same graph we required person wise . please help me for the same. and if we can create better graph pls suggest. thanx Harkesh -- Hi, Thanks for your mail.I will revert you asap Ragards -- 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$$ Charts
Provide a file Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: joseph.cam...@gmail.com Sent: Saturday, May 05, 2012 2:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Charts Sent on my BlackBerryŽ from Vodafone -Original Message- From: joseph.cam...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 5 May 2012 04:32:26 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Charts Hi, I create a lot of stacked charts and I spend a lot of time formatting the overlapped numbers. I need a macro that will move numbers that overlap other numbers in a stacked chart. Thanks, Joseph Sent on my BlackBerryŽ from Vodafone -- 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$$ pls help with matching postal codes
Tested in the source sheet. This is an array formula entered using CSE =INDEX($C$1:$C$140,MATCH(MIN(ABS($C$1:$C$140-E1)),ABS($C$1:$C$140-E1),0)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sara Lee Sent: Monday, May 07, 2012 5:54 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ pls help with matching postal codes actually, if there is no exact value, it should give me next smallest or largest value- which ever is closest. i tried vlook up with true- but a lot of cases, it is not the closest. pls check out after u use vlookup true. It is not always the closest Best case scenario is exact and then next case scenario is closest 3 digit no. thanks for assistance again On Mon, May 7, 2012 at 5:07 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Hi Sara, You can also you use.. =IFERROR(LOOKUP(H2,Sheet1!$C$1:$C$72),) -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, May 7, 2012 at 9:39 AM, Sara Lee lee.sar...@gmail.com wrote: -- col i in Sheet 2 needs to be filled up by looking up col h in sheet 2 in sheet 1 col c value- either exact or next closest- i.e for every value in col h sheet 2, i need nearest 3 digit value that is present in entire col c in sheet 1 -- 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$$ repeat ACTION AS PER FILTER
Your sample only shows one row per number. You say copy to next file???. Pls provide larger representative sample and a better explanation. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Prajakt Pande Sent: Monday, May 07, 2012 7:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ repeat ACTION AS PER FILTER Dear All, Please help me in this. attached file for your reference. What I am looking for, 01) macro filter data by number 1,2,3,4,5,. and so on 02) copy date paste it in to next file what ever the number filter by macro that many time repeat the action. Note:- it can't say filter will be in sequence it might be it will be in 1, 5, 45, 46, 48, 50, 95, 290 and so. -- 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$$ repeat ACTION AS PER FILTER
I do NOT understand your explanation. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Prajakt Pande Sent: Monday, May 07, 2012 8:20 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ repeat ACTION AS PER FILTER Dear, Please find enclosed herewith what you requested. i apologies for inconvenience, attached sheet for your reference. Thanks Regards, Prajakt Pande +971551388482 On Mon, May 7, 2012 at 5:01 PM, dguillett1 dguille...@gmail.com wrote: Your sample only shows one row per number. You say copy to next file???. Pls provide larger representative sample and a better explanation. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Prajakt Pande Sent: Monday, May 07, 2012 7:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ repeat ACTION AS PER FILTER Dear All, Please help me in this. attached file for your reference. What I am looking for, 01) macro filter data by number 1,2,3,4,5,. and so on 02) copy date paste it in to next file what ever the number filter by macro that many time repeat the action. Note:- it can't say filter will be in sequence it might be it will be in 1, 5, 45, 46, 48, 50, 95, 290 and so. -- 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$$ repeat ACTION AS PER FILTER
Are you saying you want to do this for each item in col R or enter x for in col S for each to do CALCULATION 45 6 x 4 3 12 3 x 4 2 x 62 33 65 Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Prajakt Pande Sent: Monday, May 07, 2012 8:57 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ repeat ACTION AS PER FILTER Dear, Attached sheet with recorded macro. i think by this way i can explain you better. I am sorry for this. Thanks Regards, Prajakt Pande +971551388482 On Mon, May 7, 2012 at 5:47 PM, dguillett1 dguille...@gmail.com wrote: I do NOT understand your explanation. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Prajakt Pande Sent: Monday, May 07, 2012 8:20 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ repeat ACTION AS PER FILTER Dear, Please find enclosed herewith what you requested. i apologies for inconvenience, attached sheet for your reference. Thanks Regards, Prajakt Pande +971551388482 On Mon, May 7, 2012 at 5:01 PM, dguillett1 dguille...@gmail.com wrote: Your sample only shows one row per number. You say copy to next file???. Pls provide larger representative sample and a better explanation. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Prajakt Pande Sent: Monday, May 07, 2012 7:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ repeat ACTION AS PER FILTER Dear All, Please help me in this. attached file for your reference. What I am looking for, 01) macro filter data by number 1,2,3,4,5,. and so on 02) copy date paste it in to next file what ever the number filter by macro that many time repeat the action. Note:- it can't say filter will be in sequence it might be it will be in 1, 5, 45, 46, 48, 50, 95, 290 and so. -- 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
Re: $$Excel-Macros$$ Strikethrough the figures in Excel.....
Right click sheet tabview codeinsert thismodify range to suit Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range(a1:b21)) Is Nothing Then Exit Sub If VarType(Target) = 8 And IsNumeric(Left(Target, 1)) Then With Target.Font .FontStyle = Bold .Strikethrough = True .ColorIndex = 7 End With End If End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Dhananjay Pinjan Sent: Tuesday, May 08, 2012 9:10 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Strikethrough the figures in Excel. Dear Experts, If I type '523 (value with apostrophy) in a cell when I press Enter ,the value should become Strikethrough like 523. Pl. help is there any way? If macro is possible can also work. Regards,, Dhananjay -- 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$$ Count sum color cell, cells have conditional formatting
http://www.xldynamic.com/source/xld.ColourCounter.html Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: ChilExcel Sent: Monday, May 07, 2012 6:01 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Count sum color cell, cells have conditional formatting hi all Please I need urgent function for sum and count backColor ...cells have conditional formatting Thx Chilexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- 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$$ Table data fit the page size..(auto)
Are you talking about fitting when viewing or printing. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Mohammed Muneer Sent: Tuesday, May 08, 2012 11:32 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Table data fit the page size..(auto) Ya, but it doesn’t zoom to the margin, and fit all the four sides. Regards, Muneer, CC…. I see you already have it fit to page when printed - Do you mean you want to have the table forced into the shape of the page to completely fill the page? If so, I think you will need a macro, and it could be a bit tricky. You currently have a macro adjusting the margins in the Worksheet.SelectionChange event -- that will slow your worksheet down -- there is no need to reset the margins every time the cursor moves. It should be enough to just set them once in the Page Setup dialog, but if you want to reset them with a macro, use Worksheet.Activate or Workbook.BeforePrint (in Workbook.BeforePrint you might check if the worksheet is in ActiveWindow.SelectedSheets to determine if it is one being printed -- if needed -- it should be reliable in most cases). To resize the table, I would use the Page Setup oftion to Fit to 1 Page TALL, and leave the Fit to pages wide blank. This will only scale the table automatically to fit based on length, and take up as many pages wide as required. Then in your macro adjust the column widths to makke it fit on the one page. I am not experienced with this, so I will leave the details for you or others, unless I find the time to experiment with it. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: Monday, May 07, 2012 11:02 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Table data fit the page size..(auto) Dear friends, I want the Table margin fit the page size – by equally grow to all the four sides irrespective of the data consistency. Regards, Muneer, CC… -- 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
Re: $$Excel-Macros$$ Table data fit the page size..(auto)
WHICH??? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Mohammed Muneer Sent: Wednesday, May 09, 2012 8:52 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Table data fit the page size..(auto) Ya, u r right. Regards, Muneer, CC….. Are you talking about fitting when viewing or printing. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Mohammed Muneer Sent: Tuesday, May 08, 2012 11:32 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Table data fit the page size..(auto) Ya, but it doesn’t zoom to the margin, and fit all the four sides. Regards, Muneer, CC…. I see you already have it fit to page when printed - Do you mean you want to have the table forced into the shape of the page to completely fill the page? If so, I think you will need a macro, and it could be a bit tricky. You currently have a macro adjusting the margins in the Worksheet.SelectionChange event -- that will slow your worksheet down -- there is no need to reset the margins every time the cursor moves. It should be enough to just set them once in the Page Setup dialog, but if you want to reset them with a macro, use Worksheet.Activate or Workbook.BeforePrint (in Workbook.BeforePrint you might check if the worksheet is in ActiveWindow.SelectedSheets to determine if it is one being printed -- if needed -- it should be reliable in most cases). To resize the table, I would use the Page Setup oftion to Fit to 1 Page TALL, and leave the Fit to pages wide blank. This will only scale the table automatically to fit based on length, and take up as many pages wide as required. Then in your macro adjust the column widths to makke it fit on the one page. I am not experienced with this, so I will leave the details for you or others, unless I find the time to experiment with it. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: Monday, May 07, 2012 11:02 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Table data fit the page size..(auto) Dear friends, I want the Table margin fit the page size – by equally grow to all the four sides irrespective of the data consistency. Regards, Muneer, CC… -- 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
Re: $$Excel-Macros$$ Re: Find column # of first value greater than specified value?
I don’t recall why?? I gave that answer. Can you give more detail with examples and the logic of what you want. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Filip Houdek Sent: Wednesday, May 09, 2012 5:05 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Find column # of first value greater than specified value? Hello, I'm confused about that response. I don't know how SUMPRODUCT would help here. Could you explain a bit? Thanks On Tuesday, May 1, 2012 8:42:57 AM UTC-4, Don Guillett wrote: IF(SUMPRODUCT((B8:AE81)*B8:AE8)1,down,up) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Filip Houdek Sent: Monday, April 30, 2012 10:26 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Find column # of first value greater than specified value? Here is an example. I want to check row 8 (Price move) to see whether a value greater than 1 or less than -1 comes first, and return up or down in a specified cell based on which comes first (up if 1 comes first and down if -1 comes first). Eventually I want to check the next 30 values in row 8, starting from a cell to be determined, like an array re-defined to 30 columns to the right each time (I haven't gotten that far yet). Thanks! -- 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$$ urgent - pls help with this formula to match closest zip
copy to I3 and enter using CSEcopy down. =INDEX(Sheet1!$C$2:$C$140,MATCH(MIN(ABS(Sheet1!$C$2:$C$140-H3)),ABS(Sheet1!$C$2:$C$140-H3),0)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sara Lee Sent: Wednesday, May 09, 2012 10:01 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ urgent - pls help with this formula to match closest zip col i in Sheet 2 needs to be filled up . Can u please fill it up with a formula. Vlook true is not working by looking at sheet 1 col c value- either exact or next closest- I need to get the closest value. examples in sheet attached. Exact is first preference . if no exact is found, then the next closest value should be the answer. say if the value i am searching is 220 and the values in the sheet close to 220 are 240 and 212, 212 is the final answer since 212 is closer to 220 then 240. Difference should be less. Thanks -- 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$$ urgent - pls help with this formula to match closest zip
OR, use this withOUT the helper column. Again CSE =INDEX(Sheet1!$C$2:$C$140,MATCH(MIN(ABS(Sheet1!$C$2:$C$140-LEFT(C3,3))),ABS(Sheet1!$C$2:$C$140-LEFT(C3,3)),0)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sara Lee Sent: Wednesday, May 09, 2012 10:01 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ urgent - pls help with this formula to match closest zip col i in Sheet 2 needs to be filled up . Can u please fill it up with a formula. Vlook true is not working by looking at sheet 1 col c value- either exact or next closest- I need to get the closest value. examples in sheet attached. Exact is first preference . if no exact is found, then the next closest value should be the answer. say if the value i am searching is 220 and the values in the sheet close to 220 are 240 and 212, 212 is the final answer since 212 is closer to 220 then 240. Difference should be less. Thanks -- 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$$ Office stock
Won’t a simple vlookup using the false parameter work..?? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Smitha S R Sent: Wednesday, May 09, 2012 8:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Office stock Hi PFA the stock statement where I need help in the Dashboard. If I select, the item I need the relevant closing stock in the next cell. My formula is not working. Please help. Thanks Smitha -- 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$$ Name Manager
Homework? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Saturday, May 12, 2012 12:05 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Name Manager Hi, I want to know about Name Manager.. .. what is the use of Name manager.how to use it.. Can any one explain me with examples...or any nice links ..Thanks -- 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$$ Defining Same Name For ranges available in multiple tabs
This is very possible with an indirect formula or defined names or with a macro. Provide a file and your desires. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Shekhar Sharma Sent: Friday, May 11, 2012 4:59 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs I'm wondering if it's possible to define one name for columns in multiple worksheet. Basically I'm working on an estimating spreadsheet with multiple sheets; each sheet contains hundreds of individual costs (separate lines) which are categorized into more generic numerical buckets. So each line has a column for the generic buck and the cost. I'd like to have a summary sheet with a column summarizing these numerical buckets and the total cost for each bucket which is added from each sheet. Let's say the generic bucket column in each tab is called WBS, and the cost column is called COST. In my summary tab, I'd like a formula such as =SUMIF(WBS,A1,COST)...but of course this doesn't work. Any ideas on how I can solve this? -- Shekhar Sharma Life consists not in holding good cards but in playing those you hold well Before you judge another, think of your own last mistake. -- 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$$ query
Your desire is not clear. Provide a file with a complete explanation and examples. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Saturday, May 12, 2012 10:31 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query pick the values by vlookup or sumif only on visible cells. On Sat, May 12, 2012 at 8:19 PM, Rajan_Verma rajanverma1...@gmail.com wrote: CLTL+G ALT+S K Enter Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: 12 May 2012 8:40 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ query Dear Group, How to pick the values by formula of visible cells only? Regards, Aamir Shahzad -- 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, Aamir Shahzad -- 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$$ query
=SUMPRODUCT(SUBTOTAL(3,OFFSET($H$11:$H$100,ROW($H$11:$H$100)-MIN(ROW($H$11:$H$100)),,1)),--($H$11:$H$100=A2),--($I$11:$I$100)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Saturday, May 12, 2012 12:31 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query Example file is attached. On Sat, May 12, 2012 at 9:04 PM, dguillett1 dguille...@gmail.com wrote: Your desire is not clear. Provide a file with a complete explanation and examples. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Saturday, May 12, 2012 10:31 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query pick the values by vlookup or sumif only on visible cells. On Sat, May 12, 2012 at 8:19 PM, Rajan_Verma rajanverma1...@gmail.com wrote: CLTL+G ALT+S K Enter Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: 12 May 2012 8:40 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ query Dear Group, How to pick the values by formula of visible cells only? Regards, Aamir Shahzad -- 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, Aamir Shahzad -- 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$$ amend in macro
Sub Sheet1Multiplecopy() Dim i As Long For i = 1 To InputBox(howmany) Sheets(Sheet1).Copy After:=Sheets(i) ActiveSheet.Name = i Next i End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Saturday, May 12, 2012 2:40 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ amend in macro error reflecting, see the attached snapshot. On Sun, May 13, 2012 at 12:13 AM, dguillett1 dguille...@gmail.com wrote: For i = 1 To inputbox(“how many”) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Saturday, May 12, 2012 1:51 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ amend in macro Dear Group, Following macro provided by anyone in this forum this code is working fine but I want to amend into this coding e.g. when run this code it should ask by msg box How many sheets do you want to add? then take the input e.g 10 or any number then add sheets which given by user. Kindly do the needful. Thanks in advance. Sub Sheet1Multiplecopy() Dim i As Integer i = 1 For i = 1 To 100 Sheets(Sheet1).Select Sheets(Sheet1).Copy After:=Sheets(i) ActiveSheet.Name = i Next End Sub Regards, Aamir Shahzad -- 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, Aamir Shahzad -- 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$$ urgently help required how to get access field value into word table
Why is your request more urgent than other requests Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Dhartikumar Sahu Sent: Monday, May 14, 2012 2:28 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ urgently help required how to get access field value into word table hi group need urgently help required, to get ACCESS field value into word table. if any sample data that will also very helpful to me. -- Regards, Dhartikumar Sahu Sr.Database Manager - Institutional Equities IDBI Capital Markets Services Ltd 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450 -- 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$$ Split Large Excel file to multiple excel files and possible save the files
You may send to my personal email with an example. If you need to email or print you shouldn’t need to create at file for each. Simply create a report for each or email each. Details of your NEED for a separate file.. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Shekhar Sharma Sent: Monday, May 14, 2012 7:37 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Split Large Excel file to multiple excel files and possible save the files Hello Frndz, I have a killing task to create for all students specified xls for each parent with grades etc.. The data is retrieved from a large database. 1. I want to create specific sheets for each student from the massive excel file I want to create the sheet name by the name in A5 and H5 The data i want to retrive is in A to U columns until a new name comes in Column A I have three headers that needs also to come along too . 2. Then I want to save the new sheets with the students name and class in a folder X:\students Sorry in my office, I don't have permission to upload any file, so request you to help by creating your own dummy data or provide me your mail id, so that I can fwd from any other source. Thanks, -- Shekhar Sharma 9910010060 Life consists not in holding good cards but in playing those you hold well Before you judge another, think of your own last mistake. -- 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$$ Defining Same Name For ranges available in multiple tabs
Not the BEST solution. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Shekhar Sharma Sent: Monday, May 14, 2012 7:16 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs Thanks guys, it got resolved with the suggestion of =SUMIF(sheet1!WBS,A1,sheet1!COST)+SUMIF(sheet2!WBS,A1,sheet2!COST)+SUMIF(sheet3!WBS,A1,sheet3!COST) On Sat, May 12, 2012 at 6:48 PM, dguillett1 dguille...@gmail.com wrote: This is very possible with an indirect formula or defined names or with a macro. Provide a file and your desires. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Shekhar Sharma Sent: Friday, May 11, 2012 4:59 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs I'm wondering if it's possible to define one name for columns in multiple worksheet. Basically I'm working on an estimating spreadsheet with multiple sheets; each sheet contains hundreds of individual costs (separate lines) which are categorized into more generic numerical buckets. So each line has a column for the generic buck and the cost. I'd like to have a summary sheet with a column summarizing these numerical buckets and the total cost for each bucket which is added from each sheet. Let's say the generic bucket column in each tab is called WBS, and the cost column is called COST. In my summary tab, I'd like a formula such as =SUMIF(WBS,A1,COST)...but of course this doesn't work. Any ideas on how I can solve this? -- Shekhar Sharma Life consists not in holding good cards but in playing those you hold well Before you judge another, think of your own last mistake. -- 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 -- Shekhar Sharma 9910010060 Life consists not in holding good cards but in playing those you hold well Before you judge another, think of your own last mistake. -- 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
Re: $$Excel-Macros$$ hii i need copy a row to another based on condition
Provide a file with a complete explanation. I am a retired regional manager for ING and held a series 7 brokers license but have never heard of “nifty” stocks. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: coolguy Sent: Sunday, May 13, 2012 11:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ hii i need copy a row to another based on condition Hiii i need a help .. i have an excel sheet which changes dyamically and gives the word BUY in a cell C3 when C3 = buy i need to copy the values A3 B3 and D3 to another sheet .. ( like a call generate page) and also a pop up alert when there is a buy condition i need this for tracking nifty 50 stocks thankyou -- 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 Zero subtotal blocks
Provide a file with an explanation and example. One or many?? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: sreenivas kammari Sent: Monday, May 14, 2012 3:25 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Delete Zero subtotal blocks Hi, Is there anyone help me please on the below one. If the subtotal value is zero..copy to those block to another sheet and delete the entire subtotal block. Thank you, Srini -- 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$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!
I suggest you look in the vba help index for FIND and FINDNEXT. Find the value and then use offset to get data. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Indrajit $nai Sent: Monday, May 14, 2012 5:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading Hi All, Can anyone explain how to use Vlookup, Index, Match, Offset function in VBA Coading -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- 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 help-- Related to UDF
Give a couple of examples of your vlookup formula(s) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Amol Jadhav Sent: Monday, May 14, 2012 8:42 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help-- Related to UDF Hi Experts, I need your help to create UDF I want to create udf which will work as same as vlookup. Here my lookup value will be from column C for ex. $C2, my table array range will be from different workbook called export ,my column index no also fixed i.e 3. So my lookup value is fixed column, my table array range -- my table array range may vary so it must be dynamic and my column index no also fixed I know vlook up function and its works fine for me. but issue is I have team of 30 member they don't know anything about excel. So it will be great help for me. so I will just put my udf and drag it and I will get output from export 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
Re: $$Excel-Macros$$ Printing sheets in colour using VBA in ecel
Put this in the THISWORKBOOK module and delete your buttons. Now each sheet will print as desired. If you don’t want ALL sheets in the file then you can restrict by UN commenting lines Private Sub Workbook_BeforePrint(Cancel As Boolean) ‘if activesheet.name “dontdothisone” then ActiveSheet.PageSetup.BlackAndWhite =False ‘end if End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sunny Kapoor Sent: Monday, May 14, 2012 9:56 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Printing sheets in colour using VBA in ecel Hi Guys, I am trting to print sheets in colour using VBA. I am using the following code... Sub Print_sheet() With ActiveSheet .PageSetup.BlackAndWhite = False .PrintOut Copies:=1, Collate:=True End With End Sub __ I have put Buttons on each sheet and assigned this macro to every button. The problem is that for some sheets, the macro prints the sheets in colour while for some others, it prints them in Black White. Ant help would be appreciated... Cheers, Sunny -- 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$$ Re: Printing sheets in colour using VBA in ecel
Send me your file and tell me your excel version. I’ll look a bit later. When you say give the user an option to print. What do you mean. Be VERY specific. What I did will should do it for each sheet in the file when it is printed. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sunny Kapoor Sent: Monday, May 14, 2012 10:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel Hello Don, Thanks for the reply. Actually, i ned to give the user an option to print the sheet if he/she wants. Also, the command ou provided does not work. The print out is still not coloured. let me know if you could suggest something else... Sunny On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: Hi Guys, I am trting to print sheets in colour using VBA. I am using the following code... Sub Print_sheet() With ActiveSheet .PageSetup.BlackAndWhite = False .PrintOut Copies:=1, Collate:=True End With End Sub __ I have put Buttons on each sheet and assigned this macro to every button. The problem is that for some sheets, the macro prints the sheets in colour while for some others, it prints them in Black White. Ant help would be appreciated... Cheers, Sunny -- 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$$ Re: Printing sheets in colour using VBA in ecel
Based on the file you sent me with ONE sheet with graphs the easiest way would be to set up an additional printer with ONLY grayscale and call it bw or whatever and then print to that printer for bw and the other for color. Application.Dialogs(xlDialogPrinterSetup).ShowDon Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sunny Kapoor Sent: Monday, May 14, 2012 11:02 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel Hi, I have attached the file...Please let me know what should i do... Thanks in advance, Sunny On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: Hi Guys, I am trting to print sheets in colour using VBA. I am using the following code... Sub Print_sheet() With ActiveSheet .PageSetup.BlackAndWhite = False .PrintOut Copies:=1, Collate:=True End With End Sub __ I have put Buttons on each sheet and assigned this macro to every button. The problem is that for some sheets, the macro prints the sheets in colour while for some others, it prints them in Black White. Ant help would be appreciated... Cheers, Sunny On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: Hi Guys, I am trting to print sheets in colour using VBA. I am using the following code... Sub Print_sheet() With ActiveSheet .PageSetup.BlackAndWhite = False .PrintOut Copies:=1, Collate:=True End With End Sub __ I have put Buttons on each sheet and assigned this macro to every button. The problem is that for some sheets, the macro prints the sheets in colour while for some others, it prints them in Black White. Ant help would be appreciated... Cheers, Sunny On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: Hi Guys, I am trting to print sheets in colour using VBA. I am using the following code... Sub Print_sheet() With ActiveSheet .PageSetup.BlackAndWhite = False .PrintOut Copies:=1, Collate:=True End With End Sub __ I have put Buttons on each sheet and assigned this macro to every button. The problem is that for some sheets, the macro prints the sheets in colour while for some others, it prints them in Black White. Ant help would be appreciated... Cheers, Sunny -- 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$$ VLOOKUP HELP NEED
Sub lookitup() Dim c As Range For Each c In Range(a2:a Cells(Rows.Count, 1).End(xlUp).Row) c.Offset(, 1) = Columns(F).Find(c, LookIn:=xlValues, _ LookAt:=xlWhole, SearchOrder:=xlByRows, _ SearchDirection:=xlNext).Offset(, -1) Next End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Venkatesh Narla Sent: Monday, May 14, 2012 1:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VLOOKUP HELP NEED Hi Rajan, Can i get VBA code for this Thanks, Venkatesh. On Tue, May 15, 2012 at 12:13 AM, Venkatesh Narla nvenki...@gmail.com wrote: Thanks a lot... On Mon, May 14, 2012 at 11:50 PM, Rajan_Verma rajanverma1...@gmail.com wrote: See the attached Solution With Index/Match() Lookup() Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkatesh Narla Sent: 14 May 2012 11:30 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VLOOKUP HELP NEED Hi All, I need help in Vlookup need formula. Hi All, Column A has data; Column F is the range need E to pull 10001 #N/AA 10001 10002 B 10002 10003 C 10003 10004 D 10004 10005 E 10005 10006 F 10006 10007 G 10007 10008 H 10008 10009 I 10009 10010 J 10010 10011 K 10011 10012 L 10012 10013 M 10013 10014 N 10014 10015 O 10015 10016 P 10016 10017 Q 10017 10018 R 10018 10019 S 10019 10020 T 10020 -- 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.
Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel
My ans was based on what you sent Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sunny Kapoor Sent: Monday, May 14, 2012 2:38 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel well, Thanks for your reply. However, the file is quite big with more than 25 sheets. I sent one sheet to give an example. Now, the file will be used by many people but everyone would be interested in different sheets. The problem i am facing currently, like you must have seen is, the macro prints only black and white but manually you can print in colour, I would like the macro to print in colour ... Please see if you could help :) Thanks again, Sunny On Mon, May 14, 2012 at 9:34 PM, dguillett1 dguille...@gmail.com wrote: Based on the file you sent me with ONE sheet with graphs the easiest way would be to set up an additional printer with ONLY grayscale and call it bw or whatever and then print to that printer for bw and the other for color. Application.Dialogs(xlDialogPrinterSetup).ShowDon Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sunny Kapoor Sent: Monday, May 14, 2012 11:02 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel Hi, I have attached the file...Please let me know what should i do... Thanks in advance, Sunny On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: Hi Guys, I am trting to print sheets in colour using VBA. I am using the following code... Sub Print_sheet() With ActiveSheet .PageSetup.BlackAndWhite = False .PrintOut Copies:=1, Collate:=True End With End Sub __ I have put Buttons on each sheet and assigned this macro to every button. The problem is that for some sheets, the macro prints the sheets in colour while for some others, it prints them in Black White. Ant help would be appreciated... Cheers, Sunny On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: Hi Guys, I am trting to print sheets in colour using VBA. I am using the following code... Sub Print_sheet() With ActiveSheet .PageSetup.BlackAndWhite = False .PrintOut Copies:=1, Collate:=True End With End Sub __ I have put Buttons on each sheet and assigned this macro to every button. The problem is that for some sheets, the macro prints the sheets in colour while for some others, it prints them in Black White. Ant help would be appreciated... Cheers, Sunny On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: Hi Guys, I am trting to print sheets in colour using VBA. I am using the following code... Sub Print_sheet() With ActiveSheet .PageSetup.BlackAndWhite = False .PrintOut Copies:=1, Collate:=True End With End Sub __ I have put Buttons on each sheet and assigned this macro to every button. The problem is that for some sheets, the macro prints the sheets in colour while for some others, it prints them in Black White. Ant help would be appreciated... Cheers, Sunny -- 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
Re: $$Excel-Macros$$ 2 Values in the same cell
or, replace the values with formulas =d1”“e1. See attached Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Maries Sent: Wednesday, May 16, 2012 6:04 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ 2 Values in the same cell Hi, PFA... MARIES Excel Inspiration -- 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 2 values in one cell.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Want to use micros
Sub SortByColBAndColC() ActiveSheet.UsedRange.sort _ Key1:=Range(B2), Order1:=xlAscending, _ Key2:=Range(C2), Order2:=xlAscending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Anil Gawli Sent: Wednesday, May 16, 2012 6:47 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Want to use micros I have not used Macro,But itstead of that i have used Combobox if u liked then ok otherwise if u want macro then wait sometime. Find file attached On Wed, May 16, 2012 at 4:45 PM, Reshma Shelar onlyx...@gmail.com wrote: here is my raw data On Wed, May 16, 2012 at 4:24 PM, Anil Gawli gawlianil8...@gmail.com wrote: Hi Reshma for that i want your raw data . Provide me then i can give you with the solved attached sheet On Wed, May 16, 2012 at 11:08 AM, Reshma Shelar onlyx...@gmail.com wrote: Hi, I want to sort my data date name wise can i use micros for that, if yes please help me with the formula. Thanks Reshma -- 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, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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$$ Re: Charts
http://office.microsoft.com/en-us/excel-help/add-data-labels-to-a-chart-HP005198471.aspx#BMpositiondatalabels http://www.techrepublic.com/article/make-your-excel-charts-easier-to-read-with-custom-data-labels/6145493 http://www.ozgrid.com/forum/showthread.php?t=53916 Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: joseph camill Sent: Tuesday, May 15, 2012 2:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Charts example attached On Sat, May 5, 2012 at 10:02 AM, joseph.cam...@gmail.com wrote: Hi, I create a lot of stacked charts and I spend a lot of time formatting the overlapped numbers. I need a macro that will move numbers that overlap other numbers in a stacked chart. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- 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$$ 1. paste standard content to all sheets 2. paste sheet name to a specific cell
Pls put your name on the FROM request and provide a file. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: .. Sent: Wednesday, May 16, 2012 7:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ 1. paste standard content to all sheets 2. paste sheet name to a specific cell Dear Members I use XL 2003, Win XP. I have the following *request* 1. I have a workbook with approx 170 sheets 2. The first 90 or so sheets have some content in them (call them the old sheets), the remaining 80 or so are blank as of now (call them new sheets) 3. I wish to take the content from one of the old sheets ...say sheet # 70 and paste it to all the blank / new sheets [same source , paste on all *blank* sheets, paste only on blank sgeets] 4. Is there an easy way , with or without VB 5. Once (4) above is accomplished, 6. I need to past the sheet name of the *new* sheets - only new sheets on to cell B 11 of each of the new sheet. i.e. IF the name on sheet #100 is Delhi, I wish to copy the Text Delhi (without the quotes) to Cell B 11 of sheet # 100 any help towards the above would be gratefully acknowledged thanks in adv. and regards Subu -- 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$$ Re: help required for creating a formula
Core. Please REPLY to messages instead of creating a new one. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: CoRe Sent: Wednesday, May 16, 2012 4:57 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: help required for creating a formula Hello, PFA! On Wednesday, May 16, 2012 12:48:35 PM UTC+3, ashish damor wrote: Dear All, I have a list of industry in one column and in corresponding column the rates as per industry are given. I want to create a formula whereby when i selected a specific industry from the dropdown list automatically the corresponding rate is displayed in next cell. I am enclosing my worksheet. Please help me. Thanks all in advance. -- Thanking you. With regards, Ashish Damor -- 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$$ 1. paste standard content to all sheets 2. paste sheet name to a specific cell
Your example doesn’t help much. An ACTUAL sample is required. Dummy data is fine but must make sense. Why do you have 90 different sheets with data. Maybe one would do. You do not need to have blank sheets until needed. Each can be created as needed with a macro. I don’t understand copying an entire sheet putting something in cell b11 when already filled(on sample) and renaming. What do you want to do with the original sheet you copied from. Why have two? The logic is NOT clear. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: .. Sent: Wednesday, May 16, 2012 9:42 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ 1. paste standard content to all sheets 2. paste sheet name to a specific cell FROM : Subu --- Thanks Don Guillett - I have written my name on top of this mail... NOT sure if that is what is needed. I generally sign with my name as below - Sample sheet (of course with fewer sheets) is also enclosed regards Subu On Wednesday, May 16, 2012 5:20:57 PM UTC+4, Don Guillett wrote: Pls put your name on the FROM request and provide a file. Don Guillett Microsoft MVP Excel SalesAid Software From: Sent: Wednesday, May 16, 2012 7:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ 1. paste standard content to all sheets 2. paste sheet name to a specific cell Dear Members I use XL 2003, Win XP. I have the following *request* 1. I have a workbook with approx 170 sheets 2. The first 90 or so sheets have some content in them (call them the old sheets), the remaining 80 or so are blank as of now (call them new sheets) 3. I wish to take the content from one of the old sheets ...say sheet # 70 and paste it to all the blank / new sheets [same source , paste on all *blank* sheets, paste only on blank sgeets] 4. Is there an easy way , with or without VB 5. Once (4) above is accomplished, 6. I need to past the sheet name of the *new* sheets - only new sheets on to cell B 11 of each of the new sheet. i.e. IF the name on sheet #100 is Delhi, I wish to copy the Text Delhi (without the quotes) to Cell B 11 of sheet # 100 any help towards the above would be gratefully acknowledged thanks in adv. and regards Subu -- 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$$ Dynamic List range for Data validation
try Sub setdvlist() With Range(a2:a Cells(Rows.Count, 1).End(xlUp).Row) .Sort Key1:=Range(A2), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom .Name = dvlist End With With Range(b2).Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:==dvlist .IgnoreBlank = True .InCellDropdown = True .InputTitle = .ErrorTitle = .InputMessage = .ErrorMessage = .ShowInput = True .ShowError = True End With End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: chhajersand...@gmail.com Sent: Wednesday, May 16, 2012 11:21 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dynamic List range for Data validation Dear all, I want to create a list in data validation which take a dynamic range in alphabetic order. Can it be possible I have tried to find it google but could not solve this though have got solutions! Please help like you help us with indirect function module! Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -- 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$$ Re: Delete Zero subtotal blocks
Provide file Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: sreenivas kammari Sent: Thursday, May 17, 2012 1:58 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Delete Zero subtotal blocks Hi Don, Say for an example: I have data from A to H G col : HCol : 5 : -5 Subtotal: 0 Now, what I want is ...copy the entire block to another sheet and delete that zero subtotal block. Please do let me know if you need any more information. Thanks, Srini On Monday, May 14, 2012 1:55:06 PM UTC+5:30, sreenivas kammari wrote: Hi, Is there anyone help me please on the below one. If the subtotal value is zero..copy to those block to another sheet and delete the entire subtotal block. Thank you, Srini -- 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$$ Values 2 New
Sub makevalues() ActiveSheet.UsedRange.Value = _ ActiveSheet.UsedRange.Value End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Thursday, May 17, 2012 12:15 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Values 2 New Dear Group, Macro required which generate the same copy of sheet but values only. Regards, Aamir Shahzad -- 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$$ Apportioned of Expenses
Put in J5 and drag across and down =IF(E5yes,,$C5/SUMPRODUCT(($E5:$H5=yes)*$E$3:$H$3)*E$3) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sandeep Chhajer Sent: Friday, May 18, 2012 5:04 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Apportioned of Expenses Dear Excel Guru, Please find the attheche file. No of Student FSLE FSB FSC FSPA Total My Ans should be 25 13 40 10 88 Result required EXP Amount FSLE FSB FSC FSPA Printing 23,456 Yes Yes Yes Yes 6,664 3,465 10,6622,665 Fees344,567Yes Yes 84,516 260,051 Salary 2,345,098 Yes 2,345,098 other 56,743Yes Yes32,07224,671 Expenses needs to be apportined with respect to yes written adjoing col. -- Regards, Sandeep Kumar Chhajer. Ph. no: 07498171901 09339549906 Wish you all happy new Year 2011. -- 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$$ Converting from a single column to different rows
Look in the help index for TRANSPOSE. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Anand Kumar Sent: Saturday, May 19, 2012 1:50 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Converting from a single column to different rows Hi, I have a data set where Name, Address, STD Codes, Phone Number, Mobile No. all are in a single column for different people. I want to have names in first column, Address in next column and std codes, phone numbers in next columns. How to do it using VBA? Sample data: Anil Kumar Gupta T-510/F23c, Gali No-2,Baljeet Nagar New Delhi STD: 0 Phone: 0 Fax: 0 Mobile: 0 Email: Agency Code: 10079311 Expected Result: Anil Kumar Gupta T-510/F23c, Gali No-2,Baljeet Nagar New Delhi STD Phone Fax Mobile Email Agency Code: 10079311 -- 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$$
=RANK(C2,$C$2:$C$55)+SUMPRODUCT(--($C$2:$C$55=C2),--($A$2:$A$55A2)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Dhananjay Pinjan Sent: Saturday, May 19, 2012 6:12 AM To: excel-macros Subject: $$Excel-Macros$$ Dear All, I have used Rank Formula for ranking (pl. refer attachment). But if Highest Column reflects 2 same value (in following example 104) it should have to consider lower weight (Column A) should have to give first rank to him. The expected answer is as follows. Weight Name Highest Rank Expected 48 A 101 6 6 48 B 102 5 5 55 C 103 4 4 57 D 104 2 3 48 E 104 2 2 59 F 106 1 1 60 G 98 7 7 Regards, Dhananjay -- 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$$ Find the number missing in other cols
You need to make this clear Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Mohammed Muneer Sent: Saturday, May 19, 2012 7:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Find the number missing in other cols Dear friends, I have a set of cols called A B C D can please help me to solve the issue.. Note: please check the attached copy for further understanding. Regards, Muneer, CC.. -- 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 amount to Million
?? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Saturday, May 19, 2012 7:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Convert amount to Million Dear Group, Following macro is working fine but when run this code, Insert of column process is too much slow, please see amend. Private Sub Worksheet_Change(ByVal Target As Range) Dim rngCell As Range For Each rngCell In Target If Right(UCase(Trim(rngCell.Text)), 1) = M Then rngCell.Value = Replace(UCase(Trim(rngCell.Text)), M, ) * 10 ^ 6 End If Next End Sub -- Regards, Aamir Shahzad -- 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$$ NEW RULE : No more job postings in this forum.
OK by me... I’m in TEXAS Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ayush Jain Sent: Sunday, May 20, 2012 9:54 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ NEW RULE : No more job postings in this forum. Hello everyone, There is sudden increase in job posts and more than half of all job posts are irrelevent not related to excel. I have decided not to allow any jobs whether related to excel or not. This is not employment forum and intended to help on excel queries only. Anyone found posting jobs will be banned without any warning. Let me know if you have any questions. Regards Ayush Jain Group Manager and Microsoft MVP -- 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$$ Appropriate formula required
I don’t understand your example but here is a formula you can adapt if you have the analysis toolpak =MAX(0, MIN(EOMONTH(F$1,0), $B2) - MAX(F$1, $A2) + 1) * $C2 / $D2 Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Dhanesh Verma Sent: Monday, May 21, 2012 7:13 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Appropriate formula required Dear Friends, In the attached list the total monthly allocations is more than the total amount to be allocated, please suggest a suitable formula to compute the same. R’gds Dhanesh DISCLAIMER AND PRIVILEGE NOTICE : This e-mail and any files transmitted with it contain confidential, copyright, proprietary and legally privileged information. It should not be used by anyone who is not the original intended recipient. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you receive this transmission in error, please notify the sender by reply email and then destroy the message. Opinions, conclusions and other information in this message that do not relate to official business of DEN Networks Ltd., its subsidiaries, holding companies i.e. DEN shall be understood to be neither given nor endorsed by DEN. Internet communications cannot be guaranteed to be timely, Secure, error or virus-free. The sender does not accept liability for any errors or omissions. -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Vlookup is not working
Also, please do not use entire columns. Restrict to only area needed. =VLOOKUP(E3,Sheet1!E1:G100,3,FALSE) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Wednesday, May 23, 2012 7:06 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup is not working First of all, no need to yell: (VLOOKUP IS NOT WORKING) Second: Vlookup has 4 parts: lookup_value, table_array, col_index_num, range_lookup Vlookup will look in the FIRST column of the table_array for a value that matches the lookup_value since your lookup value is found in column E of sheet 1, your table_array should be Sheet1!E:G not Sheet1!B:G so, the formula in cell G3 should be: =VLOOKUP(E3,Sheet1!E:G,3,FALSE) hope this helps Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Amit Gandhi silkyro...@gmail.com To: excel-macros@googlegroups.com Sent: Wed, May 23, 2012 7:48:26 AM Subject: $$Excel-Macros$$ VLLOKUP IS NOT WORKING Hi Experts VLOOKUP is not working in attached file, can anyone help me why its not working and what will be right formula? Pls help me here. Regards Amit -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ queary
If you want help you need to: Use a meaningful subject line in your post give before/after examples and fully explain the logic. or... Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: anil kumar Sent: Thursday, May 24, 2012 5:48 AM To: excel-macros Subject: $$Excel-Macros$$ queary Hello friends, I have a queary plz find attahcment. Thanks Regards Anil -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: Macro on daily task
Dunno. Didn’t' realize I replied. Been hectic today. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: bpascal123 Sent: Thursday, May 24, 2012 7:29 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Macro on daily task Don, What is this post about? It has a reply I have deleted and files not related to the discussion. On Thursday, May 24, 2012 1:04:05 PM UTC+1, Don Guillett wrote: Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: bpascal123 Sent: Wednesday, May 23, 2012 7:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Macro on daily task Hi Chetan, I'm half way with your data query, column O is about Trans Type, now I'm not sure to understand how you want to copy the data, I don't see anything related to Brokerage win or Win and else. Please clarify, Pascal Baro -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: Macro on daily task
Must have replied to another post with a request for a file. ??? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: bpascal123 Sent: Thursday, May 24, 2012 4:29 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Macro on daily task btw don, i'm running a 64-bit machine and your yahoo-host spreadsheet shell code seems not able to run, but why the heck do you send such files in this discussion??? On Thursday, May 24, 2012 1:04:05 PM UTC+1, Don Guillett wrote: Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: bpascal123 Sent: Wednesday, May 23, 2012 7:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Macro on daily task Hi Chetan, I'm half way with your data query, column O is about Trans Type, now I'm not sure to understand how you want to copy the data, I don't see anything related to Brokerage win or Win and else. Please clarify, Pascal Baro -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Bold and italics
No can do in FORMULAS. Convert to value and then change format. Develop a macro to do it for you. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: joseph.cam...@gmail.com Sent: Friday, May 25, 2012 1:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Bold and italics Hi, I have concatenated two values. E.g., cell A1 has 12%, and A24 has 1. I want to concatenate both values in cell A40 as 12% 1, but 12% should be bold and 1 italics. Please help. Thanks, Joseph Sent on my BlackBerryŽ from Vodafone -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ doubt
In the future PLEASE try to use a meaningful subject line (doubt is not meaningful) and then explain your problem in the posting as well as in the attached file. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Saturday, May 26, 2012 5:44 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ doubt Hi all, Please find the attached query..Thanks -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ compatibility issues with 2007 VS 2010
http://technet.microsoft.com/en-us/library/ee624351.aspx I have xl97, 2003,2007,2010 all on the same computer. if you use Outlook, only ONE version allowed. Shouldn’t have a problem with 2007 and 2010. If you do, then develop in 2007. Of course, 2003 could have macro problems trying to run 2007. Again, develop in the lowest version used. I sometimes still have to develop in xl97. Hopefully, not xl95... Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: rekha siri Sent: Sunday, May 27, 2012 4:46 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ compatability issues with 2007 VS 2010 Hi Experts, can any one help me in this below concern one of our trainee has this concern. I feel by using Excel 2010 for analysis purpose only as of now will save our folks in FPA and sourcing Finance with lots of time (my stand is of ROI 1000%). For example one of the reports took me 6 hours just to compile the data set (over 600K rows) and analyze part by part, in the same case if I would have used Excel 2010 it would have taken me only 5-10 minutes using power pivot. There are certain questions I put forward to you... 1) What do you feel by ROI by using Excel 2010 Vs Excel 2010? 2) Problem with 2010 is compatibility so if people across TR are using 2007 and not 2010 then it might create trouble, is that there is a way to convert file format for 2007 user from 2010? 3) Does Windows Xp supports Excel 2010, and OS allows to have 2010, 2007 2003 for installation.I mean both 2007 version and 2010 version. Good Day! -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ compatibility issues with 2007 VS 2010
Install in separate folders and be sure to set your file associations as desired. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: rekha siri Sent: Monday, May 28, 2012 8:13 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ compatibility issues with 2007 VS 2010 Firstly would like to thank for the advise, Actually one of our users uses MS office 2007 it took nearly 6hours time to prepare some pivot table and formulas as the data is over 600k rows. were as in office 2010 using power pivot he could able to fix it in five minutes. so please advise, will it be best practise to install both office 2007 and 2010. Thanks alot for your help. On Sun, May 27, 2012 at 6:50 PM, dguillett1 dguille...@gmail.com wrote: http://technet.microsoft.com/en-us/library/ee624351.aspx I have xl97, 2003,2007,2010 all on the same computer. if you use Outlook, only ONE version allowed. Shouldn’t have a problem with 2007 and 2010. If you do, then develop in 2007. Of course, 2003 could have macro problems trying to run 2007. Again, develop in the lowest version used. I sometimes still have to develop in xl97. Hopefully, not xl95... Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: rekha siri Sent: Sunday, May 27, 2012 4:46 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ compatability issues with 2007 VS 2010 Hi Experts, can any one help me in this below concern one of our trainee has this concern. I feel by using Excel 2010 for analysis purpose only as of now will save our folks in FPA and sourcing Finance with lots of time (my stand is of ROI 1000%). For example one of the reports took me 6 hours just to compile the data set (over 600K rows) and analyze part by part, in the same case if I would have used Excel 2010 it would have taken me only 5-10 minutes using power pivot. There are certain questions I put forward to you... 1) What do you feel by ROI by using Excel 2010 Vs Excel 2010? 2) Problem with 2010 is compatibility so if people across TR are using 2007 and not 2010 then it might create trouble, is that there is a way to convert file format for 2007 user from 2010? 3) Does Windows Xp supports Excel 2010, and OS allows to have 2010, 2007 2003 for installation.I mean both 2007 version and 2010 version. Good Day! -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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
Re: $$Excel-Macros$$ Data validation
use a define name for the dv list in the other sheet such as dvlist then in the dv list =dvlist Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: chhajersand...@gmail.com Sent: Monday, May 28, 2012 10:41 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Data validation Dear excel guru, Is there any way I can keep source data list in another sheet (other than where I want to put the data validation) for data validation list command. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ VBA code to add many rows at the end of a named range ?
homework? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Jean PIERRE Sent: Monday, May 28, 2012 3:23 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA code to add many rows at the end of a named range ? Which is the VBA code to add many rows at the end of a named range ? The new rows must be part of the named range ! Thank you for your answer ! Regards, -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell
Use this simpler function in a REGULAR module for only numbers. For only text simply remove the NOT It will work with all strings such as 12abc34de56fgh78ijk9 Function ONSAS(rng As Range) Dim i As LONG For i = 1 To Len(rng) If Not Mid(rng, i, 1) Like [!0-9] Then ONSAS = ONSAS Mid(rng, i, 1) End If Next i End Function Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Tuesday, May 29, 2012 1:27 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell Dear Lakshman, Please see attached sheet, It is working fine.. Let's know where are you facing problem. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 29, 2012 at 11:44 AM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote: Hello champ., This formula is picking up only first disit of cell only. 1001GANG 1 1002COL. 1 1002TEJI 1 1003SUDH 1 Regards LAKSHMAN From: Rajan_Verma rajanverma1...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, May 28, 2012 7:12 PM Subject: RE: $$Excel-Macros$$ How to collect only numeric value from a particular cell Hi, If your data in Alphanumeric value in A1 then use it in B1 =IFERROR(SUM(INT(MID(A1,LARGE(--ISNUMBER(INT(MID(A1,ROW(INDIRECT(1:LEN(A1))),1)))*ROW(INDIRECT(1:LEN(A1))),ROW(INDIRECT(1:SUM(--ISNUMBER(INT(MID(A1,ROW(INDIRECT(1:LEN(A1))),1))),1)*10^ROW(INDIRECT(1:SUM(--ISNUMBER(INT(MID(A1,ROW(INDIRECT(1:LEN(A1))),1/10,) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vishal angre Sent: 28 May 2012 4:52 To: excel-macros@googlegroups.com Cc: noorain.ans...@gmail.com Subject: Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell Function removetext(c As String) Dim String1 As String Dim i As Integer String1 = For i = 1 To Len(c) If IsNumeric(Mid(c, i, 1)) Then String1 = String1 Mid(c, i, 1) End If Next removetext = String1 End Function On Mon, May 28, 2012 at 4:30 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote: How to collect only numeric value from a particular cell 1462NIRM 1462 1464NIRM 1464 1465NIRM 1465 1404--BL 1404 1031Infr 1031 8020LOKN 8020 202D.B. 202 922Parmi 922 5071RIFA 5071 1040Harj 1040 5078Harj 5078 1471Raj 1471 1571Raj 1571 414Ruchi 414 2084AJAY 2084 Regards LAKSHMAN -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- With Regards, Vishal K. Angre E-mail : visha...@gmail.com vishal.k.an...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for
Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell
Only gets the numbers left of text Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Tuesday, May 29, 2012 8:19 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell Hi, You can try ths =LOOKUP(99^99,--(0MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A10123456789)),ROW($1:$1 On Mon, May 28, 2012 at 4:30 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote: How to collect only numeric value from a particular cell 1462NIRM 1462 1464NIRM 1464 1465NIRM 1465 1404--BL 1404 1031Infr 1031 8020LOKN 8020 202D.B. 202 922Parmi 922 5071RIFA 5071 1040Harj 1040 5078Harj 5078 1471Raj 1471 1571Raj 1571 414Ruchi 414 2084AJAY 2084 Regards LAKSHMAN -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Multiple Versions of Excel
Just install in a directory OTHER than the previous verion. ie: MyExcel2010 Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ashish Pradhan Sent: Tuesday, May 29, 2012 9:16 AM To: Excel Macros Subject: $$Excel-Macros$$ Multiple Versions of Excel Hello I currently have installed Excel 2003 on my machine. However would also like to install 2010 now. If I change the default destination path, will it create any problems? Will I be easily able to open any excel file without any Version Clash issues I understand that very recently, someone suggested on this forum that multiple versions can be installed. Has anyone ever faced any Version Clash issues before? -- Thanks Ashish Pradhan -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ How to pick values from particular table/list
I would recommend that the defined name be flexible to include additions/deletions. =OFFSET(Data!$C$3,1,0,MATCH(zzz,Data!D:$C)-3,1) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Bé Trần Văn Sent: Tuesday, May 29, 2012 2:50 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to pick values from particular table/list 2012/5/29 NOORAIN ANSARI noorain.ans...@gmail.com Dear Amit, Please See attached sheet, I hope your requirement is this one otherwise revert. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 29, 2012 at 12:48 PM, Amit Gandhi silkyro...@gmail.com wrote: Thanks Noorain But i need something else. Let me clarify more. I am attaching revised excel file. I have some BL numbers in 2nd sheet BL_list and I want to enter Invoice details (INV#, INV DATE, INV AMT) against some B/L#s. I want to choose B/L# in each cell C5, C6, C7 ... from available list in 2nd sheet BL_list, column A and then fill in corresponding Invoice details against this. If its possible in Excel? Pls help me here. Regards Amit On Tue, May 29, 2012 at 12:03 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amit, You can use it.. =INDIRECT(ADDRESS(9+ROW(A3),12)) See attached sheet Hope it will help to you. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi silkyro...@gmail.com wrote: Hi Experts I want to pick value in Cell C7, C8, C9 ………from List given in Column L in attached file. How it will be possible? Pls help me here. Regards Amit -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- 'Expecting the world to treat u fairly coz u r a good person is like expecting the lion not to attack u coz u r a vegetarian. Think about it.' Take care Amit -- 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$$ How to pick values from particular table/list
I repeat I would recommend that the defined name be flexible to include additions/deletions. =OFFSET(Data!$C$3,1,0,MATCH(zzz,Data!D:$C)-3,1) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Anil Gawli Sent: Tuesday, May 29, 2012 11:36 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to pick values from particular table/list See the attached sheet FY Ref Regards, Gawli Anil On Wed, May 30, 2012 at 1:34 AM, dguillett1 dguille...@gmail.com wrote: I would recommend that the defined name be flexible to include additions/deletions. =OFFSET(Data!$C$3,1,0,MATCH(zzz,Data!D:$C)-3,1) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Bé Trần Văn Sent: Tuesday, May 29, 2012 2:50 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to pick values from particular table/list 2012/5/29 NOORAIN ANSARI noorain.ans...@gmail.com Dear Amit, Please See attached sheet, I hope your requirement is this one otherwise revert. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 29, 2012 at 12:48 PM, Amit Gandhi silkyro...@gmail.com wrote: Thanks Noorain But i need something else. Let me clarify more. I am attaching revised excel file. I have some BL numbers in 2nd sheet BL_list and I want to enter Invoice details (INV#, INV DATE, INV AMT) against some B/L#s. I want to choose B/L# in each cell C5, C6, C7 ... from available list in 2nd sheet BL_list, column A and then fill in corresponding Invoice details against this. If its possible in Excel? Pls help me here. Regards Amit On Tue, May 29, 2012 at 12:03 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amit, You can use it.. =INDIRECT(ADDRESS(9+ROW(A3),12)) See attached sheet Hope it will help to you. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi silkyro...@gmail.com wrote: Hi Experts I want to pick value in Cell C7, C8, C9 ………from List given in Column L in attached file. How it will be possible? Pls help me here. Regards Amit -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- 'Expecting the world to treat u fairly coz u r a good person is like expecting the lion not to attack u coz u r a vegetarian. Think about it.' Take care Amit -- FORUM RULES (986+ members already BANNED for violation
Re: $$Excel-Macros$$ MACRO
These messages are cluttering. For the sake of us all can you strongly suggest that responses to offers be make OFF LIST. When I offer a file I will either attach to the group, put in files area (if available) or say “I will ONLY respond to OFF list requests for this file” Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ayush Jain Sent: Thursday, May 31, 2012 9:55 AM To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI Subject: Re: $$Excel-Macros$$ MACRO Hello everyone, I hope the book which is being shared in this thread is free ebook and not the paid one. I am strongly against sharing pirated copies without the consent of author. Let me know if you have any queries. Thanks. Regards Ayush Jain Group Manager Microsoft MVP On Thursday, 31 May 2012 19:59:26 UTC+5:30, Bullet wrote: Dear Noorian, Can you please send me those ebooks to my mail id: talk2indra...@gmail.com Thanks in advance. On Thu, May 31, 2012 at 4:44 PM, Prakash Paul jprakashp...@gmail.com wrote: Dear Noorian, Please send the 2007 file to jprakashp...@gmail.com. Thanks in advance Regards Paul -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Dynamic Worksheet Reference
Don’t use indirect. Simply use a formula referring to the closed workbook. Then, when the name of the source file changes use edit replace old name with new name. A macro using specialcells for formuias would be best. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Babak H Sent: Friday, June 01, 2012 2:32 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dynamic Worksheet Reference Hello, I am new to this group and I am unsure if this topic was covered in the past so I apologize in advance. Problem: I have external worksheets that i get on a montly basis (Naming convention is the same and the date gets updated. I.E. Report May 2012.xls, Report April 2012.xls) I have another worksheet where I summarize these reports. In this summary report I would like to create a dynamic formula that could possibly reference a cell that contains the updated date (i.e. June 2012) and simply just drag my formula down to fill in the report. I have tried the =indirect() function however, that only works when the worksheet is open which doesn't work for me in this purpose. I have tried various avenues, some silly some advanced but I have not been able to come to a solution. Any direction on this issue would be GREATLY appreciated. -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ vba formula vs calculation - problem with = or dates
There may? be a better way to do this. Reply to ME at the address below with your file. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Mark Kerin Sent: Friday, June 01, 2012 1:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ vba formula vs calculation - problem with = or dates This formula works in a cell: =SUMIFS(O$2:O$26196,A$2:A$26196,A2,N$2:N$26196,=N2) 1) I want to have vba make this calculation - because calculating it in each cell bogs down the xls. I got the following vba to work but I cant figure out how to add = to the last clause (col N has dates): .Range(q i).Formula = =SUMIFS(O$2:O$26196,A$2:A$26196, a i ,N$2:N$26196, n i ) 2) How do I get VBA to make this calculation and put the result in each cell instead of putting a formula in each cell? ...I am open to other suggestions... e.g. would an array use less resources? Thanks. -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ How to find paritcular word from sentence
And you could combine into ONE formula Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ashish koul Sent: Sunday, June 03, 2012 6:25 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to find paritcular word from sentence check the attachment see if it helps On Sun, Jun 3, 2012 at 2:09 PM, SUDHIR VERMA newinex...@gmail.com wrote: Dear Ashish, Thank you so much and Please can u explain this for understanding me. thanking you On 03/06/2012, ashish koul koul.ash...@gmail.com wrote: check the attachment see if it helps On Sun, Jun 3, 2012 at 1:53 PM, SUDHIR VERMA newinex...@gmail.com wrote: Dear All, Please resolved below query. Being accounts credited as per bill no: 45586, dt: 7.8.11, GR No: 785, dt: 6.8.11, by NTU. Being accounts credited as per GR No: 100486 dt: 5.9.11, Bill no 889, dt: 4.9.11 by Fedex. Bill No: 97849, dt: 10.8.11 and gr no 56478789, dt:1.8.11 through Nalagarh Truk Union. I have more than 500 sentences like above and every time i want found GR No.. dt:.. in separated column (Result Like below) GR No: 785, dt: 6.8.11 GR No: 100486 dt: 5.9.11 gr no 56478789 thanking you regards sudhir -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- Regards Ashish Koul http://www.excelvbamacros.com/ http://www.accessvbamacros.com/ P Before printing, think about the environment. -- 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
Re: $$Excel-Macros$$ Records found but unable to get proper result.
How about a nice macro? Change your formatting and use in macro enabled workbook Sub filtercopy() With Sheets(COURSES).UsedRange .AutoFilter Field:=1 'criteria IF needed .AutoFilter Field:=2 .AutoFilter Field:=3, Criteria1:=Sheets(form).Range(n1) .Offset(1, 3).Resize(, 2).SpecialCells(xlVisible). _ Copy Sheets(form).Range(d35) End With End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sourabh Salgotra Sent: Sunday, June 03, 2012 5:08 AM To: excel-macros@googlegroups.com Cc: Don Guillett ; rajanverma1...@gmail.com ; noorain.ans...@gmail.com Subject: $$Excel-Macros$$ Records found but unable to get proper result. Dear sir, i am using index/match formula. in my problem i am getting the 1st occurrence result only. Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS I 2 #NUM! #NUM! 3 #NUM! #NUM! 4 #NUM! #NUM! 5 #NUM! #NUM! 6 #NUM! #NUM! 7 #NUM! #NUM! 8 #NUM! #NUM! 9 #NUM! #NUM! i want the output like this. Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS 2 BF 2 CHEMISTRY 3 BF 3 ENGLISH I 4 BF 4 ELECTRICAL TECHNOLOGY 5 BF 5 MECHANICS 6 BF 6 INTRODUCTION TO MANUFACTURING PROCESS 7 BF 2P CHEMISTRY PRACTICAL 8 BF 4P ELECTICAL TECHNOLOGY PRACTICAL 9 BF 7 INDIAN CONSTITUTION AND ETHICS sample sheet attached Thanks Regards Sourabh Contact Numbers: +91-94630-49202 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Records found but unable to get proper result.
I like my solution. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sourabh Salgotra Sent: Sunday, June 03, 2012 12:53 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Records found but unable to get proper result. thanks for help. plz provide index/atch solution also On Sun, Jun 3, 2012 at 6:35 PM, dguillett1 dguille...@gmail.com wrote: How about a nice macro? Change your formatting and use in macro enabled workbook Sub filtercopy() With Sheets(COURSES).UsedRange .AutoFilter Field:=1 'criteria IF needed .AutoFilter Field:=2 .AutoFilter Field:=3, Criteria1:=Sheets(form).Range(n1) .Offset(1, 3).Resize(, 2).SpecialCells(xlVisible). _ Copy Sheets(form).Range(d35) End With End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sourabh Salgotra Sent: Sunday, June 03, 2012 5:08 AM To: excel-macros@googlegroups.com Cc: Don Guillett ; rajanverma1...@gmail.com ; noorain.ans...@gmail.com Subject: $$Excel-Macros$$ Records found but unable to get proper result. Dear sir, i am using index/match formula. in my problem i am getting the 1st occurrence result only. Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS I 2 #NUM! #NUM! 3 #NUM! #NUM! 4 #NUM! #NUM! 5 #NUM! #NUM! 6 #NUM! #NUM! 7 #NUM! #NUM! 8 #NUM! #NUM! 9 #NUM! #NUM! i want the output like this. Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS 2 BF 2 CHEMISTRY 3 BF 3 ENGLISH I 4 BF 4 ELECTRICAL TECHNOLOGY 5 BF 5 MECHANICS 6 BF 6 INTRODUCTION TO MANUFACTURING PROCESS 7 BF 2P CHEMISTRY PRACTICAL 8 BF 4P ELECTICAL TECHNOLOGY PRACTICAL 9 BF 7 INDIAN CONSTITUTION AND ETHICS sample sheet attached Thanks Regards Sourabh Contact Numbers: +91-94630-49202 -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- 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
Re: $$Excel-Macros$$ counting E in the column
This yields 27 =SUMPRODUCT((RIGHT(B3:B17,1)=e)*(C3:H170)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Sunday, June 03, 2012 1:41 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ counting E in the column Dear All, I need your help with following. I'd like to count apperiance of numbers bigger then 0 and having in product code E at the end. See attachment. Regarrds, Pawel -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Rajan Vera - Most helpful Member(May'12)
Ditto from Texas Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Sunday, June 03, 2012 3:48 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12) Congratulations again Cheeteh great going. Regards, Sam Mathai Chacko On Mon, Jun 4, 2012 at 12:17 AM, resp...@gmail.com wrote: Congratulation Raj. Proud of you. Lunch for you tommorrow. Sent from my BlackBerry® smartphone from Airtel Ghana -- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 3 Jun 2012 23:12:31 +0530 To: excel-macrosexcel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12) Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of May'2012 He has posted 147 posts in May 2012 and helped many people through his expertise. I truly appreciate his consistency and commitment to group. He is really doing great job God bless you :) Thanks to Noorain, Don, Asa, Maries, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Trust me, It requires big heart to help others voluntarily and thanks to everyone who is supporting this forum. Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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
Re: $$Excel-Macros$$ Urgent help required for Vlookup macro code
May I ask why your request is more urgent and more important than the other requests.?? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Nagendra Modupalli Sent: Monday, June 04, 2012 11:30 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent help required for Vlookup macro code Hi Experts, I have data with Employee number,based on employee number i need to get the date of join.i have many file with DOJ. What is the VBA vlookup code for looking one file and if not find the DOJ filter blanks and asking next file to lookup. Thanks in advance. -- ThanksRegards Nagendra.M Beautiful photos are developed by negatives in a dark room, so if U see darkness in Ur life believe that God is making a beautiful future for U !!! -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Need VBA to select and reassign moving XY chart data
This can probably be greatly simplified. Provide your excel version and the file. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: thatguy Sent: Monday, June 04, 2012 9:59 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need VBA to select and reassign moving XY chart data I have data that I am importing regularly and the number of lines of the data is highly variable. I have written code that first inserts a column of data I need for my Y axis, then the second part of my code should select the my X and Y range and change the graph accordingly then thirdly modify the limits of the major axis to the nearest largest multiple of 10 of the data. My sections 2 and three are not working properly. If you can help with any part I would be very grateful. Here is my code: Sub Tip_Elevation() ' ' Tip_Elevation Macro ' Insert Tip Elevation Depth (Ft) ' ' Keyboard Shortcut: Ctrl+Shift+I 'Insert column needed for Y Axis Cells.find(What:=Test).Activate Selection.Offset(0, -1).Select ActiveCell.FormulaR1C1 = TIP Down ActiveCell.FormulaR1C1 = Elevation Down ActiveCell.FormulaR1C1 = Depth Down ActiveCell.FormulaR1C1 = (ft) Down ActiveCell.FormulaR1C1 = '- Down ActiveCell.FormulaR1C1 = =-RC[1] Down Selection.Offset(0, 1).Activate 5 If ActiveCell 0 Then GoTo 10 GoTo 15 10 Selection.Offset(0, -1).Select ActiveCell.FormulaR1C1 = =-RC[1] Down Selection.Offset(0, 1).Activate GoTo 5 15 ' modify_graph Macro ' 'Determine the number of rows are in data n = 0 'number of rows in graph data Cells.find(What:=Test).Activate 'Find Column with Test Selection.Offset(5, 0).Select 'Select fist number of column 20 If ActiveCell 0 Then GoTo 25 'If number exists go to 15 GoTo 30 'End counter 25 n = n + 1 'Add counter Down GoTo 20 'Continue counter 30 'Determine Y Vaule Range Dim RngYVal As Range 'Cells.FindNext(After:=ActiveCell).Activate 'Cells.FindNext(After:=ActiveCell).Activate 'Cells.find(What:=Tip).Activate Cells.find(What:=TIP, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _ True, SearchFormat:=False).Activate Selection.Offset(5, 0).Select Set RngYVal = Range(ActiveCell, ActiveCell.Offset(n, 0)) 40 'Determine X Value Range Dim RngXVal As Range Cells.find(What:=TIP, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _ True, SearchFormat:=False).Activate Selection.Offset(5, 6).Select Set RngXVal = Range(ActiveCell, ActiveCell.Offset(n, 0)) 50 'Set graph Data Sheets(Curve).Select ActiveChart.SeriesCollection(1).XValues = RngXVal ActiveChart.SeriesCollection(1).Values = RngYVal 60 'Modify Axis Limits 61 'Find Max Depth - factor of 10 Dim Depth As Integer ActiveSheet.Previous.Select 'Selects the Previous Sheet Cells.find(What:=TIP, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _ True, SearchFormat:=False).Activate Selection.Offset(n + 5, 0).Select Depth = ActiveCell Depth = Application.RoundUp(lngRHDataRows / 10, 0) Depth = Depth * 10 ActiveCell.Offset(1, 0) = Depth 62 'Find Max Load - factor of 10 Dim Load As Integer Selection.Offset(-1, 6).Select Load = ActiveCell Load = Application.RoundUp(lngRHDataRows / 10, 0) Load = Depth * 10 ActiveCell.Offset(1, 0) = Load 65 'Change Graph Axis limits Sheets(Curve).Select ActiveSheet.ChartObjects(Chart 7).Activate ActiveChart.Axes(xlValue).Select ActiveChart.PlotArea.Select ActiveChart.Axes(xlValue).Select ActiveChart.Axes(xlValue).MinimumScale = Depth ActiveChart.Axes(xlCategory).Select ActiveChart.Axes(xlCategory).MaximumScale = Load End Sub Thank you for all and any 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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
Re: $$Excel-Macros$$ Multiple excel sheets in merge in single excel sheet
You can use the vba DIR to open each file in the current folder and then copy the used range.offset(1) to the next available row in the consolidate file. If necessary, you can specify the files within an array Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Kishore Sent: Friday, June 01, 2012 2:45 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Multiple excel sheets in merge in single excel sheet Hi Excel Gurus, I have three different excel sheets with data top of the first at rows names are described, all though three excel sheets headings at rows are little vary , I would like to merge all these 3 excel sheets in single workbook excel sheet. Please help do the needful. File attached. Regards, Kishore K. -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Extract Names from different sheet into one sheet
Why not use a macro to gather all and then do a unique on the gathered list? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: hilary lomotey Sent: Wednesday, June 06, 2012 10:39 AM To: excel-macros Subject: $$Excel-Macros$$ Extract Names from different sheet into one sheet Hello Experts, i have data of names sitting in sheet 2 to sheet 4 in the attached. is it possible to have a formula to extract all these names into one column in sheet 1. thanks -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Condensing Multiple Worksheets Into One ...
I would have written it a bit more efficiently but what it is doing is copying all of current region of each sheet to a new sheet. What do you want to do??? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: David Grugeon Sent: Wednesday, June 06, 2012 5:49 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Condensing Multiple Worksheets Into One ... You can use a formula like =sum(Sheet1:sheet17!A1) and it will add all the cells A1 in the sheets called Sheet1, Sheet17 and all sheets physically between them. On 7 June 2012 05:52, Greg gamoun...@gmail.com wrote: Hello, I am trying to process an Excel macro I found online from the following weblink: http://excel.tips.net/T003005_Condensing_Multiple_Worksheets_Into_One.html Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add ' add a sheet in first place Sheets(1).Name = Combined ' copy headings Sheets(2).Activate Range(A1).EntireRow.Select Selection.Copy Destination:=Sheets(1).Range(A1) ' work through sheets For J = 2 To Sheets.Count ' from sheet 2 to last sheet Sheets(J).Activate ' make the sheet active Range(A1).Select Selection.CurrentRegion.Select ' select all cells in this sheets ' select all lines except title Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select ' copy cells selected in the new sheet on last line Selection.Copy Destination:=Sheets(1).Range(A65536).End(xlUp)(2) Next End SubAccording to the description, I can either use the Excel Consolidate tool or the above macro. Unfortunately, I didn't have much luck with the Consolidate tool because I don't understand how to reference each of the worksheet ranges. Once I run the macro, it appears to be doing something because I can see it trans-versing through each worksheet. When the macro has completed, the first sheet in the workbook is not named Combined, and it contains no data from the other worksheets. Thanks in advance for any assistance you can provide. Kind regards, Greg -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- David Grugeon -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe,
Re: $$Excel-Macros$$ Condensing Multiple Worksheets Into One ...
I adhere to the KISS principle so here is a simple macro. If you want the second row change to rows(2) Option Explicit Sub copytoprowofallsheets() 'fire from the First sheet(sheet to far left) Dim i As Long For i = 2 To Sheets.Count Sheets(i).Rows(1).Copy Cells(Rows.Count, 1).End(xlUp)(2) Next i End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Greg Sent: Wednesday, June 06, 2012 6:09 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Condensing Multiple Worksheets Into One ... Hi Don, Thanks for your reply. I want to do exactly what it says. I have identically structured data in each worksheet, and wish to combine the multiple worksheets into a single, large worksheet. The names of each worksheet is different. However, they all have content in the first row. I wish to copy the first row content one after the other into one large worksheet. Regards, Greg On Wednesday, June 6, 2012 6:59:27 PM UTC-4, Don Guillett wrote: I would have written it a bit more efficiently but what it is doing is copying all of current region of each sheet to a new sheet. What do you want to do??? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: David Grugeon Sent: Wednesday, June 06, 2012 5:49 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Condensing Multiple Worksheets Into One ... You can use a formula like =sum(Sheet1:sheet17!A1) and it will add all the cells A1 in the sheets called Sheet1, Sheet17 and all sheets physically between them. On 7 June 2012 05:52, Greg gamoun...@gmail.com wrote: Hello, I am trying to process an Excel macro I found online from the following weblink: http://excel.tips.net/T003005_Condensing_Multiple_Worksheets_Into_One.html Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add ' add a sheet in first place Sheets(1).Name = Combined ' copy headings Sheets(2).Activate Range(A1).EntireRow.Select Selection.Copy Destination:=Sheets(1).Range(A1) ' work through sheets For J = 2 To Sheets.Count ' from sheet 2 to last sheet Sheets(J).Activate ' make the sheet active Range(A1).Select Selection.CurrentRegion.Select ' select all cells in this sheets ' select all lines except title Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select ' copy cells selected in the new sheet on last line Selection.Copy Destination:=Sheets(1).Range(A65536).End(xlUp)(2) Next End SubAccording to the description, I can either use the Excel Consolidate tool or the above macro. Unfortunately, I didn't have much luck with the Consolidate tool because I don't understand how to reference each of the worksheet ranges. Once I run the macro, it appears to be doing something because I can see it trans-versing through each worksheet. When the macro has completed, the first sheet in the workbook is not named Combined, and it contains no data from the other worksheets. Thanks in advance for any assistance you can provide. Kind regards, Greg -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- David Grugeon -- 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$$ Condensing Multiple Worksheets Into One ...
I understood you wanted the first or second row only. If you want all but the header row. Option Explicit Sub copytoprowofallsheets() 'fire from the First sheet(sheet to far left) Dim i As Long For i = 2 To Sheets.Count Sheets(i).UsedRange.Offset(1).Copy Cells(Rows.Count, 1).End(xlUp)(2) Next i End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Greg Sent: Wednesday, June 06, 2012 6:09 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Condensing Multiple Worksheets Into One ... Hi Don, Thanks for your reply. I want to do exactly what it says. I have identically structured data in each worksheet, and wish to combine the multiple worksheets into a single, large worksheet. The names of each worksheet is different. However, they all have content in the first row. I wish to copy the first row content one after the other into one large worksheet. Regards, Greg On Wednesday, June 6, 2012 6:59:27 PM UTC-4, Don Guillett wrote: I would have written it a bit more efficiently but what it is doing is copying all of current region of each sheet to a new sheet. What do you want to do??? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: David Grugeon Sent: Wednesday, June 06, 2012 5:49 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Condensing Multiple Worksheets Into One ... You can use a formula like =sum(Sheet1:sheet17!A1) and it will add all the cells A1 in the sheets called Sheet1, Sheet17 and all sheets physically between them. On 7 June 2012 05:52, Greg gamoun...@gmail.com wrote: Hello, I am trying to process an Excel macro I found online from the following weblink: http://excel.tips.net/T003005_Condensing_Multiple_Worksheets_Into_One.html Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add ' add a sheet in first place Sheets(1).Name = Combined ' copy headings Sheets(2).Activate Range(A1).EntireRow.Select Selection.Copy Destination:=Sheets(1).Range(A1) ' work through sheets For J = 2 To Sheets.Count ' from sheet 2 to last sheet Sheets(J).Activate ' make the sheet active Range(A1).Select Selection.CurrentRegion.Select ' select all cells in this sheets ' select all lines except title Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select ' copy cells selected in the new sheet on last line Selection.Copy Destination:=Sheets(1).Range(A65536).End(xlUp)(2) Next End SubAccording to the description, I can either use the Excel Consolidate tool or the above macro. Unfortunately, I didn't have much luck with the Consolidate tool because I don't understand how to reference each of the worksheet ranges. Once I run the macro, it appears to be doing something because I can see it trans-versing through each worksheet. When the macro has completed, the first sheet in the workbook is not named Combined, and it contains no data from the other worksheets. Thanks in advance for any assistance you can provide. Kind regards, Greg -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- David Grugeon -- 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$$ Condensing Multiple Worksheets Into One ...
For the entire used range simply remove the .offset(1) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Greg Sent: Thursday, June 07, 2012 1:54 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Condensing Multiple Worksheets Into One ... Hi Don, This macro works and accomplishes what I need. And I agree with your KISS principle whenever possible. BTW, if I want to use this same macro and keep the headers what must I change? Thanks, Greg On Thursday, June 7, 2012 12:52:25 PM UTC-4, Don Guillett wrote: I understood you wanted the first or second row only. If you want all but the header row. Option Explicit Sub copytoprowofallsheets() 'fire from the First sheet(sheet to far left) Dim i As Long For i = 2 To Sheets.Count Sheets(i).UsedRange.Offset(1).Copy Cells(Rows.Count, 1).End(xlUp)(2) Next i End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Greg Sent: Wednesday, June 06, 2012 6:09 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Condensing Multiple Worksheets Into One ... Hi Don, Thanks for your reply. I want to do exactly what it says. I have identically structured data in each worksheet, and wish to combine the multiple worksheets into a single, large worksheet. The names of each worksheet is different. However, they all have content in the first row. I wish to copy the first row content one after the other into one large worksheet. Regards, Greg On Wednesday, June 6, 2012 6:59:27 PM UTC-4, Don Guillett wrote: I would have written it a bit more efficiently but what it is doing is copying all of current region of each sheet to a new sheet. What do you want to do??? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: David Grugeon Sent: Wednesday, June 06, 2012 5:49 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Condensing Multiple Worksheets Into One ... You can use a formula like =sum(Sheet1:sheet17!A1) and it will add all the cells A1 in the sheets called Sheet1, Sheet17 and all sheets physically between them. On 7 June 2012 05:52, Greg gamoun...@gmail.com wrote: Hello, I am trying to process an Excel macro I found online from the following weblink: http://excel.tips.net/T003005_Condensing_Multiple_Worksheets_Into_One.html Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add ' add a sheet in first place Sheets(1).Name = Combined ' copy headings Sheets(2).Activate Range(A1).EntireRow.Select Selection.Copy Destination:=Sheets(1).Range(A1) ' work through sheets For J = 2 To Sheets.Count ' from sheet 2 to last sheet Sheets(J).Activate ' make the sheet active Range(A1).Select Selection.CurrentRegion.Select ' select all cells in this sheets ' select all lines except title Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select ' copy cells selected in the new sheet on last line Selection.Copy Destination:=Sheets(1).Range(A65536).End(xlUp)(2) Next End SubAccording to the description, I can either use the Excel Consolidate tool or the above macro. Unfortunately, I didn't have much luck with the Consolidate tool because I don't understand how to reference each of the worksheet ranges. Once I run the macro, it appears to be doing something because I can see it trans-versing through each worksheet. When the macro has completed, the first sheet in the workbook is not named Combined, and it contains no data from the other worksheets. Thanks in advance for any assistance you can provide. Kind regards, Greg -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- David Grugeon -- FORUM RULES (986+ members already
Re: $$Excel-Macros$$ How to add combo box in a sheet.....Need Help.....
Create combobox1 in sheet1 and then put this code in the SHEET module Private Sub Worksheet_Activate() Sheet1.ComboBox1.Clear Dim sh As Worksheet For Each sh In Worksheets Sheet1.ComboBox1.AddItem (sh.Name) Next End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Mangesh Dayne Sent: Friday, June 08, 2012 6:17 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to add combo box in a sheet.Need Help. Hi Friends, I have to add combo box in a sheet that will contain all sheets name and when i select the any sheet name in combo box, it will activate in the workbook, means I can able to see the contents of sheet simply by selecting the sheet from combo box list. Moreover, combo box should automatically update the sheet name, means if i deleted any sheet from workbook the entry from the combo box should also be deleted. Thanks a lot. Please help Mangesh -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Edit Cell
Unlock all you want to allow lock that one protect sheet Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Deba Ranjan Sent: Friday, June 08, 2012 9:07 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Edit Cell Dear Its is possible to Lock a particular cell only, I mean user cant able to edit this cell only, rest they can able to edit. Even the E3 cell should not be able to edit, Rest can be edit. Please see the attached. thank you. Thanks Regards, Deba Ranjan P -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Introduce Yourself !!
BBA University of Texas 1959, Graduate studies at UT law school and NYU. Ex US Air Force Officer. I am a retired Regional Manager for ING and held a stock brokers series 7 license and insurance license. To keep myself busy, I am an independent Excel Developer for projects large and small and Excel MVP for years on other forums For many years I was also a road race car driver holding an International FIA racing license and race driving instructor. driving SCCA EP MGB, Formula Ford, and Formula 2 open wheel single seat race cars in the US and Mexico. I live in beautiful Austin Texas on the top of a hill with a view of the lake and at age 76 I do only what I want to do. It is really nice Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ayush Jain Sent: Sunday, June 10, 2012 11:47 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Introduce Yourself !! Dear all, Good to know you all and feels proud to be part of this forum. Let me introduce myself. I am Ayush Jain from Delhi, India. Presently working as senior analyst in Ernst Young and my work includes bulding Excel Access based models for clients for analysis, reporting, planning etc. I started this forum 5 years back with the aim to provide quality solutions for excel and vba queries I am quite happy to see what we are today. This is one of the largest forum which is spam free and always buzzing with activity. I have received Microsoft MVP award in 2010 2011 for my voluntry contribution to various communities in excel. For more details:-Please visit my MVP profile I really appreciate the forum members for their active paticipation and voluntry help to others. If you have any feedback, click here. Keep introducing yourself!! Many Thanks. -Ayush Jain Group Manager / Microsoft MVP On Sun, Jun 10, 2012 at 2:23 PM, David Grugeon da...@grugeon.com.au wrote: Hi all 'Excel'lent people This is David Grugeon from Brisbane Australia. I work as an accountant/consultant for local governments - mainly one in Thargomindah which is 1000 Km west of Brisbane and one in Thursday Island which is 2000 Km North. I use excel all the time for work and am currently working on the Budget for Bulloo Shire Council (Thargomindah) with about ten interlinked workbooks with many sheets each. I use VBA a lot where it saves me time. I think I have quite good Excel skills developed by helping others on groups like this one. If you try to answer the questions you learn a lot which you can use in the future. If oyu are interested Bulloo Shire council has an area of about 83000 sq Km (about half the size of England) and a population of about 600. Thursday island is the administrative centre for four islands (Thursday, Horn, Prince of Wales, and Goods Islands) in the Torres Strait between Australia and Papua New Guinea. I am 69 in a few days and lived in England until I was 47. I hope I am able to help you guys and I am sure I will learn a lot as well. Best regards David Grugeon On 10 June 2012 16:47, vatspoojav...@gmail.com wrote: Hi Excel Buddies! My name is Pooja Sharma, I'm from New Delhi. Working as Lead into Financial Closing and Reporting with a Gurgaon based MNC. Apart from my work, I like to travel, enjoy most forms of music, playing Table Tennis, Gardening. Excel plays major supportive role in accounting and reporting. I am really feel good to be a part of this forum. Regards, Pooja Sharma Sent from BlackBerry® on Airtel From: amar.gur...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 10 Jun 2012 06:38:09 + To: excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Introduce Yourself !! Hi Everyone, I am Amar, an insurance professional working in non-life insurance. I love interacting with people, working in excel and food with different specialities. I am from Mumbai. Regards, Amar Sent on my BlackBerry® from Vodafone From: Rajesh Janardanan rajesh...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 10 Jun 2012 10:31:29 +0400 To: excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Introduce Yourself !! Hello All, I am Rajesh Janardhanan , a Chartered Accountant working in the oil field service industry, aged 34. I live in UAE. interest includes travelling , movies etc and Excel and presentations are a necessity for business for me and this forum has helped me many time's in last many year's. Thanks to all. Best regards Rajesh On Sun, Jun 10, 2012 at 10:27 AM, joseph.cam...@gmail.com wrote: Hi everyone, My name
Re: $$Excel-Macros$$ Date format change by running the macro
Try Sub FormulaToEndOffset1SAS() Dim lr As Long With ActiveCell lr = Cells(.Row, .Column).End(xlDown).Row With Range(Cells(.Row, .Column + 1), Cells(lr, .Column + 1)) .Formula = _ =IF(ISERR(DATE(LEFT(A .Row ,4),MID(A .Row ,5,2), _ RIGHT(A .Row ,2))),,DATE(LEFT(A .Row ,4), _ MID(A .Row ,5,2),RIGHT(A .Row ,2))) .NumberFormat = dd/mmm/ .Value = .Value End With End With End Sub ‘ Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ankur Sent: Tuesday, June 12, 2012 5:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date format change by running the macro hi Experts i use this code to solve the query with slight modification,i want date format in adjacent cell.. i used Macro for this.. But problem is ,this code can run upto specific no. of row i.e 475 i want to be it a dynamic ...i.e it should work with based on selection of range onlylike solution of Krishna Sir is doing..what modification is needed in my codes File is attached for your reference thanks in advance Sub ChgMyFormat() ActiveCell.Offset(0, 1).Range(A1).Select ActiveCell.FormulaR1C1 = _ =IF(ISERR(DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2))),,DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2))) ActiveCell.Select Selection.AutoFill Destination:=ActiveCell.Range(A1:A475) ActiveCell.Range(A1:A475).Select ActiveCell.Columns(A:A).EntireColumn.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats Selection.NumberFormat = dd/mmm/ ActiveCell.Columns(A:A).EntireColumn.EntireColumn.AutoFit ActiveCell.Offset(0, 1).Columns(A:A).EntireColumn.Select Application.CutCopyMode = False ActiveCell.Offset(0, -1).Range(A1).Select End Sub Regards: CMA Ankur Pandey On Tue, Jun 12, 2012 at 2:32 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Thank you Mr.Krish it is exactly what i want. On Tue, Jun 12, 2012 at 2:21 PM, ankur ankurpande...@gmail.com wrote: Hi Ahmed Sorry for this ...Now i had changed the settings.Thanks for correcting me.. Regards: CMA Ankur Pandey On Tue, Jun 12, 2012 at 2:20 PM, ankur ankurpande...@gmail.com wrote: Hi Ahmed Sorry for this ...Now i had changed the settings.Thanks for correcting me.. Regards: CMA Ankur Pandey On Tue, Jun 12, 2012 at 2:11 PM, Ahmed Honest ahmedhon...@gmail.com wrote: Dear Ankur, Please if you don't mind will you make your font sytle and size as a simple Or plain one. It looks too ODD. Thanks for your understanding. Regards, On Tue, Jun 12, 2012 at 11:38 AM, ankur ankurpande...@gmail.com wrote: HI ASHISH I TRIED THIS CODE FOR YOUR SOLUTION ,BUT IT IS NOT SO GOODbecause i dont know how to stop the code after the blank cellsExperts will guide me in this issue how to remove this flawfile is attached for your reference Sub chgDateFormat() ActiveCell.Offset(0, 1).Range(A1).Select ActiveCell.FormulaR1C1 = _ =DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2)) ActiveCell.Select Selection.AutoFill Destination:=ActiveCell.Range(A1:A500) ActiveCell.Range(A1:A1).Select End Sub Regards: CMA Ankur Pandey Visit My Site On Tue, Jun 12, 2012 at 1:04 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear sir, I have data in which date written in 20120412 format and i want to make macro to which transfer the format to 12-Apr-2012 by running the macro on selection range. Please help me in my below code. Sub Macro1() Dim selct As Range selct = Range.Select Range = WorksheetFunction.TEXT(TEXT(selct, -00-00), DD-MMM-) End Sub Thanks regards. Ashish Bhalara 9624111822 -- 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$$ Sheet Requirements
Forgive me but as I recall you have been a part of this group for awhile. If so, you should have learned enough to do this yourself. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Deba Ranjan Sent: Tuesday, June 12, 2012 6:45 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sheet Requirements Dear Experts, i have attached a file which contains many sheets. in every sheets there contains data. i want a button which on clicking the whole sheet data consolidated. Please find the attached. thanks... Thanks Regards, Deba Ranjan P -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Date format change by running the macro
Fully tested on provided file. The lr is the last populated row in column A and was based on the file presented. It is designed so that whatever cell you select in col A then column B ONLY to the lr will be filled with the formula and the formatting. If not, send your file personally to me... Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ankur Sent: Tuesday, June 12, 2012 11:22 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date format change by running the macro Thanks Don Sir Very Nice Code But it is not limited to Selected Rangefull column is converted to desired format... is there any way to limit the code upto selected range only Regards: CMA Ankur Pandey On Tue, Jun 12, 2012 at 6:30 PM, dguillett1 dguille...@gmail.com wrote: Try Sub FormulaToEndOffset1SAS() Dim lr As Long With ActiveCell lr = Cells(.Row, .Column).End(xlDown).Row With Range(Cells(.Row, .Column + 1), Cells(lr, .Column + 1)) .Formula = _ =IF(ISERR(DATE(LEFT(A .Row ,4),MID(A .Row ,5,2), _ RIGHT(A .Row ,2))),,DATE(LEFT(A .Row ,4), _ MID(A .Row ,5,2),RIGHT(A .Row ,2))) .NumberFormat = dd/mmm/ .Value = .Value End With End With End Sub ‘ Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ankur Sent: Tuesday, June 12, 2012 5:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date format change by running the macro hi Experts i use this code to solve the query with slight modification,i want date format in adjacent cell.. i used Macro for this.. But problem is ,this code can run upto specific no. of row i.e 475 i want to be it a dynamic ...i.e it should work with based on selection of range onlylike solution of Krishna Sir is doing..what modification is needed in my codes File is attached for your reference thanks in advance Sub ChgMyFormat() ActiveCell.Offset(0, 1).Range(A1).Select ActiveCell.FormulaR1C1 = _ =IF(ISERR(DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2))),,DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2))) ActiveCell.Select Selection.AutoFill Destination:=ActiveCell.Range(A1:A475) ActiveCell.Range(A1:A475).Select ActiveCell.Columns(A:A).EntireColumn.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats Selection.NumberFormat = dd/mmm/ ActiveCell.Columns(A:A).EntireColumn.EntireColumn.AutoFit ActiveCell.Offset(0, 1).Columns(A:A).EntireColumn.Select Application.CutCopyMode = False ActiveCell.Offset(0, -1).Range(A1).Select End Sub Regards: CMA Ankur Pandey On Tue, Jun 12, 2012 at 2:32 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Thank you Mr.Krish it is exactly what i want. On Tue, Jun 12, 2012 at 2:21 PM, ankur ankurpande...@gmail.com wrote: Hi Ahmed Sorry for this ...Now i had changed the settings.Thanks for correcting me.. Regards: CMA Ankur Pandey On Tue, Jun 12, 2012 at 2:20 PM, ankur ankurpande...@gmail.com wrote: Hi Ahmed Sorry for this ...Now i had changed the settings.Thanks for correcting me.. Regards: CMA Ankur Pandey On Tue, Jun 12, 2012 at 2:11 PM, Ahmed Honest ahmedhon...@gmail.com wrote: Dear Ankur, Please if you don't mind will you make your font sytle and size as a simple Or plain one. It looks too ODD. Thanks for your understanding. Regards, On Tue, Jun 12, 2012 at 11:38 AM, ankur ankurpande...@gmail.com wrote: HI ASHISH I TRIED THIS CODE FOR YOUR SOLUTION ,BUT IT IS NOT SO GOODbecause i dont know how to stop the code after the blank cellsExperts will guide me in this issue how to remove this flawfile is attached for your reference Sub chgDateFormat() ActiveCell.Offset(0, 1).Range(A1).Select ActiveCell.FormulaR1C1 = _ =DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2)) ActiveCell.Select Selection.AutoFill Destination:=ActiveCell.Range(A1:A500) ActiveCell.Range(A1:A1).Select End Sub Regards: CMA Ankur Pandey Visit My Site On Tue, Jun 12, 2012 at 1:04 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear sir, I have data in which date written in 20120412 format and i want to make macro to which transfer the format to 12-Apr-2012 by running the macro on selection range. Please help me in my below code. Sub Macro1() Dim selct As Range selct = Range.Select Range = WorksheetFunction.TEXT(TEXT(selct
Re: $$Excel-Macros$$ Sheet Requirements
sub cs() ‘assumes your master sheet is the FIRST sheet dim I as long for I =2 to sheets.count sheets(i).usedrange.copy sheets(1).cells(rows.count,1).end(xlup)(2) next i end sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Deba Ranjan Sent: Tuesday, June 12, 2012 11:43 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Sheet Requirements Thanks... Thanks Regards, Deba Ranjan P On Tue, Jun 12, 2012 at 9:43 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Dear, It happens with everybody specially when someone tries to learn new concepts of IT or any other topic. So keep going and this group is good to help you. MangeSH On Tue, Jun 12, 2012 at 6:45 PM, Deba Ranjan drdeva...@gmail.com wrote: Thanks. i love excel very much, Actually i keep on trying the coding But really i am so sorry that i really don't have this Idea. i purchased books for VBA macros and Excel, and i am trying my best to do so. Actually i am very new to this concepts (Means VBA coding). And even i am trying to learn from this group as well. I adopted to learn one by one. Let me tell you honestly, i have no system at my home. And what ever i learn, i learnt at Office but that too also i have many few times to learnt myself. So its my drawback. i hope i would able very few things a day, Any way thanks for suggesting that. i will keep trying. i have very confusion in coding when i go trough the books. Like String, long etc. Thanks Regards, Deba Ranjan P On Tue, Jun 12, 2012 at 6:34 PM, dguillett1 dguille...@gmail.com wrote: Forgive me but as I recall you have been a part of this group for awhile. If so, you should have learned enough to do this yourself. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Deba Ranjan Sent: Tuesday, June 12, 2012 6:45 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sheet Requirements Dear Experts, i have attached a file which contains many sheets. in every sheets there contains data. i want a button which on clicking the whole sheet data consolidated. Please find the attached. thanks... Thanks Regards, Deba Ranjan P -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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
Re: $$Excel-Macros$$ What tools are most suitable to populate existing database with this tools?
Provide a file with complete explanation. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: alvin567 Sent: Wednesday, June 13, 2012 4:02 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ What tools are most suitable to populate existing database with this tools? Due to certain requirements, we need to be able to populate a relational database with our portfolio data. From this we would like to extract certain reports that provide us with insight about the credit performance of the individual positions within the portfolio. -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ No. of years and months
Which months in the 200? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ahmed Honest Sent: Wednesday, June 13, 2012 7:56 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ No. of years and months Hi Experts, Based on a given number I need the result to be something like below: Given Number : 200 Answer should be 16 Years 8 Months. Is there any way of doing it in Ms Excel by Formula? Thanks, Ahmed Bawazir -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ No. of years and months
A look in the help index for INT may be of use to you Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ahmed Honest Sent: Wednesday, June 13, 2012 8:49 AM To: excel-macros@googlegroups.com ; talk2mar...@gmail.com Subject: Re: $$Excel-Macros$$ No. of years and months Hi Maries, Can you explain me what is this A1-INT(A1/12)*12 does, I mean the math side explanation. Please explain and Tons of thanks for your solution, it's working as I need. Regards Ahmed Bawazir On Wed, Jun 13, 2012 at 4:02 PM, Maries talk2mar...@gmail.com wrote: HI, Assume data entries in A1, Try below formula, =INT(A1/12) Years A1-INT(A1/12)*12 Months On Wed, Jun 13, 2012 at 5:56 AM, Ahmed Honest ahmedhon...@gmail.com wrote: Hi Experts, Based on a given number I need the result to be something like below: Given Number : 200 Answer should be 16 Years 8 Months. Is there any way of doing it in Ms Excel by Formula? Thanks, Ahmed Bawazir -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- MARIES Excel Inspiration -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- Ahmed Bawazir احمد باوزير -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to
Re: $$Excel-Macros$$ vba - run time error 9 out of range
I would have done it differently but add an on error And, do you really want to do this with each calculation??. I don’t think so... 'On Error Resume Next For Each c In rng Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: cardak Sent: Wednesday, June 13, 2012 2:20 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ vba - run time error 9 out of range hi all, im new to VBA and trying run below, when i run the code excel throws run time 9 error message, can you please help on this error Thanks Private Sub Worksheet_Calculate() Dim rng As Range, c As Range Dim ws As Worksheet Dim lastRow As Long Dim x As Variant Set ws = Worksheets(Component List) lastRow = ws.Cells(ws.Cells.Rows.Count, 1).End(xlUp).Row Set rng = ws.Range(A5:A lastRow) For Each c In rng For i = 1 To Sheets.Count If c.Offset(0, 1).Value = Yes And Trim(c.Value) = Sheets(i).Name Then Sheets(Trim(c.Value)).Visible = xlSheetVisible Else Sheets(Trim(c.Value)).Visible = xlSheetHidden End If Next i Next c End Sub -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Condensing Multiple Worksheets Into One ...
Use this without having to use selections Option Explicit Sub CombineSheetsSAS() Dim i As Long Sheets.Add before:=Sheets(1) ActiveSheet.Name = Combined Sheets(2).Rows(1).Copy Range(a1) For i = 2 To Sheets.Count Sheets(i).UsedRange.Offset(1).Copy Cells(Rows.Count, 1).End(xlUp)(2) Next i End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: R Swarup Sent: Friday, June 15, 2012 9:23 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Condensing Multiple Worksheets Into One ... Dear Customer, You have consumed 100% of your total quota allotted on Reliance Netconnect+. Now speed will be up to 144Kbps till next bill cycle. On Jun 7, 2012 1:22 AM, Greg gamoun...@gmail.com wrote: Hello, I am Hello, I am trying to process an Excel macro I found online from the following weblink: http://excel.tips.net/T003005_Condensing_Multiple_Worksheets_Into_One.html Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add ' add a sheet in first place Sheets(1).Name = Combined ' copy headings Sheets(2).Activate Range(A1).EntireRow.Select Selection.Copy Destination:=Sheets(1).Range(A1) ' work through sheets For J = 2 To Sheets.Count ' from sheet 2 to last sheet Sheets(J).Activate ' make the sheet active Range(A1).Select Selection.CurrentRegion.Select ' select all cells in this sheets ' select all lines except title Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select ' copy cells selected in the new sheet on last line Selection.Copy Destination:=Sheets(1).Range(A65536).End(xlUp)(2) Next End SubAccording to the description, I can either use the Excel Consolidate tool or the above macro. Unfortunately, I didn't have much luck with the Consolidate tool because I don't understand how to reference each of the worksheet ranges. Once I run the macro, it appears to be doing something because I can see it trans-versing through each worksheet. When the macro has completed, the first sheet in the workbook is not named Combined, and it contains no data from the other worksheets. Thanks in advance for any assistance you can provide. Kind regards, Greg -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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.
Re: $$Excel-Macros$$ Re: change content of cell across multiple worksheets
Provide a file and a complete explanation. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: David Grugeon Sent: Saturday, June 16, 2012 2:32 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: change content of cell across multiple worksheets Hi Jeanette Ah! I expect we have some sort of misunderstanding. Are the sheets concerned actually called A to Z. If not we may have to change the macro to run on selected sheets. Also is the information you are looking for actually in column O? How is the information formatted? Is it as text or as a number? Do you realise that the macro leaves the found(old) information as it was and puts the new information into Column S on the same row. If you feel you want to send your workbook to me (david at grugeon dot com dot au) I will see what the problem is but it is entirely up to you if you want to do this as I understand it may have confidential information which you would not feel like giving to a stranger. Best regards David Grugeon On 16 June 2012 16:55, JLO jeanette_lovel...@btinternet.com wrote: Hi David Thank you very much for your quick response! I have copied your code into my module and run it a few times, but nothing happens (apart from the loop bit doesn't go crazy like mine did!). I selected worksheets A to Z and did a FindAll afterwards to check the result, but none of the data has changed. Please revisit the code you very kindly provided, because I haven't got a clue whether or not there is anything vital missing!!! Thanks for your help and such quick response. On Saturday, June 16, 2012 1:18:41 AM UTC+1, JLO wrote: Could really use some help with this. I have worksheets A to Z. I'm searching for data the user has entered via an input box, then changing the data in cells over to the right with the data the user enters via another input box. This works perfectly on active sheet. What I need is for the exact same thing to happen across worksheets A to Z (there being further worksheets that don't get changed), so some sort of loop is needed. I've tried looping, but with disastrous results!! I'd really appreciate a solution - I cribbed the example from elsewhere and tailored it, but I'm stumped to get it to work across the other sheets. Thanks in advance for all your help! Here's my code: With ActiveSheet.Range(O:O) Dim mySearch As String Dim myReplaceValue mySearch = InputBox(Enter the Box Number requiring relocation: ) myReplaceValue = InputBox(What is the new location? ) Set c = .Find(mySearch, LookIn:=xlValues) If Not c Is Nothing Then firstaddress = c.Address Do c.Offset(, 4) = myReplaceValue Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address firstaddress End If End With -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- David Grugeon -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor
Re: $$Excel-Macros$$ Find Narrow Cells Appying Auto fit to only that cell
or ActiveSheet.UsedRange.Columns.AutoFit Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Saturday, June 16, 2012 6:09 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Find Narrow Cells Appying Auto fit to only that cell ActiveSheet.usedrange.entirecolumn.autofit Sam Mathai Chacko On Sat, Jun 16, 2012 at 4:28 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Select the Column and press ALT + O C A Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prashant Pawle Sent: 16 June 2012 1:40 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Find Narrow Cells Appying Auto fit to only that cell Dear Team, Please help of some macro to find Narrow Cells Appying Auto fit to only that cell , sample sheet attached Regards, Prashant -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Find Narrow Cells Appying Auto fit to only that cell
Sam, yours and mine both test OK Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Saturday, June 16, 2012 9:11 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Find Narrow Cells Appying Auto fit to only that cell Should be EntireColumns as I had posted Regards, Sam Mathai Chacko On Sat, Jun 16, 2012 at 7:29 PM, dguillett1 dguille...@gmail.com wrote: or ActiveSheet.UsedRange.Columns.AutoFit Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Saturday, June 16, 2012 6:09 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Find Narrow Cells Appying Auto fit to only that cell ActiveSheet.usedrange.entirecolumn.autofit Sam Mathai Chacko On Sat, Jun 16, 2012 at 4:28 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Select the Column and press ALT + O C A Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prashant Pawle Sent: 16 June 2012 1:40 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Find Narrow Cells Appying Auto fit to only that cell Dear Team, Please help of some macro to find Narrow Cells Appying Auto fit to only that cell , sample sheet attached Regards, Prashant -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@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
Re: $$Excel-Macros$$ Need help!!! MACRO
Try Sub FooterSAS() selectcase InputBox(Enter 1=Confidental, 2=For Internal Use Only 3=Other) Case Is = 1: x = Confidental Case Is = 2: x = For Internal Use Only Case Is = 3: x = Restricted Case Else End Select For Each wk In Application.Workbooks For Each sh In wk.Worksheets 'wk.Sheets(i).Select sh.PageSetup.CenterFooter = x Next Next MsgBox strResponse footer has been successfully added. End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: jonnie...@gmail.com Sent: Monday, June 18, 2012 4:10 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help!!! MACRO Hi All, I need help with macros. Attached (Macro for Footer) is the existing file with macros for labeling an excel sheet, It asks for Yes or no for label the sheet as Confidential or Internal Use Only. I need your help to include 1 more category Restricted. I tried to do some changes to the vb coding (Macros 2), but couldn’t do it correctly. Best Regards Jones Pulikotil Sent on my BlackBerry® from Vodafone -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Need help!!! MACRO
OOPS Put a space between select and case selectcase select case Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: jonnie...@gmail.com Sent: Monday, June 18, 2012 4:10 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help!!! MACRO Hi All, I need help with macros. Attached (Macro for Footer) is the existing file with macros for labeling an excel sheet, It asks for Yes or no for label the sheet as Confidential or Internal Use Only. I need your help to include 1 more category Restricted. I tried to do some changes to the vb coding (Macros 2), but couldn’t do it correctly. Best Regards Jones Pulikotil Sent on my BlackBerry® from Vodafone -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required
http://oreilly.com/pub/h/2607 Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Avinash Sent: Monday, June 18, 2012 10:20 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required Hi Rajan, Thanks for your help but can u please tell me how can i use this progress bar in to my existing code i mean it is loading directly towards the end but i want it should run like when my first step gets completed it should say 10 % complete and till 10 step it should say 100% completed. it should not complete before any step finished it should load as per the step are getting completed. Regards, Avinash On Monday, June 18, 2012 6:29:01 PM UTC+5:30, Rajan_Verma wrote: See the attached file Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Avinash Sent: 18 June 2012 2:35 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required Thanks Manoj for you help. But i want progress bar macro formatting macro i already have i have mentioned sample macro code not my actual code. Regards, Avinash On Monday, June 18, 2012 11:05:34 AM UTC+5:30, Manoj Kumar wrote: Dear Avinash. Sub gg() For a = 1 To Sheets.Count Sheets(a).Activate Range(a1:dd5).Select Selection.Font.Bold = True Next End Sub Regard Manoj On Sun, Jun 17, 2012 at 11:39 PM, Avinash avinash007pa...@gmail.com wrote: Dear Experts, I have 1 workbook and there are 10 subsheets in that workbook. i have created 1 macro to format those 10 subsheets. every sheet does have different formatting e.g. sheet 1 bold text for row 1 and and sheet 2 bold italic text for row 2. so now i want macro to show the progress bar (progress bar should be VBA USERFORM ) in % which shows me how much formatting is completed like after sheet 1 formatting progress bar should show 10% completed after sheet 2 it should show 20% and after all formatting done it should say 100% with how much time taken for formatting all thease sheets. Please help me in this as i want to incorporate the same type of macro in other projects. My macro style Sub Formatting () Step1 format sheet 1 Step2 format sheet 2 Step3 format sheet 3 Step4 format sheet 4 Step5 format sheet 5 Step6 format sheet 6 Step7 format sheet 7 Step7 format sheet 7 Step8 format sheet 8 Step9 format sheet 9 Step10 format sheet 10 End Sub -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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