Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 25 Messages in 10 Topics
Hi Sam, Noorain, Don Thank You for your help, I have tried Sam's method using --substitute, it works. Regards Dennis Tan From: excel-macros@googlegroups.com excel-macros@googlegroups.com To: Digest Recipients excel-macros@googlegroups.com Sent: Saturday, December 10, 2011 2:48 AM Subject: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 25 Messages in 10 Topics Today's Topic Summary Group: http://groups.google.com/group/excel-macros/topics * Painting in excelAmazing ! [3 Updates] * Link to download xlecius full version (with key) [1 Update] * $$ excel - macro $$ copy data from multiple row [7 Updates] * Seeking Cheque Payment Voucher Template [1 Update] * To remove the character * from the cells with a date in it. [4 Updates] * Help in preparing the column automatically [2 Updates] * Convert XLS to XML [2 Updates] * choose column when running macro [2 Updates] * hi can you solve this [2 Updates] * I want to do or learn VBA coding and MACRO [1 Update] Painting in excelAmazing ! Link to download xlecius full version (with key) $$ excel - macro $$ copy data from multiple row Seeking Cheque Payment Voucher Template To remove the character * from the cells with a date in it. Help in preparing the column automatically Convert XLS to XML choose column when running macro hi can you solve this I want to do or learn VBA coding and MACRO You received this message because you are subscribed to the Google Group excel-macros. You can post via email. To unsubscribe from this group, send an empty message. For more options, visit this group. -- 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
Re: $$Excel-Macros$$ No. of Occurrence of char in string
you can try this if excel is in A2 cell then LEN(A2)-LEN(SUBSTITUTE(A2,e,)) Regards Muni On Fri, Dec 9, 2011 at 3:10 PM, hanumant shinde arsfan2...@yahoo.co.inwrote: Hi All, it was an interview que. how will you find number of occurrence of any character from string. he said you can do it using 1 excel formula or you can use VBA. can somebody tell me the answer in both Excel as well as in VBA. eg. if string is excel then there are 2 es in this string. Thanks, Hanumant. -- 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 -- Regards Muni -- 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
$$Excel-Macros$$ Need you help to solve out control query.
Dear Expert, Here I am trying to make a some Text box control button in excel,I have made four Text Boxes one Button. Step 1 :Text Box 1 contain a No. which have to be searched in column A find out the row. Step 2 :Text Box 2 contain a value which should be come in column K Step 3 :Text Box 3 contain a value which should be come in column L Step 4 :Text Box 4 contain a value which should be come in column M check it whether it is equal to column F, if yes then put in in other wise pop up a window plz check the amount or take approval. in case amount is lower then column F then put the value in column M. again when we enter in same cell it will add in old amount. Looking for you response.. Regards, Ankit -- 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 SOW Module working1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Vba Code for Outlook
Hi All, I am looking for solution to below:- I receive No. of emails from some people asking for tax advise. Then I create tax advice and I attach the file. I need to reply to the email received below:- Hi *Sender*(as per email), As requested, please find attached below payslip showing tax payable. (Attachment file would be here) Kindly let me know in case you require further information. Best Regards, Kaushik Savla - Assistant Manager JLT India Pvt Ltd What I want to do - Firstly, I want a code which will write the above green highlighted text message automatically. Secondly, I want Sender name to be captured automatically as per email received from sender. Please suggest me some solution. Your valuable time is highly appreciated in this matter. Regards, Kaushik Savla Mobile 7738 44 9292 -- 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
Re: $$Excel-Macros$$ Help for If nesting formula
HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL (and) function Q1) i have four months jan feb marapr 61 5 0 if any two month get ' 5' then the result is GOOD other wise POOR . KINDLY RECTIFY THIS PROBLEM. THANK Q -- 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
Re: $$Excel-Macros$$ Help for If nesting formula
Hi, Can you explain more or send us the sample. Regards, MARIES. On Sat, Dec 10, 2011 at 2:59 PM, yogiyogi123 yogiyogi...@gmail.com wrote: HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL (and) function Q1) i have four months jan feb marapr 61 5 0 if any two month get ' 5' then the result is GOOD other wise POOR . KINDLY RECTIFY THIS PROBLEM. THANK Q -- 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
$$Excel-Macros$$ Urgent - Macro Code required for Outlook
Hi All, I am looking for solution to below:- I receive No. of emails from some people asking for tax advise. Then I create tax advice and I attach the file. I need to reply to the email received below:- Hi *Sender*(as per email), As requested, please find attached below payslip showing tax payable. (Attachment file would be here) Kindly let me know in case you require further information. Best Regards, Kaushik Savla - Assistant Manager JLT India Pvt Ltd What I want to do - Firstly, I want a code which will write the above green highlighted text message automatically. Secondly, I want Sender name to be captured automatically as per email received from sender. Please suggest me some solution. Your valuable time is highly appreciated in this matter. Regards, Kaushik Savla Mobile 7738 44 9292 -- 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
Re: $$Excel-Macros$$ Conditional Formatting using named ranges
hi can you not refer your named range in conditional formatting. On Thu, Dec 8, 2011 at 4:22 AM, Rohan bittu.ro...@gmail.com wrote: Not figured out what your macro ishowever what I can suggest you can use the Offset function to have the range of the Conditional formating extended automatically. Use, =Offset(A1, Counta(A:A), 0), assuming you want to apply conditional formatting in the column A. Put the above stated formula in the Conditonal Formatting dialog box, where it says Applies to Lemme know, if you have questions. Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- 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
Re: $$Excel-Macros$$ Help for If nesting formula
=IF(COUNTIF(A3:D3,5)1,good,bad) Don Guillett SalesAid Software dguille...@gmail.com From: yogiyogi123 Sent: Saturday, December 10, 2011 4:59 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help for If nesting formula HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL (and) function Q1) i have four months jan feb marapr 61 5 0 if any two month get ' 5' then the result is GOOD other wise POOR . KINDLY RECTIFY THIS PROBLEM. THANK Q -- 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
Re: $$Excel-Macros$$ Help for If nesting formula
thankq very much On Sat, Dec 10, 2011 at 8:06 PM, dguillett1 dguille...@gmail.com wrote: =IF(COUNTIF(A3:D3,5)1,good,bad) Don Guillett SalesAid Software dguille...@gmail.com *From:* yogiyogi123 yogiyogi...@gmail.com *Sent:* Saturday, December 10, 2011 4:59 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help for If nesting formula HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL (and) function Q1) i have four months jan feb marapr 61 5 0 if any two month get ' 5' then the result is GOOD other wise POOR . KINDLY RECTIFY THIS PROBLEM. THANK Q -- 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 -- 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
Re: $$Excel-Macros$$ Help for If nesting formula
Glad to help Don Guillett SalesAid Software dguille...@gmail.com From: yogiyogi123 Sent: Saturday, December 10, 2011 8:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help for If nesting formula thankq very much On Sat, Dec 10, 2011 at 8:06 PM, dguillett1 dguille...@gmail.com wrote: =IF(COUNTIF(A3:D3,5)1,good,bad) Don Guillett SalesAid Software dguille...@gmail.com From: yogiyogi123 Sent: Saturday, December 10, 2011 4:59 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help for If nesting formula HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL (and) function Q1) i have four months jan feb marapr 61 5 0 if any two month get ' 5' then the result is GOOD other wise POOR . KINDLY RECTIFY THIS PROBLEM. THANK Q -- 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 -- 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
Re: $$Excel-Macros$$ PLEASE HELP ME
You need to tell us what you want and why This cell _on this sheet___in this file_ needs to come from This cell _on this sheet___in this file_ and WHY Don Guillett SalesAid Software dguille...@gmail.com From: Chandra Singh Bora Sent: Friday, December 09, 2011 11:40 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ PLEASE HELP ME DEAR ALL MY EXCEL FRND. PLEASE SEND SOME FORMULA FOR MEDAL TALLY CHAMPIANSHIP Chandra Singh Bohra Champawat Uttrakhand -- 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
Re: $$Excel-Macros$$ choose column when running macro
Don Thanks very much works a treat, I have been trying to work out how it works beats me though, I really aprieciate your efforts Regards Stewart On 10 December 2011 15:54, dguillett1 dguille...@gmail.com wrote: I have created a macro to do as desired. See attached Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: trawets Sent: Thursday, December 08, 2011 3:02 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ choose column when running macro Hi I have a little macro that copies values from one column to another then returns the first column to zero, what I would like to achieve is every time I run the macro it either asks me which column I wish to paste value into or auto progresses through the column i.e. B Then C then E each time in runs Preferably the first where it asks me which column to paste the ranges into Code: Sub copy_hours() Worksheets(sheet1).Range(**a1:a20, a22:a44).Copy Worksheets(sheet1).Range(**c1, c22).PasteSpecial Paste:=xlPasteValues Dim Rg As Range Set Rg = ActiveSheet.Range(a1:a20, a22:a44) Rg.Value = 0 End Subcould anyone suggest how I might achieve this -- 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 -- Best Regards Stewart -- 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
Re: $$Excel-Macros$$ choose column when running macro
To explain: It asks which weekFINDS the column NUMBER for that week in row1gets the value of col E to that column...Use 60 to test Option Explicit Sub CopyHoursToSelectedWeek_SAS() Dim lr As Long Dim mwk As Long Dim mw As Range lr = Cells(Rows.Count, 1).End(xlUp).Row On Error Resume Next mwk = InputBox(Transfer data to which week ? ie: 14, SalesAid Software) Set mw = Rows(1).Find(What:=mwk, After:=Cells(1, H), LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext) If Not mw Is Nothing Then _ Cells(4, mw.Column).Resize(lr).Value = Cells(4, e).Resize(lr).Value End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Stewart Smith Sent: Saturday, December 10, 2011 11:06 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ choose column when running macro Don Thanks very much works a treat, I have been trying to work out how it works beats me though, I really aprieciate your efforts Regards Stewart On 10 December 2011 15:54, dguillett1 dguille...@gmail.com wrote: I have created a macro to do as desired. See attached Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: trawets Sent: Thursday, December 08, 2011 3:02 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ choose column when running macro Hi I have a little macro that copies values from one column to another then returns the first column to zero, what I would like to achieve is every time I run the macro it either asks me which column I wish to paste value into or auto progresses through the column i.e. B Then C then E each time in runs Preferably the first where it asks me which column to paste the ranges into Code: Sub copy_hours() Worksheets(sheet1).Range(a1:a20, a22:a44).Copy Worksheets(sheet1).Range(c1, c22).PasteSpecial Paste:=xlPasteValues Dim Rg As Range Set Rg = ActiveSheet.Range(a1:a20, a22:a44) Rg.Value = 0 End Subcould anyone suggest how I might achieve this -- 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 -- Best Regards Stewart -- 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
Re: $$Excel-Macros$$ Need you help to solve out control query.
Hi Maries, Can you tell me how you select Term_Code ? Nikhil On Sat, Dec 10, 2011 at 11:05 PM, Maries talk2mar...@gmail.com wrote: Dear Ankit, Find the attached file. i hope this will help you. Regards, MARIES. On Sat, Dec 10, 2011 at 1:15 PM, Ankit Agrawal ankit.agrawal...@gmail.com wrote: Dear Expert, Here I am trying to make a some Text box control button in excel,I have made four Text Boxes one Button. Step 1 :Text Box 1 contain a No. which have to be searched in column A find out the row. Step 2 :Text Box 2 contain a value which should be come in column K Step 3 :Text Box 3 contain a value which should be come in column L Step 4 :Text Box 4 contain a value which should be come in column M check it whether it is equal to column F, if yes then put in in other wise pop up a window plz check the amount or take approval. in case amount is lower then column F then put the value in column M. again when we enter in same cell it will add in old amount. Looking for you response.. Regards, Ankit -- 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 -- 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
Re: $$Excel-Macros$$ No. of Occurrence of char in string
Thanks Muni. this is wati got from online search. From: Muni muni.r...@gmail.com To: excel-macros@googlegroups.com Sent: Saturday, 10 December 2011 1:58 AM Subject: Re: $$Excel-Macros$$ No. of Occurrence of char in string you can try this if excel is in A2 cell then LEN(A2)-LEN(SUBSTITUTE(A2,e,)) Regards Muni On Fri, Dec 9, 2011 at 3:10 PM, hanumant shinde arsfan2...@yahoo.co.in wrote: Hi All, it was an interview que. how will you find number of occurrence of any character from string. he said you can do it using 1 excel formula or you can use VBA. can somebody tell me the answer in both Excel as well as in VBA. eg. if string is excel then there are 2 es in this string. Thanks, Hanumant. -- 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 -- Regards Muni -- 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
Re: $$Excel-Macros$$ Need you help to solve out control query.
Thanks Maries for your valuable feedback.But some query are still exist plz solve out it. In the macro I need that if we want to enter one more bill then(Now it is changing all cell) but I need that it will come under old bill Old date add in amount Second query, In form Bill date should be in DD/MM/ format the separator already mentioned for example As we enter 23 then corson automatically come in month section after entering the month section cursor should come in year section Regards, Ankit On 12/10/11, Maries talk2mar...@gmail.com wrote: Dear Ankit, Find the attached file. i hope this will help you. Regards, MARIES. On Sat, Dec 10, 2011 at 1:15 PM, Ankit Agrawal ankit.agrawal...@gmail.comwrote: Dear Expert, Here I am trying to make a some Text box control button in excel,I have made four Text Boxes one Button. Step 1 :Text Box 1 contain a No. which have to be searched in column A find out the row. Step 2 :Text Box 2 contain a value which should be come in column K Step 3 :Text Box 3 contain a value which should be come in column L Step 4 :Text Box 4 contain a value which should be come in column M check it whether it is equal to column F, if yes then put in in other wise pop up a window plz check the amount or take approval. in case amount is lower then column F then put the value in column M. again when we enter in same cell it will add in old amount. Looking for you response.. Regards, Ankit -- 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 -- 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
$$Excel-Macros$$ Your suggestion file regarding financial MIS
Dear experts, I Need finance related MIS its tutorial.Also need your valeable suggestion,How we improve our Finance MIS reports. Please send me who ever having it. Regards, Ankit -- 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
$$Excel-Macros$$ text assignment to the textbox control
Dear experts Good morning, I am trying to assign a FIXED TEXT for a TEXTBOX1 Control in MSACCESS 2003. I have given a code line like: text1.text=Good Morning But it is not assigning the text given in strings. Pls suggest me how to assign a fixed text to a text box control. Thank you. -- 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