Re: $$Excel-Macros$$ Re: Invitation to the Excel Modeling World Championships 2014
Dear Saleem, Find attached excel created by me already shared in group. This is the same attaching for your ready ref. I've used only only formulas to convert digit into words. With Regards, Suyog On Sunday, 7 September 2014 09:23:40 UTC+5:30, Saleem Ansari wrote: Dear , Only For Excel Formula, Please Convert Number TO Word only for Excel Formula, Ok Please Reply Fast Thanks Regards? ** *Saleem Ansari* *Logicash Solutions Pvt. Ltd.* *A-79| Sector-4| Noida| Gautam Budh Nagar (U.P) 201301* *Email Id :-* *saleem@gmail.com javascript:* *Mobile : - +91 7840096219* The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or committed to be taken in reliance on it, is prohibited and may be unlawful. Please consider the environment before printing this e-mail *पेड़ बचाएँ* *पर्यावरण बचाएँ* [image: Description: cid:image003.gif@01CCD1FE.E699F6D0]*Go Green, Save Earth**?* *[image: Untitled]* On Sun, Sep 7, 2014 at 6:16 AM, NOORAIN ANSARI noorain...@gmail.com javascript: wrote: Dear Saleem, Please find the attachment. hope it will help to you. now you can convert number to word by excel formula or vba UDF. On Sat, Sep 6, 2014 at 12:01 PM, Saleem Ansari saleem@gmail.com javascript: wrote: Dear Noorain SIr, Please Help, My Query ho to convert number to word Please Help Sir,, On Saturday, August 30, 2014 7:18:44 PM UTC+5:30, Ayush Jain wrote: Dear members, We’d like to invite members of the discussexcel.com community to the annual Excel and Financial Modeling World Championship 2014 Event (*ModelOff, www.modeloff.com http://www.modeloff.com*). The Advanced Excel educational competition helps celebrate Excel in Financial Services. The fun, challenging and innovative competition has a mission to inspire skill development with Microsoft Excel, Financial Modeling and Financial Analysis which is central to global businesses and communities. The competition showcases some of the fastest, hard-working and talented Excel minds from 100+ countries. Round 1 starts on 25th October 2014 (8 weeks away) *Summary of Event* Over 3,000 participants competed in the ModelOff 2013 event. Major Global Partners and Sponsors are: Microsoft, Intralinks, SP Capital IQ, Kaplan Education, Bloomberg, AMT Training, Corality and Ernst Young. Participants come from diverse companies and jobs – such as Analysts, Associates and Managers at Investment Firms and Accounting Firms, CFOs, Analytics Professionals, In-House Excel Gurus and Consultants with a shared passion for Microsoft Excel and Finance. Students comprise ~35% of all entrants worldwide – most studying Commerce, Accounting, Finance and Masters university qualifications. The countries most represented have typically been: United States, UK, Poland, Russia, Canada, Australia, India and Hong Kong. Female participation is ~20% of all competitors - hopefully higher this year (the reigning champion is Hilary Smart 26yo from London). *How It Works* The ModelOff competition involves two online qualification rounds (2 hours each) conducted simultaneously around the world. The Top 16 performers are flown to New York for the Live Finals at the offices of Microsoft and Bloomberg in early December 2014. Questions are mostly case study and multiple choice format – with some ranging from a basic understanding of discounted cash flow (DCF) analysis, 3-way integrated cash flow models to more complex project finance and simulation techniques. Some basic Accounting, Finance and Excel knowledge is likely needed to progress to Round 2. *Free Training and Preparation* All past questions and tests from ModelOff 2012 and 2013 are free and available on the ModelOff website. The organizers believe in accessible excellence and this can be a great starting point for anyone looking to become involved for the first time and improve their Advanced Excel skills in Financial Services and Financial Modeling. We actively encourage all participants to visit all our community partners, bloggers, our major global sponsors during and following the event for their own learning, mentoring and professional development. Competitors in the Top 10% of ModelOff 2014 will be eligible for exciting local and international opportunities, offers from community partners and fun learning experiences (e.g. Trips to Microsoft Excel in Redmond). We're also hosting free networking events in major Financial Centres including Hong Kong, London, Sydney, New York and Regional Meetups in the coming months for anyone interested in networking and mentoring with Excel-users in their local cities. Entry to the
$$Excel-Macros$$ How to share Code/Macro ?
Hello All, Kindly refer attached file, I've created macro but I want to share this macro to other users. Following are my difficulties. 1. How can I secure the code ? Kindly add password 12345 for this file. 2. To run the code I need to keep this file open but which I don't want normal user to do ? This macro should run automatically on any pc. 3. Can I add Any additional button which would be appear along with the exiting toolbar of excel ? so that normal use will only click that button without headache ? Kindly advice me. With Regards, Suyog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Rw.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Re: Question on My Menu !!
Ashish Sir, In My menu - Select Range Can you please add Select non-blank option. Actually I've posted a question on repetitive formatting I'm not getting any reply. If I've that option in My Menu probably I could have asked the same. Attached is the excel which I've shared with group members. Kindly help me to solve this issue. With Regards, Suyog On Sunday, 28 October 2012 13:10:35 UTC+5:30, Suyog Kulkarni wrote: Hello All, I'm using Ashish Sir's My Menu ver 1.6 very frequently that increased my working speed in excel. I'm really thankful for same. Please refer attached my question regarding insert option of my menu. Please advice on my question. With Best Regards, Suyog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Steps for Good look.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code
Hello All, I made my first macro code. Kindly review. Now only problem remain is instead of *Range(A1:I100), I want excel to choose last row last column which contain text/value.* PL help. Regards, Suyog Below is my code *Sub Format()* ' Format Macro ' Keyboard Shortcut: Ctrl+q ' This is range for Report Headings Range(A1:I4).Select Selection.ClearContents With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Selection.Merge ' This is range for Report Header Line Range(A5:I5).Select With Selection.Interior .Color = 13434879 Selection.Font.Bold = True End With ' This is total non blank area of any report. Or Cell range with Text/value *Range(A1:I100).Select* With Selection.Borders .LineStyle = xlContinuous .Weight = xlThin End With Cells.Select With Selection.Interior Selection.Font.Name = Calibri Selection.Font.Size = 11 Selection.Font.ThemeFont = xlThemeFontMinor End With Cells.Select Selection.Columns.AutoFit With Selection .VerticalAlignment = xlCenter .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Range(A5).Select ActiveWorkbook.Save MsgBox Formatting is done. Only add project details properly., vbOKOnly, Made by Suyog Kulkarni *End Sub* On Friday, 4 April 2014 15:11:52 UTC+5:30, Suyog Kulkarni wrote: Hello All, Refer attached excel, I've tried to develop macro using recording for repetitive formatting. Now my problem is how can I assign range for all Non-blank cell. Because my current will work only upto Row 13 Column I. How can assign the code which can work till last row column which contain text / value. Short cut for macro is Ctrl+q. I need this to improve productivity you all can save my lot of time. I generate daily more than 50 reports of 100+ rows. This formatting takes time. Regards, Suyog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code
Hello All, I made my first macro code. Kindly review. Now only problem remain is instead of *Range(A1:I100), I want excel to choose last row last column which contain text/value.* PL help. Regards, Suyog Below is my code *Sub Format()* ' Format Macro ' Keyboard Shortcut: Ctrl+q ' This is range for Report Headings Range(A1:I4).Select Selection.ClearContents With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Selection.Merge ' This is range for Report Header Line Range(A5:I5).Select With Selection.Interior .Color = 13434879 Selection.Font.Bold = True End With ' This is total non blank area of any report. Or Cell range with Text/value *Range(A1:I100).Select* With Selection.Borders .LineStyle = xlContinuous .Weight = xlThin End With Cells.Select With Selection.Interior Selection.Font.Name = Calibri Selection.Font.Size = 11 Selection.Font.ThemeFont = xlThemeFontMinor End With Cells.Select Selection.Columns.AutoFit With Selection .VerticalAlignment = xlCenter .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Range(A5).Select ActiveWorkbook.Save MsgBox Formatting is done. Only add project details properly., vbOKOnly, Made by Suyog Kulkarni *End Sub* On Friday, 4 April 2014 15:11:52 UTC+5:30, Suyog Kulkarni wrote: Hello All, Refer attached excel, I've tried to develop macro using recording for repetitive formatting. Now my problem is how can I assign range for all Non-blank cell. Because my current will work only upto Row 13 Column I. How can assign the code which can work till last row column which contain text / value. Short cut for macro is Ctrl+q. I need this to improve productivity you all can save my lot of time. I generate daily more than 50 reports of 100+ rows. This formatting takes time. Regards, Suyog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code
Hi Basole, It's working fine now following are the only problems remaining. 1. While creating macro, I have assigned ctrl+q shortcut which is not working now 2. How can we save the code as Add In or can we add any buttom in existing toolbar ? so I that I can share the same with my co-workers. I can't see, save as option in vba window. Pl help. Thanks to all group members, because of you all I made this code. With Regards, Suyog *Below is the modified code. * Sub ReportWriter() ' Format Macro ' ' Keyboard Shortcut: Ctrl+q ' ' This lines are two fill white color Cells.Select With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .ThemeColor = xlThemeColorDark1 .TintAndShade = 0 .PatternTintAndShade = 0 End With ' This is range for Report Headings Range(A1:I4).Select Selection.ClearContents With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Selection.Merge ' This is range for Report Header Line Range(A5:I5).Select With Selection.Interior .Color = 13434879 Selection.Font.Bold = True End With ' This is total non blank area of any report. Or Cell range with Text/value x = Cells(Rows.Count, A).End(xlUp).Row y = Cells(x, Columns.Count).End(xlToLeft).Column Range(A1: Cells(x, y).Address).Select With Selection.Borders .LineStyle = xlContinuous .Weight = xlThin End With Cells.Select With Selection.Interior Selection.Font.Name = Calibri Selection.Font.Size = 11 Selection.Font.ThemeFont = xlThemeFontMinor End With Cells.Select Selection.Columns.AutoFit With Selection .VerticalAlignment = xlCenter .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Range(A5).Select ActiveWorkbook.Save MsgBox Formatting is done. Only add project details properly., vbOKOnly, Code by Suyog Kulkarni End Sub On Saturday, 5 April 2014 02:32:12 UTC+5:30, Basole wrote: Hi, try this: x = Cells(Rows.Count, A).End(xlUp).Row y = Cells(x, Columns.Count).End(xlToLeft).Column Range(A1: Cells(x, y).Address).Select Regards, Basole. 2014-04-04 11:17 GMT-03:00 Suyog Kulkarni nash...@gmail.com javascript: : Hello All, I made my first macro code. Kindly review. Now only problem remain is instead of *Range(A1:I100), I want excel to choose last row last column which contain text/value.* PL help. Regards, Suyog Below is my code *Sub Format()* ' Format Macro ' Keyboard Shortcut: Ctrl+q ' This is range for Report Headings Range(A1:I4).Select Selection.ClearContents With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Selection.Merge ' This is range for Report Header Line Range(A5:I5).Select With Selection.Interior .Color = 13434879 Selection.Font.Bold = True End With ' This is total non blank area of any report. Or Cell range with Text/value *Range(A1:I100).Select* With Selection.Borders .LineStyle = xlContinuous .Weight = xlThin End With Cells.Select With Selection.Interior Selection.Font.Name = Calibri Selection.Font.Size = 11 Selection.Font.ThemeFont = xlThemeFontMinor End With Cells.Select Selection.Columns.AutoFit With Selection .VerticalAlignment = xlCenter .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Range(A5).Select ActiveWorkbook.Save MsgBox Formatting is done. Only add project details properly., vbOKOnly, Made by Suyog Kulkarni *End Sub* On Friday, 4 April 2014 15:11:52 UTC+5:30, Suyog Kulkarni wrote: Hello All, Refer attached excel, I've tried to develop macro using recording for repetitive formatting. Now my problem is how can I assign range for all Non-blank cell. Because my current will work only upto Row 13 Column I. How can assign the code which can work till last row column which contain text / value. Short cut for macro is Ctrl+q. I need this to improve productivity you all can save my lot of time. I generate daily more than 50 reports of 100+ rows. This formatting takes time. Regards, Suyog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention
Re: $$Excel-Macros$$ Need macro for repetative formatting
Hello Ravinder, Pl refer attached excel which contains all steps also refer two sheet. One with original software output other is required format I'm requesting all to look into this kindly help me. With Regards, *Suyog* On Wednesday, 2 April 2014 15:17:01 UTC+5:30, ravinder negi wrote: Provid any data and your 10 steps which u want to do after download data from software *From:* excel-...@googlegroups.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *Suyog Kulkarni *Sent:* Tuesday, April 01, 2014 7:18 PM *To:* excel-...@googlegroups.com javascript: *Subject:* Re: $$Excel-Macros$$ Need macro for repetative formatting Hello All, Pl advice on mail below. Am I asking something very difficult ? If anybody can help that can save my lots of time. Pl do the needful. Regards, Suyog On Tuesday, 25 March 2014 11:59:37 UTC+5:30, Suyog Kulkarni wrote: Hello Vicky, I'm not at all coping data from any where otherwise I would have used the paste special. I'm pulling data from software which some times finish within 10 rows 10 columns sometimes it's cross 30 columns 100 plus rows. If somehow I want to tell excel that follow my 10 steps upto last row last column which is having text. It may be row 10 column 10 or row 85 or column 60 or anything. Sometimes it's come so hectic to just waste time on formatting only. Pl help solve this problem. With Regards, Suyog On Tuesday, 25 March 2014 01:49:38 UTC+5:30, Vicky wrote: Hi Suyog, My understanding is you would like to have same format for all data so my logic is rather formating each line of data I have saved your format in Format tab in attached sheet and then that format will be applied to your copied data in Original Sheet. Same as we do in Excel using *Paste special + Paste+Formats.* Hope this makes sense. Regards, On Mon, Mar 24, 2014 at 7:29 PM, Suyog Kulkarni nash...@gmail.com wrote: Hello All, Greetings for the day. Pl refer attached excel, I'm using one database software when I pull out different reports from that I need to do 10 steps for each report every time. I've tried to record macro also but I don't know how to find out last cell which contains text sometimes report may finish in F column 30th row or sometimes it cross P column 150th row. Refer attached excel, I've added my steps, sample of original report sample of expected report. If I got answer of this, this will increase my productivity can save lots of time. With Regards, Suyog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel
Re: $$Excel-Macros$$ Need macro for repetative formatting
Hello All, Pl advice on mail below. Am I asking something very difficult ? If anybody can help that can save my lots of time. Pl do the needful. Regards, Suyog On Tuesday, 25 March 2014 11:59:37 UTC+5:30, Suyog Kulkarni wrote: Hello Vicky, I'm not at all coping data from any where otherwise I would have used the paste special. I'm pulling data from software which some times finish within 10 rows 10 columns sometimes it's cross 30 columns 100 plus rows. If somehow I want to tell excel that follow my 10 steps upto last row last column which is having text. It may be row 10 column 10 or row 85 or column 60 or anything. Sometimes it's come so hectic to just waste time on formatting only. Pl help solve this problem. With Regards, Suyog On Tuesday, 25 March 2014 01:49:38 UTC+5:30, Vicky wrote: Hi Suyog, My understanding is you would like to have same format for all data so my logic is rather formating each line of data I have saved your format in Format tab in attached sheet and then that format will be applied to your copied data in Original Sheet. Same as we do in Excel using *Paste special + Paste+Formats.* Hope this makes sense. Regards, On Mon, Mar 24, 2014 at 7:29 PM, Suyog Kulkarni nash...@gmail.comwrote: Hello All, Greetings for the day. Pl refer attached excel, I'm using one database software when I pull out different reports from that I need to do 10 steps for each report every time. I've tried to record macro also but I don't know how to find out last cell which contains text sometimes report may finish in F column 30th row or sometimes it cross P column 150th row. Refer attached excel, I've added my steps, sample of original report sample of expected report. If I got answer of this, this will increase my productivity can save lots of time. With Regards, Suyog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Need macro for repetative formatting
Hello All, Pl help try to solve my problem. Regards, Suyog On Tuesday, 25 March 2014 11:59:37 UTC+5:30, Suyog Kulkarni wrote: Hello Vicky, I'm not at all coping data from any where otherwise I would have used the paste special. I'm pulling data from software which some times finish within 10 rows 10 columns sometimes it's cross 30 columns 100 plus rows. If somehow I want to tell excel that follow my 10 steps upto last row last column which is having text. It may be row 10 column 10 or row 85 or column 60 or anything. Sometimes it's come so hectic to just waste time on formatting only. Pl help solve this problem. With Regards, Suyog On Tuesday, 25 March 2014 01:49:38 UTC+5:30, Vicky wrote: Hi Suyog, My understanding is you would like to have same format for all data so my logic is rather formating each line of data I have saved your format in Format tab in attached sheet and then that format will be applied to your copied data in Original Sheet. Same as we do in Excel using *Paste special + Paste+Formats.* Hope this makes sense. Regards, On Mon, Mar 24, 2014 at 7:29 PM, Suyog Kulkarni nash...@gmail.comwrote: Hello All, Greetings for the day. Pl refer attached excel, I'm using one database software when I pull out different reports from that I need to do 10 steps for each report every time. I've tried to record macro also but I don't know how to find out last cell which contains text sometimes report may finish in F column 30th row or sometimes it cross P column 150th row. Refer attached excel, I've added my steps, sample of original report sample of expected report. If I got answer of this, this will increase my productivity can save lots of time. With Regards, Suyog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Need macro for repetative formatting
Hello Vicky, I'm not at all coping data from any where otherwise I would have used the paste special. I'm pulling data from software which some times finish within 10 rows 10 columns sometimes it's cross 30 columns 100 plus rows. If somehow I want to tell excel that follow my 10 steps upto last row last column which is having text. It may be row 10 column 10 or row 85 or column 60 or anything. Sometimes it's come so hectic to just waste time on formatting only. Pl help solve this problem. With Regards, Suyog On Tuesday, 25 March 2014 01:49:38 UTC+5:30, Vicky wrote: Hi Suyog, My understanding is you would like to have same format for all data so my logic is rather formating each line of data I have saved your format in Format tab in attached sheet and then that format will be applied to your copied data in Original Sheet. Same as we do in Excel using *Paste special + Paste+Formats.* Hope this makes sense. Regards, On Mon, Mar 24, 2014 at 7:29 PM, Suyog Kulkarni nash...@gmail.comjavascript: wrote: Hello All, Greetings for the day. Pl refer attached excel, I'm using one database software when I pull out different reports from that I need to do 10 steps for each report every time. I've tried to record macro also but I don't know how to find out last cell which contains text sometimes report may finish in F column 30th row or sometimes it cross P column 150th row. Refer attached excel, I've added my steps, sample of original report sample of expected report. If I got answer of this, this will increase my productivity can save lots of time. With Regards, Suyog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Need macro for repetative formatting
Hello All, Greetings for the day. Pl refer attached excel, I'm using one database software when I pull out different reports from that I need to do 10 steps for each report every time. I've tried to record macro also but I don't know how to find out last cell which contains text sometimes report may finish in F column 30th row or sometimes it cross P column 150th row. Refer attached excel, I've added my steps, sample of original report sample of expected report. If I got answer of this, this will increase my productivity can save lots of time. With Regards, Suyog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Sample Excel.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Need help in modification of Cell range !
Dear All, Kindly review attached macro which I've developed by recording. The problem is while recording, I've consider that there would be only 100 rows but now I'm pulling data from another engineering software which is crossing that defined range. This macro is just adjusting the formatting nothing else. My questions are follows ? 1) How to define properly so that macro will automatically adjust the formatting till last line of text. Means whether last row is may 100, 200 or 500. ? 2) Should I need to copy this macro enabled excel in the C:\Program Files\Microsoft Office\Office12\XLSTART folder ? Kindly help me. Regards, *Suyog* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Take off Macro.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ how to make a file expire after a period of time.
Hello All, I've reviewed all replies. Can we do following things ? After opening excel, Sheet1 only should get open ! On sheet1, we can write that Without Enabling macro facility this excel will not work. Can we prepare macro which will keep all fonts cells in white color ? I can't say, we'll keep those sheets hidden as anyone can unhide those sheets. If we can achieve this, that will be great. Regards, Suyog On Monday, 5 August 2013 11:41:55 UTC+5:30, pappu wrote: Hi Umar Abeer, Its very simple if ur company want to terminate u, then u can use this macro in master data :-) am just joking... I thought this would be a great security feature for an annual subscription feature I have on my site. Ideally the spreadsheet would lock or a password would be required after a certain date On Sat, Aug 3, 2013 at 7:43 PM, Umar Abeer umar...@googlemail.comjavascript: wrote: Hi Kannan Interesting query. Would you share why you want an expiry on the file. Just trying to understand the circumstances under which one might want to add the funcitonality Cheers Umar On Mon, Jul 29, 2013 at 12:37 PM, Kannan Excel kannan...@gmail.comjavascript: wrote: how to make this??? can u send code??? and if i type user and pswd means, permission granted or user has expired message only appear... excel sheet not open... On Mon, Jul 29, 2013 at 1:16 PM, De Premor d...@premor.netjavascript: wrote: try this attached file user, pass, and expiration date defined in a sheet On 29/07/2013 13:05, Mangesh Vimay wrote: Thanks for asking this query. Appreciate your mind !!! And also thanks De Pemor for the solution. Have a great day all !!! On 7/29/13, Kannan Excel kannan...@gmail.com javascript: wrote: Hi, I want to set particular date and* time* also for expire is this possible.??? Or i want to set date and time for password... When i set date and time, password will appear automatically pls do the needful ASAP... On Sat, Jul 27, 2013 at 3:19 PM, De Premor d...@premor.netjavascript: wrote: Using macro, but required user to run the macro This is the basic, user still can skip this by changing date on his computer Private Sub Workbook_Open() Dim Expired As Date Expired = 20 Jul 2013 If Now() Expired Then MsgBox File ThisWorkbook.FullName expired ThisWorkbook.Close End If End Sub Next step, you may add a cell validation on current file to avoid skipped by user with changin the date on his computer Once the expiration msg appear, it will write in sheet1 cell A1 a word EXPIRED, then everytime file open, it will check that cell and also the date on current computer, if one of that criteria match then it will still close the workbook. If Now() Expired or *Sheet1**.Range(**A1) = EXPIRED* Then MsgBox File ThisWorkbook.FullName expired *if Sheet1**.Range(**A1) EXPIRED then ** Sheet1.Range(A1) = EXPIRED** * *ThisWorkbook.Save End If * ThisWorkbook.Close End If Rgds, [dp] Pada 27/07/2013 15:55, Kannan Excel menulis: Hi, how to make a file expire after a period of time. regards Kannan V -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@**googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/**group/excel-macroshttp://groups.google.com/group/excel-macros . For more options, visit https://groups.google.com/**groups/opt_outhttps://groups.google.com/groups/opt_out . -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor
Re: $$Excel-Macros$$ how to make a file expire after a period of time.
Hello All, I've some questions on this. What if we set expiry date time but macros are disabled on any PC ? whether that person can open this file ? Kindly review attached excel, I added similar code but while opening that file, excel first open that particular file then ask me to enable macro. After enabling macro also, I can work I can make changes in this file. Kindly refer attached file guide me. This is very useful technique for me as we generally quote with the validity so now I can validate the whole excel only. I would like to set my date time as expiry I'll set password to that macro. Thanks in advance. With best regards, Suyog On Monday, 29 July 2013 14:17:14 UTC+5:30, De Premor wrote: This is the sample code, you can set it up in ExpDate variable Private Sub Workbook_Open() Dim ExpDate As Date ExpDate = #8/17/2013 10:00:00 AM# If Now ExpDate Then ThisWorkbook.Close MsgBox This workbook will expired at Format(ExpDate, dd hh:mm:ss AM/PM) End Sub Rgds, [dp] On 29/07/2013 15:39, Kannan Excel wrote: can u do me a favor??? i don't want user and pswd... i want vb coding for expire date and time pls send that code how to set date and time to expire On Mon, Jul 29, 2013 at 1:16 PM, De Premor d...@premor.net javascript:wrote: try this attached file user, pass, and expiration date defined in a sheet On 29/07/2013 13:05, Mangesh Vimay wrote: Thanks for asking this query. Appreciate your mind !!! And also thanks De Pemor for the solution. Have a great day all !!! On 7/29/13, Kannan Excel kannan...@gmail.com javascript: wrote: Hi, I want to set particular date and* time* also for expire is this possible.??? Or i want to set date and time for password... When i set date and time, password will appear automatically pls do the needful ASAP... On Sat, Jul 27, 2013 at 3:19 PM, De Premor d...@premor.netjavascript: wrote: Using macro, but required user to run the macro This is the basic, user still can skip this by changing date on his computer Private Sub Workbook_Open() Dim Expired As Date Expired = 20 Jul 2013 If Now() Expired Then MsgBox File ThisWorkbook.FullName expired ThisWorkbook.Close End If End Sub Next step, you may add a cell validation on current file to avoid skipped by user with changin the date on his computer Once the expiration msg appear, it will write in sheet1 cell A1 a word EXPIRED, then everytime file open, it will check that cell and also the date on current computer, if one of that criteria match then it will still close the workbook. If Now() Expired or *Sheet1**.Range(**A1) = EXPIRED* Then MsgBox File ThisWorkbook.FullName expired *if Sheet1**.Range(**A1) EXPIRED then ** Sheet1.Range(A1) = EXPIRED** * *ThisWorkbook.Save End If * ThisWorkbook.Close End If Rgds, [dp] Pada 27/07/2013 15:55, Kannan Excel menulis: Hi, how to make a file expire after a period of time. regards Kannan V -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4)
Re: $$Excel-Macros$$ Question : Form control of Excel 2007
Ashish Sir, Thank you. This is working. You have solved my big problem. With Regards, *Suyog* On Wednesday, 3 July 2013 20:23:41 UTC+5:30, ashish wrote: try this macro see if it helps Sub add_comboboxes() Dim rng As Range Dim cl As Range Dim shp As Shape For Each shp In ActiveSheet.Shapes If shp.Type = msoFormControl Then shp.Delete Next Set rng = Range(b3:b10) For Each cl In rng ActiveSheet.DropDowns.Add(cl.Left, cl.Top, cl.Width, cl.Height).Name = Combo_ cl.Row With ActiveSheet.Shapes(Combo_ cl.Row).ControlFormat .ListFillRange = A3:A10 .LinkedCell = cl.Offset(0, 2).Address End With Next End Sub On Wed, Jul 3, 2013 at 6:27 PM, Suyog Kulkarni nash...@gmail.comjavascript: wrote: Hello All, I've created one form control copy and paste them all the way down the column, hoping that the linked cell will get auto update like normally happens while copy-pasting of any normal formula. Now I've to set all individually set up the cell link for each one. Is there anyway of copying Form Control Check Boxes ? Kindly refer attached file for ready ref. Please advice. With Regards, *Suyog* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Question : Form control of Excel 2007
Hello All, I've created one form control copy and paste them all the way down the column, hoping that the linked cell will get auto update like normally happens while copy-pasting of any normal formula. Now I've to set all individually set up the cell link for each one. Is there anyway of copying Form Control Check Boxes ? Kindly refer attached file for ready ref. Please advice. With Regards, *Suyog* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Que.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ List of Diffcult formules
Hello All, Pl refer attached list. In this way, I'm planning to make one list of difficult complicated formulas. I'm planning to study about plugin-Form Controls also. I don't know about VBA much so concentrating on remaining features of Excel. Before starting preparation kindly advice about this thought. If anybody already having such excel then we can use the same. With Regards, Suyog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. Diffcult Formules.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Need formula based on 3 condition
Sam, You understood my problem correctly. I think rather using IF, I think we should try for scenario. I don't know much about this. My conditions are as follows. 1) PL are applicable after 1yr service. 2) Whoever already completed 1yr he/she will get full PL 3) If somebody finishing his 12months between the leave card duration should get PL with request to Pro-rata basis Regards, Suyog On Sunday, 13 January 2013 12:11:20 UTC+5:30, SamJesseK wrote: Suyog, It seems that multiple conditions can be met based on certain dates. Can you double check the variables? The conditions must be independent of each other for a multiple IF statement to be valid. On Sunday, January 13, 2013 1:17:56 AM UTC-5, Suyog Kulkarni wrote: Hello All, Requesting to help again. I.ve tried IF condition to solve this problem but failed. I don.t know how to create conditions with multiple If. With Regards, Suyog -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Need formula based on 3 condition
Hello All, Requesting to help again. I.ve tried IF condition to solve this problem but failed. I don.t know how to create conditions with multiple If. With Regards, Suyog -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Need formula based on 3 condition
Hello All, Please see attached excel, I'm confused how can I set IF statement based on varying 3 condition for one cell. Please review advice. With Regards, *Suyog* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. PL.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Question on My Menu !!
Hello All, I'm using Ashish Sir's My Menu ver 1.6 very frequently that increased my working speed in excel. I'm really thankful for same. Please refer attached my question regarding insert option of my menu. Please advice on my question. With Best Regards, Suyog -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Multiple Rows columns.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Query on dd-mm mm-yy format
Thanks Sam, I think my problem is solved. Regards, Suyog On Wed, Nov 16, 2011 at 12:01 AM, Sam Mathai Chacko samde...@gmail.comwrote: =IF(IFERROR(DATE(YEAR(G23),MONTH(G23),DAY(G23))=G23,0),MONTH(G23)-IF(DAY(G23)=1,0,DAY(G23)),G23) Regards, Sam Mathai Chacko On Tue, Nov 15, 2011 at 3:28 PM, Suyog Kulkarni suyog.kulka...@yahoo.comwrote: Hello Noorain, Thanks for quick response but I've added two problems in same excel. Please review advice. Suyog On Tue, Nov 15, 2011 at 3:14 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Suyog, Please see attached sheet. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Tue, Nov 15, 2011 at 10:32 AM, Suyog Kulkarni suyog.kulka...@yahoo.com wrote: Hello Friends, Find attached excel file for ref. I'm using one software which list out required material for structure in excel. Output of that excel file converts some length of Ft-In format in mm-dd-yy or mm-yy format. Ex: For Length 10-11, excel shows Nov-11 For length 11-10, excel shows 10/11/11. Somehow I need to keep all length either in text format or in Ft-inch format. I'm not importing file into excel so I can't fix the text type for particular column. Manual edition will be tedious as there are more than 75 pages (Each have more than 1000 rows), If anybody can suggest any easy way to save time. Thanks regards, -- *Suyog Kulkarni* Mailto:-suyog.kulka...@yahoo.com suyog.kulka...@hotmail.com Ph:-( +91 ) 9890123539 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Suyog Kulkarni Mailto:-suyog.kulka...@yahoo.com suyog.kulka...@hotmail.com Ph:-( +91 ) 9890123539 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal
Re: $$Excel-Macros$$ Query on dd-mm mm-yy format
Hello Noorain, Thanks for quick response but I've added two problems in same excel. Please review advice. Suyog On Tue, Nov 15, 2011 at 3:14 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Suyog, Please see attached sheet. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Tue, Nov 15, 2011 at 10:32 AM, Suyog Kulkarni suyog.kulka...@yahoo.com wrote: Hello Friends, Find attached excel file for ref. I'm using one software which list out required material for structure in excel. Output of that excel file converts some length of Ft-In format in mm-dd-yy or mm-yy format. Ex: For Length 10-11, excel shows Nov-11 For length 11-10, excel shows 10/11/11. Somehow I need to keep all length either in text format or in Ft-inch format. I'm not importing file into excel so I can't fix the text type for particular column. Manual edition will be tedious as there are more than 75 pages (Each have more than 1000 rows), If anybody can suggest any easy way to save time. Thanks regards, -- *Suyog Kulkarni* Mailto:-suyog.kulka...@yahoo.com suyog.kulka...@hotmail.com Ph:-( +91 ) 9890123539 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Suyog Kulkarni Mailto:-suyog.kulka...@yahoo.com suyog.kulka...@hotmail.com Ph:-( +91 ) 9890123539 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 3042(Solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Query on dd-mm mm-yy format
Hello Friends, Find attached excel file for ref. I'm using one software which list out required material for structure in excel. Output of that excel file converts some length of Ft-In format in mm-dd-yy or mm-yy format. Ex: For Length 10-11, excel shows Nov-11 For length 11-10, excel shows 10/11/11. Somehow I need to keep all length either in text format or in Ft-inch format. I'm not importing file into excel so I can't fix the text type for particular column. Manual edition will be tedious as there are more than 75 pages (Each have more than 1000 rows), If anybody can suggest any easy way to save time. Thanks regards, -- *Suyog Kulkarni* Mailto:-suyog.kulka...@yahoo.com suyog.kulka...@hotmail.com Ph:-( +91 ) 9890123539 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 3042.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet