RE: $$Excel-Macros$$ Re: PDF to txt by vba code
share code with me also. Date: Wed, 4 Sep 2013 04:48:52 -0600 Subject: Re: $$Excel-Macros$$ Re: PDF to txt by vba code From: pritiverma1...@gmail.com To: excel-macros@googlegroups.com Hi Basole Thanks for the code ,Could You Pls tell me the Password that is in Your code. On Tue, Sep 3, 2013 at 12:37 PM, Basole ricardo...@gmail.com wrote: Hi, I adapted this code to use utility (PDFtoText.exe) free. To run this code please paste all files (attachments) must be in the same folder. tks. Basole. Em terça-feira, 3 de setembro de 2013 10h22min31s UTC-3, Priti_Verma escreveu: Please ignore previous mail and consider on this. i want to convert PDFs file to .txt file. through vba code. i have been search it on Google ,but not get any solution. Can someone help me on this Regards, Priti verma -- 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. -- 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. -- 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.
RE: $$Excel-Macros$$ Re: how to crack Excel VBA password
can you send me downloadable link plz?it would be great help or can share name of full file name to download there are 2 3 files for download. Date: Fri, 31 May 2013 00:10:05 -0700 From: kaursimr...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: how to crack Excel VBA password Hi Shameer, Many thanks for this post, it worked in less than 2 mins and saved me from redoing the work. Sim On Saturday, February 20, 2010 10:57:18 PM UTC+5:30, SHAM wrote:To crack the password of an VBA Macro / coding first download an HEX Editorits available from the site http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm (its a very small file of 0.5 MB capacity) Close the workbook and open the workbook file in the hex editor. Find the string DPB and change it to DPx (x is in small letter). Save the file. Open the workbook and click OK until the workbook is open (one or more dialogs are displayed describing various problems with the VBA project). Press ALT+F11, choose the menu command Tools- VBAProject Properties, navigate to the Protection tab, and change the password but do not remove it (note the new password). Save, close, and re-open the workbook. Press ALT+F11 and enter the new password. Choose Tools-VBAProject Properties, navigate to the Protection tab, and remove the password. Save the workbook. Now open the same workbook, You can use the password that you already given. SHAMEER P, KERALA, INDIA On Feb 20, 8:50 pm, sunil sasidharan sunil.sasidha...@gmail.com wrote: Hi, I wont be able to send the file as it has some confidential data of our organisations. Please let me know how do i go about cracking the password. Regards, Sunil On Sat, Feb 20, 2010 at 10:04 AM, ankur ankurpande...@gmail.com wrote: send ur file Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sat, Feb 20, 2010 at 5:16 AM, JsinSk jsin...@gmail.com wrote: Post the file here and someone will crack it for you. On Feb 19, 9:24 am, sunil sasidharan sunil.sasidha...@gmail.com wrote: *Hi All,* ** *I need to edit an excel macro file but the VBA coing is protected and nobody is aware of the password.* ** *Could you please help me on how do i crack the excel password or is there any free software available?* ** *Thanks in advance for your help Regards, Sunny * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-...@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-...@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Regards, Sunny -- 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
$$Excel-Macros$$ Change to numbers
dear Experts: Kindly look at my file,there are some numbers kindly convert this into numbers it is in text format. -- 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. change to numbers-1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ control Slicer using radio button-Urgent
hi experts, my sample file attached for reference,what i want to control slicer using radio button,when i click a slicer should be automatically changes to a value same with b and c. i think it could be done using Vba or formula,if any one can give both the solution using formula as well as well as vba it will be appreciated. its urgent. -- 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. sample.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ power pivot data copy
dear experts, i have fetched data from MS query in pivot,what i want to get updated data from pivot to excel whenever i fetch data into powerpivot window.is it possible?it can be done in excel through table but i dont know abiut power pivot fetching data.can anyone guide me? -- 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.
$$Excel-Macros$$ drop down/radio button help
hi experts, i have made two combo box in excel both depended on each other and these are depended on Radio buttons the problem arise when ever i click on radio button and value changes incombo box. what i want to make my combo box 1st vale as a default when ever i change radio button. 1st value should come when i change/click on Radio button i think its possible with Macro kindly help me. From: koul.ash...@gmail.com Date: Wed, 23 Jan 2013 19:56:41 +0530 Subject: Re: $$Excel-Macros$$ VBA Code -Slide Show To: excel-macros@googlegroups.com try this http://spreadsheetpage.com/index.php/tip/a_quick_and_dirty_slideshow_macro/ On Wed, Jan 23, 2013 at 7:54 PM, Hilary Lomotey resp...@gmail.com wrote: Hello Experts, i need assistance with a vba code to show pictures in slide show mode in excel. any help will be appreciated. ie if i insert a number of pictures in excel, i want a code that will show the pictures in slide show mode. thanks -- 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. -- Regards Ashish Koul VisitMy Excel Blog Like Us on FacebookJoin Us on Facebook P Before printing, think about the environment. -- 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. -- 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$$ countif in hidden rows
Dear Experts, kindly provide me countif formula for hidden rows, i triend to use subtotal but could fine the way,kindly provide me formula. From: aamirshahza...@gmail.com Date: Mon, 22 Oct 2012 17:11:03 +0500 Subject: Re: $$Excel-Macros$$ Formula Needed ! To: excel-macros@googlegroups.com use below formula for get desired sum =SUMIF($B$2:$B$663,E3,$C$2:$C$663) On Mon, Oct 22, 2012 at 5:06 PM, Amresh Maurya amreshkushw...@gmail.com wrote: PFA File On Mon, Oct 22, 2012 at 5:27 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote: Thx Abhi Regards, Iqbal S On 22 October 2012 17:24, abhishek agarwal abhishekagarwal...@gmail.com wrote: Dear Shaikh Iqbal Please find the attachment for the same On Mon, Oct 22, 2012 at 5:18 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote: Dear Exports, Need help in attached file. Shaikh Iqbal -- 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. -- 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. -- 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. -- 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
RE: $$Excel-Macros$$ countif in hidden rows
u did not get it,sir in subtotal we don't have option of Counting things with conditions as we do with countif,so i want a way to count with condition with hidden rows. to make it more elaborate when i use countif with hidden rows it counts everything including hidden and unhidden rows but i want to count only UNHIDDEN data not hidden so i need formula for that so kindly provide me that formula. Subject: Re: $$Excel-Macros$$ countif in hidden rows To: excel-macros@googlegroups.com From: v...@vabs.in Date: Mon, 22 Oct 2012 14:37:32 + Hi, For countif you have to use 102 with subtotal formula. Rgds//Vabs Sent on my BlackBerry® from VodafoneFrom: danial mansoor danial_...@hotmail.com Sender: excel-macros@googlegroups.com Date: Mon, 22 Oct 2012 13:50:58 +To: excel-macros@googlegroups.comReplyTo: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ countif in hidden rows Dear Experts, kindly provide me countif formula for hidden rows, i triend to use subtotal but could fine the way,kindly provide me formula. From: aamirshahza...@gmail.com Date: Mon, 22 Oct 2012 17:11:03 +0500 Subject: Re: $$Excel-Macros$$ Formula Needed ! To: excel-macros@googlegroups.com use below formula for get desired sum =SUMIF($B$2:$B$663,E3,$C$2:$C$663) On Mon, Oct 22, 2012 at 5:06 PM, Amresh Maurya amreshkushw...@gmail.com wrote: PFA File On Mon, Oct 22, 2012 at 5:27 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote: Thx Abhi Regards, Iqbal S On 22 October 2012 17:24, abhishek agarwal abhishekagarwal...@gmail.com wrote: Dear Shaikh Iqbal Please find the attachment for the same On Mon, Oct 22, 2012 at 5:18 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote: Dear Exports, Need help in attached file. Shaikh Iqbal -- 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. -- 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. -- 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
RE: $$Excel-Macros$$ watch help
ya u r rite,i though abt trace dependant and add watch feature but it takes lots of time,any short cut? Date: Sun, 29 Jul 2012 07:45:48 +0530 Subject: Re: $$Excel-Macros$$ watch help From: samde...@gmail.com To: excel-macros@googlegroups.com by effect you mean how other sheets are linked to that sheet by formula, why don't you try looking at the trace dependants feature in the formula tab of Excel. On 7/29/12, danial mansoor danial_...@hotmail.com wrote: Dear experts, i have bunch of sheets which was created by someone else,i have one input sheet it effects many sheets is there a way where i could see my input effects which sheets results?.is there any easy way?navigation on every sheet is quite hectic could any one suggest easy way or macro or some thing like that? i just wanted to see my input effect which sheets in one glance is there a way i could do this? regarads, daniyal mansoor -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ watch help
Dear experts, i have bunch of sheets which was created by someone else,i have one input sheet it effects many sheets is there a way where i could see my input effects which sheets results?.is there any easy way?navigation on every sheet is quite hectic could any one suggest easy way or macro or some thing like that? i just wanted to see my input effect which sheets in one glance is there a way i could do this? regarads, daniyal mansoor -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
RE: $$Excel-Macros$$ tricky some question
can you plz send me attached work book with screen shoots,because when ever i open ur attached work book is bold name get disappear from NAME Manager and when i apply the formula it gives me False in every row n sum all the rows kindly send me n send me in 2007 format Date: Sat, 30 Jun 2012 23:38:05 +0530 Subject: Re: $$Excel-Macros$$ tricky some question From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Danial, Please see attached workbook, It's working fine in it. For right reference you use..it =Get.cell(21,indirect(RC[1],) and for Left reference please use =Get.cell(21,indirect(RC[-1],) Hope it will help to you. On Sat, Jun 30, 2012 at 11:33 PM, danial mansoor danial_...@hotmail.com wrote: noorani when i use name ranges it gives me False at every row and eventually answers gets wrong,when ever i open ur work book it gives me NAME error could you plz send me your solve work book with correct answers? Date: Sat, 30 Jun 2012 23:18:16 +0530 Subject: Re: $$Excel-Macros$$ tricky some question From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Danial, Please use =Get.cell(21,indirect(RC[1],) and create Name range. then use simple =SUMPRODUCT(($A$5:$A$9=FALSE)*(C5:C9)) or =SUMIF($A$5:$A$9,FALSE,C5:C9) See attached sheet for more reference. Please revert if you have any query. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Sat, Jun 30, 2012 at 11:06 PM, danial mansoor danial_...@hotmail.com wrote: Dear noorani, i have attached a sample sheet hope you get idea from the given sheet,i will have to do manual sum as i did in a given sheet and it is hectic job i have huge data plz help. Date: Sat, 30 Jun 2012 22:50:29 +0530 Subject: Re: $$Excel-Macros$$ tricky some question From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Mansoor Please share your workbook with group. It is possible through Get.Cell Function in Excel. On Sat, Jun 30, 2012 at 3:38 PM, danial mansoor danial_...@hotmail.com wrote: Dear Experts, i have 2 heads of utilities one is bold and another is in general form and i have a bunch of data with same format,wat i want to sum data with one with general format UTILITIES,now when ever i apply sumif and sumproduct it include both the heads and sum both the figures number. Is there a way to pick only head which is not bold can i sum using unformated head of UTILITIES? UTILITIES UTILITIES Date: Sat, 30 Jun 2012 15:30:45 +0530 Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw From: ashishbhalar...@gmail.com To: excel-macros@googlegroups.com We have manufacturer unit and using fox base software, but now we are going to develop software of ERP in SQL, so we are transferring data from Fox to excel and after processing in excel transfer to SQL software of back financial year. But now this my query is more difficult to do, so I need your help because as I told there are thousands of record to process and is more difficult to do manually. If you have a solution for my query it will be more useful for me. Actually I tried my level best but in my task I need function formula which receive data from another sheet only once time (not repeat), inshort I use vlookup but there are repetition of data, what is the function in which data not repeat if some type of condition true. Thanks. On Sat, Jun 30, 2012 at 10:40 AM, Rajan_Verma rajanverma1...@gmail.com wrote: homework Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: 30 June 2012 9:21 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw Dear experts, Please suggest what should I do in that case, waiting for reply. On Fri, Jun 29, 2012 at 7:23 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: On Fri, Jun 29, 2012 at 7:20 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I need a function or macro to replace data from another sheets by addition of raw, these addition of raw is depend on the record of another sheet. you can find attached sheet for better understanding. I can do it manually but there are thousands of record to process so its not possible to do this. Thanks regards. Ashish Bhalara 9624111822 PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3
RE: $$Excel-Macros$$ tricky some question
thanx Noorani got the answer Date: Sat, 30 Jun 2012 23:18:16 +0530 Subject: Re: $$Excel-Macros$$ tricky some question From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Danial, Please use =Get.cell(21,indirect(RC[1],) and create Name range. then use simple =SUMPRODUCT(($A$5:$A$9=FALSE)*(C5:C9)) or =SUMIF($A$5:$A$9,FALSE,C5:C9) See attached sheet for more reference. Please revert if you have any query. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Sat, Jun 30, 2012 at 11:06 PM, danial mansoor danial_...@hotmail.com wrote: Dear noorani, i have attached a sample sheet hope you get idea from the given sheet,i will have to do manual sum as i did in a given sheet and it is hectic job i have huge data plz help. Date: Sat, 30 Jun 2012 22:50:29 +0530 Subject: Re: $$Excel-Macros$$ tricky some question From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Mansoor Please share your workbook with group. It is possible through Get.Cell Function in Excel. On Sat, Jun 30, 2012 at 3:38 PM, danial mansoor danial_...@hotmail.com wrote: Dear Experts, i have 2 heads of utilities one is bold and another is in general form and i have a bunch of data with same format,wat i want to sum data with one with general format UTILITIES,now when ever i apply sumif and sumproduct it include both the heads and sum both the figures number. Is there a way to pick only head which is not bold can i sum using unformated head of UTILITIES? UTILITIES UTILITIES Date: Sat, 30 Jun 2012 15:30:45 +0530 Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw From: ashishbhalar...@gmail.com To: excel-macros@googlegroups.com We have manufacturer unit and using fox base software, but now we are going to develop software of ERP in SQL, so we are transferring data from Fox to excel and after processing in excel transfer to SQL software of back financial year. But now this my query is more difficult to do, so I need your help because as I told there are thousands of record to process and is more difficult to do manually. If you have a solution for my query it will be more useful for me. Actually I tried my level best but in my task I need function formula which receive data from another sheet only once time (not repeat), inshort I use vlookup but there are repetition of data, what is the function in which data not repeat if some type of condition true. Thanks. On Sat, Jun 30, 2012 at 10:40 AM, Rajan_Verma rajanverma1...@gmail.com wrote: homework Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: 30 June 2012 9:21 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw Dear experts, Please suggest what should I do in that case, waiting for reply. On Fri, Jun 29, 2012 at 7:23 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: On Fri, Jun 29, 2012 at 7:20 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I need a function or macro to replace data from another sheets by addition of raw, these addition of raw is depend on the record of another sheet. you can find attached sheet for better understanding. I can do it manually but there are thousands of record to process so its not possible to do this. Thanks regards. Ashish Bhalara 9624111822 PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards. Ashish Bhalara 9624111822 PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness. -- Thanks regards. Ashish Bhalara 9624111822 PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness
$$Excel-Macros$$ tricky some question
Dear Experts, i have 2 heads of utilities one is bold and another is in general form and i have a bunch of data with same format,wat i want to sum data with one with general format UTILITIES,now when ever i apply sumif and sumproduct it include both the heads and sum both the figures number. Is there a way to pick only head which is not bold can i sum using unformated head of UTILITIES? UTILITIES UTILITIES Date: Sat, 30 Jun 2012 15:30:45 +0530 Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw From: ashishbhalar...@gmail.com To: excel-macros@googlegroups.com We have manufacturer unit and using fox base software, but now we are going to develop software of ERP in SQL, so we are transferring data from Fox to excel and after processing in excel transfer to SQL software of back financial year. But now this my query is more difficult to do, so I need your help because as I told there are thousands of record to process and is more difficult to do manually. If you have a solution for my query it will be more useful for me. Actually I tried my level best but in my task I need function formula which receive data from another sheet only once time (not repeat), inshort I use vlookup but there are repetition of data, what is the function in which data not repeat if some type of condition true. Thanks. On Sat, Jun 30, 2012 at 10:40 AM, Rajan_Verma rajanverma1...@gmail.com wrote: homework Regards Rajan verma+91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: 30 June 2012 9:21 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw Dear experts, Please suggest what should I do in that case, waiting for reply. On Fri, Jun 29, 2012 at 7:23 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: On Fri, Jun 29, 2012 at 7:20 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I need a function or macro to replace data from another sheets by addition of raw, these addition of raw is depend on the record of another sheet. you can find attached sheet for better understanding. I can do it manually but there are thousands of record to process so its not possible to do this. Thanks regards. Ashish Bhalara9624111822 PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards. Ashish Bhalara9624111822PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣ -- Thanks regards. Ashish Bhalara9624111822 PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a
RE: $$Excel-Macros$$ tricky some question
Dear noorani, i have attached a sample sheet hope you get idea from the given sheet,i will have to do manual sum as i did in a given sheet and it is hectic job i have huge data plz help. Date: Sat, 30 Jun 2012 22:50:29 +0530 Subject: Re: $$Excel-Macros$$ tricky some question From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Mansoor Please share your workbook with group. It is possible through Get.Cell Function in Excel. On Sat, Jun 30, 2012 at 3:38 PM, danial mansoor danial_...@hotmail.com wrote: Dear Experts, i have 2 heads of utilities one is bold and another is in general form and i have a bunch of data with same format,wat i want to sum data with one with general format UTILITIES,now when ever i apply sumif and sumproduct it include both the heads and sum both the figures number. Is there a way to pick only head which is not bold can i sum using unformated head of UTILITIES? UTILITIES UTILITIES Date: Sat, 30 Jun 2012 15:30:45 +0530 Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw From: ashishbhalar...@gmail.com To: excel-macros@googlegroups.com We have manufacturer unit and using fox base software, but now we are going to develop software of ERP in SQL, so we are transferring data from Fox to excel and after processing in excel transfer to SQL software of back financial year. But now this my query is more difficult to do, so I need your help because as I told there are thousands of record to process and is more difficult to do manually. If you have a solution for my query it will be more useful for me. Actually I tried my level best but in my task I need function formula which receive data from another sheet only once time (not repeat), inshort I use vlookup but there are repetition of data, what is the function in which data not repeat if some type of condition true. Thanks. On Sat, Jun 30, 2012 at 10:40 AM, Rajan_Verma rajanverma1...@gmail.com wrote: homework Regards Rajan verma+91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: 30 June 2012 9:21 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw Dear experts, Please suggest what should I do in that case, waiting for reply. On Fri, Jun 29, 2012 at 7:23 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: On Fri, Jun 29, 2012 at 7:20 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I need a function or macro to replace data from another sheets by addition of raw, these addition of raw is depend on the record of another sheet. you can find attached sheet for better understanding. I can do it manually but there are thousands of record to process so its not possible to do this. Thanks regards. Ashish Bhalara9624111822 PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards. Ashish Bhalara9624111822PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness. -- Thanks regards. Ashish Bhalara9624111822 PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any
RE: $$Excel-Macros$$ tricky some question
noorani when i use name ranges it gives me False at every row and eventually answers gets wrong,when ever i open ur work book it gives me NAME error could you plz send me your solve work book with correct answers? Date: Sat, 30 Jun 2012 23:18:16 +0530 Subject: Re: $$Excel-Macros$$ tricky some question From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Danial, Please use =Get.cell(21,indirect(RC[1],) and create Name range. then use simple =SUMPRODUCT(($A$5:$A$9=FALSE)*(C5:C9)) or =SUMIF($A$5:$A$9,FALSE,C5:C9) See attached sheet for more reference. Please revert if you have any query. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Sat, Jun 30, 2012 at 11:06 PM, danial mansoor danial_...@hotmail.com wrote: Dear noorani, i have attached a sample sheet hope you get idea from the given sheet,i will have to do manual sum as i did in a given sheet and it is hectic job i have huge data plz help. Date: Sat, 30 Jun 2012 22:50:29 +0530 Subject: Re: $$Excel-Macros$$ tricky some question From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Mansoor Please share your workbook with group. It is possible through Get.Cell Function in Excel. On Sat, Jun 30, 2012 at 3:38 PM, danial mansoor danial_...@hotmail.com wrote: Dear Experts, i have 2 heads of utilities one is bold and another is in general form and i have a bunch of data with same format,wat i want to sum data with one with general format UTILITIES,now when ever i apply sumif and sumproduct it include both the heads and sum both the figures number. Is there a way to pick only head which is not bold can i sum using unformated head of UTILITIES? UTILITIES UTILITIES Date: Sat, 30 Jun 2012 15:30:45 +0530 Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw From: ashishbhalar...@gmail.com To: excel-macros@googlegroups.com We have manufacturer unit and using fox base software, but now we are going to develop software of ERP in SQL, so we are transferring data from Fox to excel and after processing in excel transfer to SQL software of back financial year. But now this my query is more difficult to do, so I need your help because as I told there are thousands of record to process and is more difficult to do manually. If you have a solution for my query it will be more useful for me. Actually I tried my level best but in my task I need function formula which receive data from another sheet only once time (not repeat), inshort I use vlookup but there are repetition of data, what is the function in which data not repeat if some type of condition true. Thanks. On Sat, Jun 30, 2012 at 10:40 AM, Rajan_Verma rajanverma1...@gmail.com wrote: homework Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: 30 June 2012 9:21 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw Dear experts, Please suggest what should I do in that case, waiting for reply. On Fri, Jun 29, 2012 at 7:23 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: On Fri, Jun 29, 2012 at 7:20 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I need a function or macro to replace data from another sheets by addition of raw, these addition of raw is depend on the record of another sheet. you can find attached sheet for better understanding. I can do it manually but there are thousands of record to process so its not possible to do this. Thanks regards. Ashish Bhalara 9624111822 PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards. Ashish Bhalara 9624111822 PPlease do not print this email unless it is absolutely necessary. Spread environmental
$$Excel-Macros$$ convert in word file
hi experts! can you plz guide me how to convet excel sheets into word i have many excel sheets. From: danial_...@hotmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Req VBA Code Date: Wed, 13 Jun 2012 07:00:23 + hi experts! can you plz guide me how to convet excel sheets into word i have many excel sheets. Date: Wed, 13 Jun 2012 12:27:52 +0530 Subject: Re: $$Excel-Macros$$ Req VBA Code From: veerub...@gmail.com To: excel-macros@googlegroups.com Dear Nooran sir, thanks for Replay Ineed VBA Code for Thsi Particular sheet,, On Wed, Jun 13, 2012 at 12:24 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Veeru, See attachment, Hope it will help to you. On Wed, Jun 13, 2012 at 12:02 PM, Veeru TOC veerub...@gmail.com wrote: Dear Team I attached Excel file Sheet1 -Names,Sheet-2 form , when i click command button Create Particular Name with form-- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh 91-9177-444-840, -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh 91-9177-444-840, -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.comwww.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh 91-9177-444-840, -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please
$$Excel-Macros$$ power pivot problem
hi, i have downloaded power pivot file and it is showing in my addin too but when ever i run it does not show in tabs.i m using windows xp can anybody tell me wats the problem. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
RE: $$Excel-Macros$$ regarding font color based condition
how do u know abt this get function?wat it does?and plz let me know how can we know abt these functions.? Date: Tue, 29 May 2012 15:08:34 +0530 Subject: Re: $$Excel-Macros$$ regarding font color based condition From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Sanjib, Please use below formula through define Name =Get.cell(24,indirect(RC[-1],)) See attached sheet. -- Thanks regards, Noorain Ansari www.noorainansari.comwww.excelmacroworld.blogspot.com On Tue, May 29, 2012 at 1:54 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear Sir / Madam, Please see the attachment. I have given you only 10 or 12 data. But there could have been more than 5000 rows of data. I want if cell color is red in column A then automatically it will be indicating no is column B. Thanking you Regards, Sanjib -- - -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ question for noorani
how can we get excel 4 functions?any resource? Date: Tue, 29 May 2012 15:31:25 +0530 Subject: Re: $$Excel-Macros$$ MACRO From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Sagar, Please find attached study material of Basic Macro and follow excel-macro group on regular basis. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 29, 2012 at 2:28 PM, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: Dear All, I want to learn MACRO's from basic so kindly give me some material for the same. Thanks Regards, K SAGAR -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ count tricky question
Dear Experts, i wrote daniyal without quote in cell a1 and i want to count All a without quote in this daniyal a. is there any method to do this? any formula? and DIV error can be count?another formula? Date: Fri, 18 May 2012 15:00:36 +0530 Subject: Re: $$Excel-Macros$$ Form tracker and new base From: drdeva...@gmail.com To: excel-macros@googlegroups.com Dear Anil Sir, The file that you have share is not at all working. Please check from your end. and on clicking the Traced data button The UserfForm1 should show and in userfrom customer data or name list should validate, on selecting the customer name the database of that particular customer should reflect on the form itself. I think you have got my point !. Please try sir, thanks Thanks Regards, Deba Ranjan P On Fri, May 18, 2012 at 2:32 PM, Anil Gawli gawlianil8...@gmail.com wrote: Latest file Attached On Fri, May 18, 2012 at 9:54 AM, Deba Ranjan drdeva...@gmail.com wrote: Dear Expert, Please anyone help me on my query, the query is in the attached file. i have been looking on this and trying for past couple of days back. thank you experts. Thanks Regards, Deba Ranjan P -- Forwarded message -- From: Deba Ranjan drdeva...@gmail.com Date: Wed, May 16, 2012 at 12:24 PM Subject: Re: $$Excel-Macros$$ Form tracker and new base To: excel-macros@googlegroups.com Hi Anil, It was a awesome attempt, and done it, thanks for the same. But i have some again query, Please find the attached file, i have explained it clearly, i have added one more button, please find that. i want seems to be like search engine in the second form. thank you all the experts. Thanks Regards, Deba Ranjan P On Wed, May 16, 2012 at 11:41 AM, Anil Gawli gawlianil8...@gmail.com wrote: On Wed, May 16, 2012 at 9:53 AM, Deba Ranjan drdeva...@gmail.com wrote: Dear Experts, Waiting for the revert with solution. Thanks Thanks Regards, Deba Ranjan P -- Forwarded message -- From: Deba Ranjan drdeva...@gmail.com Date: Tue, May 15, 2012 at 10:22 AM Subject: $$Excel-Macros$$ Form tracker and new base To: excel-macros@googlegroups.com Hi Experts, Very good morning, Dear groups and experts, i have some data base which need to be created in userform, i have explained in the attached file. Please help me sort out this problem. Thanks in advance. Thanks Regards, Deba Ranjan P -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential
RE: $$Excel-Macros$$ count tricky question
thanx but is ther a way we can count errors like div error and others in whole range?like we use count for counting numbers? Subject: Re: $$Excel-Macros$$ count tricky question To: excel-macros@googlegroups.com From: koul.ash...@gmail.com Date: Fri, 18 May 2012 10:01:02 + Len(a1)-len(substitute(a1,a,)) Try see if it worksSent on my BlackBerry® from VodafoneFrom: danial mansoor danial_...@hotmail.com Sender: excel-macros@googlegroups.com Date: Fri, 18 May 2012 09:48:57 +To: excel-macros@googlegroups.comReplyTo: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ count tricky question Dear Experts, i wrote daniyal without quote in cell a1 and i want to count All a without quote in this daniyal a. is there any method to do this? any formula? and DIV error can be count?another formula? Date: Fri, 18 May 2012 15:00:36 +0530 Subject: Re: $$Excel-Macros$$ Form tracker and new base From: drdeva...@gmail.com To: excel-macros@googlegroups.com Dear Anil Sir, The file that you have share is not at all working. Please check from your end. and on clicking the Traced data button The UserfForm1 should show and in userfrom customer data or name list should validate, on selecting the customer name the database of that particular customer should reflect on the form itself. I think you have got my point !. Please try sir, thanks Thanks Regards, Deba Ranjan P On Fri, May 18, 2012 at 2:32 PM, Anil Gawli gawlianil8...@gmail.com wrote: Latest file Attached On Fri, May 18, 2012 at 9:54 AM, Deba Ranjan drdeva...@gmail.com wrote: Dear Expert, Please anyone help me on my query, the query is in the attached file. i have been looking on this and trying for past couple of days back. thank you experts. Thanks Regards, Deba Ranjan P -- Forwarded message -- From: Deba Ranjan drdeva...@gmail.com Date: Wed, May 16, 2012 at 12:24 PM Subject: Re: $$Excel-Macros$$ Form tracker and new base To: excel-macros@googlegroups.com Hi Anil, It was a awesome attempt, and done it, thanks for the same. But i have some again query, Please find the attached file, i have explained it clearly, i have added one more button, please find that. i want seems to be like search engine in the second form. thank you all the experts. Thanks Regards, Deba Ranjan P On Wed, May 16, 2012 at 11:41 AM, Anil Gawli gawlianil8...@gmail.com wrote: On Wed, May 16, 2012 at 9:53 AM, Deba Ranjan drdeva...@gmail.com wrote: Dear Experts, Waiting for the revert with solution. Thanks Thanks Regards, Deba Ranjan P -- Forwarded message -- From: Deba Ranjan drdeva...@gmail.com Date: Tue, May 15, 2012 at 10:22 AM Subject: $$Excel-Macros$$ Form tracker and new base To: excel-macros@googlegroups.com Hi Experts, Very good morning, Dear groups and experts, i have some data base which need to be created in userform, i have explained in the attached file. Please help me sort out this problem. Thanks in advance. Thanks Regards, Deba Ranjan P -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd
RE: $$Excel-Macros$$ ALL EXCEL FORMULA FUNCTION
dear Noorani, do you have material for intermediate level user in which macro and other material related to advance is not included. plz send me. Date: Tue, 15 May 2012 15:27:57 +0530 Subject: Re: $$Excel-Macros$$ ALL EXCEL FORMULA FUNCTION From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Rakesh, Please find attached study materials. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 15, 2012 at 2:31 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Hi, I want to learn All excel formula functions their use, so plz share links or files if any with you. - Thanks Regards, Rakesh Kumar Sharma -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ need for mula undertanding?
Dear experts! the are two names i used and apply this formula using a wild card =COUNTIF(C20:C21,*a*) its gives me answer 2 instead of 5 because in the given data there are 5 a instead of 2. ali a daniyal a so any one could explain me why it is given 2 instead of 5? does wildcard does not count all a or wat is the reason kindly expain me? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in 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$$ count solve problem formula problem
attached sheet need formula for count with condition problem is mentioned in given file. Date: Thu, 26 Apr 2012 12:43:00 +0530 Subject: Re: $$Excel-Macros$$ Hidi Font in Excel - Amazing From: anil.kan...@gmail.com To: excel-macros@googlegroups.com not working sir On Thu, Apr 26, 2012 at 12:35 AM, Rajan_Verma rajanverma1...@gmail.com wrote: HI Group, I found an amazing English to Hindi Converter on Linkedin Groups. See the attached file. https://www.box.com/s/a67b9a6f0e77ff84ada6?goback=%2Egmp_1838429%2Egde_1838429_member_109711042 Hope you will also like it Rajan. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards Anil Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Book3.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ count solve problem formula problem
i need 5 Answer after excluding blank,and criteria could be change then you formula would be failed. Date: Thu, 26 Apr 2012 15:45:10 +0530 Subject: Re: $$Excel-Macros$$ count solve problem formula problem From: waheedb...@gmail.com To: excel-macros@googlegroups.com HI Daniel, Please use seperate post for your queries, by the way u can use this formula to count: =COUNTIF(A:A,=4/30/2012) Note: How u r getting the 5 as answer i dont understand. On Thu, Apr 26, 2012 at 2:47 PM, danial mansoor danial_...@hotmail.com wrote: attached sheet need formula for count with condition problem is mentioned in given file. Date: Thu, 26 Apr 2012 12:43:00 +0530 Subject: Re: $$Excel-Macros$$ Hidi Font in Excel - Amazing From: anil.kan...@gmail.com To: excel-macros@googlegroups.com not working sir On Thu, Apr 26, 2012 at 12:35 AM, Rajan_Verma rajanverma1...@gmail.com wrote: HI Group, I found an amazing English to Hindi Converter on Linkedin Groups. See the attached file. https://www.box.com/s/a67b9a6f0e77ff84ada6?goback=%2Egmp_1838429%2Egde_1838429_member_109711042 Hope you will also like it Rajan. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards Anil Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post
$$Excel-Macros$$ disable copy in menue bar
dear all, is there a way to disable copy from menue bar?i have protected sheet it has disable copy but not from menue bar is there a way to do this its urgent? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in 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$$ modification in paste special macro.
i used this macro and assigned it a shortcut key for my conveniance for paste special values,but i can not undo last actions is that possible to undo last 2 actions after modification of this posible? is that possible to modify and get desired result and undo last 2 actions only? how is that possible? Sub daniyal() Application.ScreenUpdating = False On Error Resume Next Selection.HasFormula = Selection.PasteSpecial(xlPasteValues) Selection.NumberFormat = #,##0.00 Application.CutCopyMode = False Application.ScreenUpdating = True End Sub -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ custom number formating
7928688.conver this number using custom number format into 1000 mean i need custom number formating 7929 same goes with othe rnumber also. Date: Mon, 5 Mar 2012 16:49:27 +0530 Subject: $$Excel-Macros$$ Help On Chart From: shrinivas...@gmail.com To: excel-macros@googlegroups.com Dear Experts I want a help for charts. I wants to make a 3 charts in one graph,but problem is that the ranges are different for eg ranges are as follows range -1 =: 13 to 15 range -2 =: 19 to 22 range -1 =: 28 to 32 If i make all the charts in one graph then the scale will taken as from (min 13 to max 32) which is very large scale suppose there is a reading in the range (12.8, 13.1, 12.5) due to large scale it doesnot show difference on graph Actually I want is that Can I adjust the Y scale Like (13 to 15 then 19 to 22 and then 28 to 32) as there is no reading in between DAta sheet and graph attached (chart1 sheet 1) Waiting for reply Thanks in advance Ragards Shrinivas -- Shrini -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in 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$$ number spliting formula
i used NOW() function to get below date but now i want to split it,i try to used LEFT and RIGHT function but it does not work on numbers i think wats the reason? and any suitable formula? 3/1/2012 9:54:09 PM Date: Thu, 1 Mar 2012 17:58:56 +0530 Subject: $$Excel-Macros$$ Userform Filter From: drdeva...@gmail.com To: noorain.ans...@gmail.com; grug...@gmail.com CC: excel-macros@googlegroups.com Dear Sir, Please help me in creating user for filter. i mean :- for eg. 1. customer name:- Ranjan lawran 2. Mobile:- 6587459874 3. state:- delhi. Above data is just an example, in user form, when i click ranjan Lawran, his particular number 6587459874 as well as his state should come. can u please do for me that in urgent basis. PLease. RegardsDeba Ranjan P ^^ஜ۩۞۩ஜ▬▬▬ ▬^^ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com attachment: image001.gif
RE: $$Excel-Macros$$ number spliting formula
i need to use formula,i did paste special but left right function does not work properly y?i need to extract time only instead of data but date function does not work properly? plz give me any formula. Date: Thu, 1 Mar 2012 23:36:45 +0530 Subject: Re: $$Excel-Macros$$ number spliting formula From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear Danial, You can also use Text To Column after paste Special as Value Process Select-Fixed Width-text-Ok On Thu, Mar 1, 2012 at 10:54 PM, danial mansoor danial_...@hotmail.com wrote: i used NOW() function to get below date but now i want to split it,i try to used LEFT and RIGHT function but it does not work on numbers i think wats the reason? and any suitable formula? 3/1/2012 9:54:09 PM Date: Thu, 1 Mar 2012 17:58:56 +0530 Subject: $$Excel-Macros$$ Userform Filter From: drdeva...@gmail.com To: noorain.ans...@gmail.com; grug...@gmail.com CC: excel-macros@googlegroups.com Dear Sir, Please help me in creating user for filter. i mean :- for eg. 1. customer name:- Ranjan lawran 2. Mobile:- 6587459874 3. state:- delhi. Above data is just an example, in user form, when i click ranjan Lawran, his particular number 6587459874 as well as his state should come. can u please do for me that in urgent basis. PLease. RegardsDeba Ranjan P ^^ஜ۩۞۩ஜ▬▬▬ ▬^^ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari http://noorainansari.com/ http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss
$$Excel-Macros$$ water fall chart
hi experts, can any one send me working on water fall chart with connector lines?i need template with formulas i just need to put values and it automatically made chart with connector using given data. note: data should be composed on intail and final values and in between these 4 values. From: amit.de...@merucabs.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ macro to sort excel data email to party Date: Thu, 23 Feb 2012 17:08:26 +0530 Sure point taken... Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chhajersand...@gmail.com Sent: 23 February 2012 10:43 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ macro to sort excel data email to party Dear Amit, Its mean that when ever you send your mail next time set your email priority to normal rather than urgent. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone From: Amit Desai (MERU) amit.de...@merucabs.com Sender: excel-macros@googlegroups.com Date: Thu, 23 Feb 2012 07:01:40 +0530 To: excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ macro to sort excel data email to party Dear All, I am not sure what are the rules to define “high priority”. I am not sure why this was taken other way round. Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 22 February 2012 18:57 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ macro to sort excel data email to party Why is YOUR request more HIGH PRIORITY than others. Some of us take this differently than you might desire. DELETE. Don Guillett SalesAid Software dguille...@gmail.com From: Amit Desai (MERU) Sent: Tuesday, February 21, 2012 11:46 PM To: excel-macros@googlegroups.com Subject: FW: $$Excel-Macros$$ macro to sort excel data email to party Dear All, Please find attached sample file. Following things needs to be done; 1) In first sheet there are data that needs to be sorted work shop wise. 2) In the second sheet email ids are mentioned where we need to send those sorted data per workshop. Please let me know if we have macro for that. Best Regards, Amit From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com] Sent: 20 February 2012 21:31 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ macro tort excel data email to party Dear All, Please find attached sample file. In first sheet there are data that needs to be sorted work shop wise. In the second sheet email ids are mentioned where we need to send those sorted data per workshop. Please let me know if we have macro for that. Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: 20 February 2012 21:05 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ macro for excel data to email Check these links... http://www.excelvbamacros.com/2010/07/vba-code-to-send-email-through-excel.html http://www.excelvbamacros.com/2011/06/send-emails-and-attach-filtered-data.html On Mon, Feb 20, 2012 at 7:30 PM, Amit Desai (MERU) amit.de...@merucabs.com wrote: Dear Friends, Is there any macro for sending excel data to emails of different vendors? Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post
RE: $$Excel-Macros$$ paste special problem
Option Explicit Sub dovalues() 'Application.ScreenUpdating = False Dim ws As Worksheet For Each ws In ActiveWorkbook.Sheets ws.Cells.Copy ws.Cells.PasteSpecial (xlPasteValues) Next ws 'Range(a1).Select Application.ScreenUpdating = True Application.CutCopyMode = False End Sub From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ paste special problem Date: Fri, 3 Feb 2012 15:18:36 -0600 Show me. Don Guillett SalesAid Software dguille...@gmail.com From: danial mansoor Sent: Friday, February 03, 2012 3:07 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ paste special problem thanx,your work fine with with little changes. From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ paste special problem Date: Fri, 3 Feb 2012 14:33:36 -0600 Run mine Don Guillett SalesAid Software dguille...@gmail.com From: danial mansoor Sent: Friday, February 03, 2012 2:09 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ paste special problem in this i have t select each sheet is there a way i run macro and every sheet get updated with values and no formula shown?bt plz consider huge file Date: Fri, 3 Feb 2012 23:47:03 +0530 Subject: Re: $$Excel-Macros$$ paste special problem From: vijayajith...@gmail.com To: excel-macros@googlegroups.com Hi mansoor, sub tex() selection.value = selection.value end sub On Fri, Feb 3, 2012 at 9:08 PM, danial mansoor danial_...@hotmail.com wrote: i have a big file with many sheets i want to convert formula in values,if i do individually it will take lotes of time can any one tell me the macro which will work? Note:macro should work fine in huge file i have a macro which is working fine with small file but not in huge file urgent help will be appreciated. Date: Thu, 2 Feb 2012 09:21:22 +0530 Subject: Re: $$Excel-Macros$$ $$Excel-Macros$$ Index Match Formula From: vijayendrar...@gmail.com To: excel-macros@googlegroups.com Hi Sam, Your formulas resolves my problem and thanks a lot for the same. Can you please let me know the logic behind of this formula. Rohan, I wanted to pick the employees name from the same project and Sam done it in right way. Regards, Vijayendra 2012/2/1 Sam Mathai Chacko samde...@gmail.com Here's the result. I have also sorted the list based on project. Please confirm if that is what you are looking for. Regards, Sam Mathai Chacko On Wed, Feb 1, 2012 at 8:53 PM, Vijayendra Rao vijayendrar...@gmail.com wrote: Dear All, I want to put index match formula (or any other formula) in attached file, can you please help me to put the formula. Excel file is attached along with email. Regards, Vijayendra 94491 67631 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- ಧನ್ಯವಾದಗಳು, ವಿಜಯೇಂದ್ರ, ೯೪೪೯೧ ೬೭೬೩೧ Regards, Vijayendra 94491 67631 -- FORUM RULES (986+ members
$$Excel-Macros$$ paste special problem
i have a big file with many sheets i want to convert formula in values,if i do individually it will take lotes of time can any one tell me the macro which will work? Note:macro should work fine in huge file i have a macro which is working fine with small file but not in huge file urgent help will be appreciated. Date: Thu, 2 Feb 2012 09:21:22 +0530 Subject: Re: $$Excel-Macros$$ $$Excel-Macros$$ Index Match Formula From: vijayendrar...@gmail.com To: excel-macros@googlegroups.com Hi Sam, Your formulas resolves my problem and thanks a lot for the same. Can you please let me know the logic behind of this formula. Rohan, I wanted to pick the employees name from the same project and Sam done it in right way. Regards, Vijayendra 2012/2/1 Sam Mathai Chacko samde...@gmail.com Here's the result. I have also sorted the list based on project. Please confirm if that is what you are looking for. Regards, Sam Mathai Chacko On Wed, Feb 1, 2012 at 8:53 PM, Vijayendra Rao vijayendrar...@gmail.com wrote: Dear All, I want to put index match formula (or any other formula) in attached file, can you please help me to put the formula. Excel file is attached along with email. Regards, Vijayendra 94491 67631 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- ಧನ್ಯವಾದಗಳು, ವಿಜಯೇಂದ್ರ, ೯೪೪೯೧ ೬೭೬೩೧ Regards, Vijayendra 94491 67631 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ paste special problem
thanx,your work fine with with little changes. From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ paste special problem Date: Fri, 3 Feb 2012 14:33:36 -0600 Run mine Don Guillett SalesAid Software dguille...@gmail.com From: danial mansoor Sent: Friday, February 03, 2012 2:09 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ paste special problem in this i have t select each sheet is there a way i run macro and every sheet get updated with values and no formula shown?bt plz consider huge file Date: Fri, 3 Feb 2012 23:47:03 +0530 Subject: Re: $$Excel-Macros$$ paste special problem From: vijayajith...@gmail.com To: excel-macros@googlegroups.com Hi mansoor, sub tex() selection.value = selection.value end sub On Fri, Feb 3, 2012 at 9:08 PM, danial mansoor danial_...@hotmail.com wrote: i have a big file with many sheets i want to convert formula in values,if i do individually it will take lotes of time can any one tell me the macro which will work? Note:macro should work fine in huge file i have a macro which is working fine with small file but not in huge file urgent help will be appreciated. Date: Thu, 2 Feb 2012 09:21:22 +0530 Subject: Re: $$Excel-Macros$$ $$Excel-Macros$$ Index Match Formula From: vijayendrar...@gmail.com To: excel-macros@googlegroups.com Hi Sam, Your formulas resolves my problem and thanks a lot for the same. Can you please let me know the logic behind of this formula. Rohan, I wanted to pick the employees name from the same project and Sam done it in right way. Regards, Vijayendra 2012/2/1 Sam Mathai Chacko samde...@gmail.com Here's the result. I have also sorted the list based on project. Please confirm if that is what you are looking for. Regards, Sam Mathai Chacko On Wed, Feb 1, 2012 at 8:53 PM, Vijayendra Rao vijayendrar...@gmail.com wrote: Dear All, I want to put index match formula (or any other formula) in attached file, can you please help me to put the formula. Excel file is attached along with email. Regards, Vijayendra 94491 67631 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- ಧನ್ಯವಾದಗಳು, ವಿಜಯೇಂದ್ರ, ೯೪೪೯೧ ೬೭೬೩೧ Regards, Vijayendra 94491 67631 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible
$$Excel-Macros$$ paste special dialogue box
is there an easy way to paste special values or using vba get paste special dialogue box.? hope i get best solution From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently) Date: Tue, 24 Jan 2012 07:35:10 -0600 Try this. Make sure you do not have any line breaks Option Explicit Sub CopyShtwitoutdecimals() Dim i As Long Dim lr As Long Dim lc As Long Dim mf As Range For i = 1 To Sheets.Count With Sheets(i) lr = .Cells.Find(*, Cells(Rows.Count, Columns.Count) _ , , , xlByRows, xlPrevious).Row lc = .Cells.Find(*, Cells(Rows.Count, Columns.Count) _ , , , xlByColumns, xlPrevious).Column Set mf = .Cells.Find(What:=Activity, LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False) If Not mf Is Nothing Then .Range(.Cells(mf.Row, 1), .Cells(lr, lc)).NumberFormat = 0.00 End If End With Next Sheets(Sheet1).UsedRange.Value = Sheets(Sheet1).UsedRange.Value Sheets(Sheet1).Copy End Sub Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Zafar Iqbal Sent: Monday, January 23, 2012 11:15 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently) I pasted this line in macro last portion as mentioned below:- Sheets(“sheet1”).UsedRange.Value = Sheets(“sheet1”).UsedRange.Value Sheets(Sheet1).Copy End Sub I am getting message Complie Error: Variable not defined with yellow selection at Sheet1. Please help in this matter. Thanks Regrads, Zafar iqbal On Jan 23, 7:35 pm, dguillett1 dguille...@gmail.com wrote: Oops. I also should have added this to change formulas to values before copy sheets(“sheet1”).usedrange.value=sheets(“sheet1”).usedrange.value Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Monday, January 23, 2012 9:21 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently) From what Don intended, I believe it is Dim i as long, lr as long, lc as long, mf as range Regards, Sam Mathai Chacko On Mon, Jan 23, 2012 at 8:47 PM, Zafar Iqbal ziqba...@gmail.com wrote: -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to
RE: $$Excel-Macros$$ help pls : find first non empty row in range
use this formula with NOT ONLY PRESS ENTER,PRESS CONTROL+SHIFT+ENTER its an array formula it ll give u 7 answer.u =MAX(IF(E17:E260,E17:E26)) Date: Tue, 8 Feb 2011 17:05:33 -0800 Subject: $$Excel-Macros$$ help pls : find first non empty row in range From: lupins...@yahoo.com To: excel-macros@googlegroups.com Hi All, I hope you will help me in maybe something that is so simple, but I've sent last 2 hours to sort it out without any conclusion. :( The problem is: I need to find first cell that is bigger then 0 in the specific range. HELP!!! PS I'd like to add an attachement but I don't know how, so e.g.: column X 0 0 0 0 7 6 7 0 0 0 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Learning Macro
U CAN JOIN THIS ONLINE COURSE FOR LEARNING MACROS IN DETAIL, ITS AWESOME GO AND HAVE A LOOK... http://www.masterofmacros.com/ Date: Thu, 9 Dec 2010 11:01:47 +0530 Subject: $$Excel-Macros$$ Learning Macro From: balbirku...@sify.com To: excel-macros@googlegroups.com Dear Friends, I dont know how create macros in excel and how and what codes are used for its creation. But, I am interested in Knowing them. Please suggest me from where i could learn. With Thanks Regards -- Balbir Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
