$$Excel-Macros$$ i need written pdf to excel macro please helpme
-- 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$$ i need written pdf to excel macro please helpme
-- 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$$ Abridged summary of excel-macros@googlegroups.com - 32 Messages in 12 Topics
Hi Team excel, I want to create horizontal filter in excel file which having huge data. could you please help me. Thanks, Kris --- On Tue, 6/4/13, excel-macros@googlegroups.com excel-macros@googlegroups.com wrote: From: excel-macros@googlegroups.com excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 32 Messages in 12 Topics To: Abridged Recipients excel-macros@googlegroups.com Date: Tuesday, June 4, 2013, 8:36 PM Today's Topic Summary Group: http://groups.google.com/group/excel-macros/topics Urgent need Cold Fusion - Technical Specialist @ NJ [1 Update] Macro - To Combine data from multiple worksheets into one single worksheet [2 Updates] Urgent Need Windows Admin @ OH [1 Update] Please help Excel Gurus [6 Updates] Formula require [4 Updates] Hey I want to know how to create variable macros for creating the attendence sheet plese help me out [2 Updates] [No Subject] [3 Updates] Want to add every third row or coloumn! [5 Updates] Marge Data from Different workssheet. [3 Updates] Know cell.address for a clicked hyperlink [1 Update] Need to builtd carreer in MIS/Database Reporting [1 Update] use full link to learn Excel [3 Updates] Urgent need Cold Fusion - Technical Specialist @ NJ adam smith adam.app...@gmail.com Jun 04 09:48PM +0530 * * * * *Apps**-**Star** LLC* * ……GO for IT ,IT Works* * **Dear Associates,* *My name is **ADAM SMITH* *Account Manager at APPS-STAR LLC * *About Apps-Star LLC* ...more Macro - To Combine data from multiple worksheets into one single worksheet KAUSHIK SAVLA savla.kaus...@gmail.com Jun 04 09:23PM +0530 Hi Team, Need your help in creating the macro doing the below:- I am having huge data in different worksheets I am having 10 worksheets in total I want to get the data copied from each ...more Paul Schreiner schreiner_p...@att.net Jun 04 09:44AM -0700 What experience do you have with VBA and macros? If you record a macro in which you use Ctrl-End to locate the last used cell, you can then use the row number from that selection to determine ...more Urgent Need Windows Admin @ OH adam smith adam.app...@gmail.com Jun 04 09:15PM +0530 *Apps**-**Star** LLC* * ……GO for IT ,IT Works* * *Dear Associates, My name is *ADAM SMITH* Account Manager at APPS-STAR LLC * * *About Apps-Star LLC* ...more Please help Excel Gurus Harish P Y py.har...@gmail.com Jun 03 08:52PM -0700 Hi Every One, Please find the attached file, Kindly help me with the required formula In the file there is a table, with start date end date amount and corresponding months in rows ...more Vabz v...@vabs.in Jun 03 10:13PM -0700 Hi Chek this file. I have changed dates in header to respective month ends since deductions are made at the end of the month. HTH//Vabs On Tuesday, June 4, 2013 9:22:38 AM UTC+5:30, ...more Harish P Y py.har...@gmail.com Jun 04 11:14AM +0530 Hi, Thank you very much for replying to my quire y, firstly the amount needs to be calculated for a day and then equally distributed for no of days in that particular month. kindly help me ...more Vabz v...@vabs.in Jun 04 12:10AM -0700 PFA On Tuesday, June 4, 2013 11:14:15 AM UTC+5:30, Harish P Y wrote: ...more P.VIJAYKUMAR vijay.4...@gmail.com Jun 04 04:47PM +0530 Respected Harish, On what ratio do you want to distribute the amount based on the date.what are the specific criteria for distributing. Regards, VIJAYKUMAR -- ...more Bé Trần Văn betnmtdongna...@gmail.com Jun 04 11:14PM +0800 Formula Cell G5 =$F5/($E$5-$D$5) Fill down and fill right 2013/6/4 P.VIJAYKUMAR vijay.4...@gmail.com ...more Formula require Prabhakar S H prabakar.k...@gmail.com Jun 04 04:19AM -0700 Hi Team, i want to get formula to find Total value of cars with black color only. pls help. Rgds, Prabhakar ...more priti verma pritiverma1...@gmail.com Jun 04 04:54PM +0530 try this =SUMIFS($J$9:$J$17,$H$9:$H$17,Cars,$I$9:$I$17,black) ...more Prince prince141...@gmail.com Jun 04 04:46AM -0700 may be it can help you. =SUMPRODUCT(--(I9:I17=Black),--(H9:H17=Cars),(J9:J17)) Regards Prince On Tuesday, June 4, 2013 4:49:56 PM UTC+5:30, Prabhakar S H wrote: ...more Eugene Bernard eugene.bern...@gmail.com Jun 04 07:43PM +0530 Hi Prince, What is the use of -- in the formula mentioned by you. The result is OK, but I do not find this of syntax in Excel Help. Please elaborate. Regards Eugene ...more Hey I want to know how to create variable macros for creating the attendence sheet plese help me out rajkmr4...@gmail.com Jun 04 06:55AM -0700 ...more Paul Schreiner schreiner_p...@att.net Jun 04 07:13AM -0700 The Body of your email ended up in the subject line. From the subject line, I gather you have an attendance sheet. But the term variable macros is confusing. You want macros that vary? ...more [No Subject] Raj Kumar rajlu...@gmail.com Jun 04
Re: $$Excel-Macros$$ i need a macro to convert written pdf to excel. please help me
Sharmila k sharmi.sha...@gmail.com wrote: Hi friends, I need a macro to convert written pdf to excel using by excel vba. Please anyone can help me asap. Thanks, Vimal -- 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. -- 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$$
http://grashal.com/fisogpq/geljnglz.php -- 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.
Re: $$Excel-Macros$$ Please help Excel Gurus
Hi ravinder , The formula i wanted is as below if amount is Rs 6000 per month , per day it is around Rs 200 . when we enter the start date and finish date the amount should be distributed by no of days in the month. ie in january if it is 13 days it should show 2600 in january month column please help me out in solving this issue Regards Harish With Regards *HARISH P Y* *P** **THINK BEFORE YOU PRINT:**Before printing this e-mail think whether it is really necessary. Thanks for your support to protect our environment for the future generation* *1 ream of paper = 6% of a tree and 5.4 kg CO2 in the atmosphere 3 sheets of A4 paper pollutes 1 litre of water* On Wed, Jun 5, 2013 at 2:54 PM, ravinder negi ravi_colw...@yahoo.comwrote: HI, I have attached the solution, amount has been distributed equally (6000/difference between startdate and enddate). if you distribute in other ratio just change the calculation in formula. Thanks Ravinder --- On *Tue, 6/4/13, Bé Trần Văn betnmtdongna...@gmail.com* wrote: From: Bé Trần Văn betnmtdongna...@gmail.com Subject: Re: $$Excel-Macros$$ Please help Excel Gurus To: excel-macros@googlegroups.com Date: Tuesday, June 4, 2013, 8:44 PM Formula Cell G5 =$F5/($E$5-$D$5) Fill down and fill right 2013/6/4 P.VIJAYKUMAR vijay.4...@gmail.comhttp://mc/compose?to=vijay.4...@gmail.com Respected Harish, On what ratio do you want to distribute the amount based on the date.what are the specific criteria for distributing. Regards, VIJAYKUMAR On Tue, Jun 4, 2013 at 9:22 AM, Harish P Y py.har...@gmail.comhttp://mc/compose?to=py.har...@gmail.com wrote: Hi Every One, Please find the attached file, Kindly help me with the required formula In the file there is a table, with start date end date amount and corresponding months in rows i want a formula to distribute the amount month wise by referring to start date and end date Kindly help me regarding this issue. Regards Harish -- 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.comhttp://mc/compose?to=excel-macros%2bunsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.comhttp://mc/compose?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. -- P.VIJAY KUMAR -- 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.comhttp://mc/compose?to=excel-macros%2bunsubscr...@googlegroups.com . To post to this group, send email to excel-macros@googlegroups.comhttp://mc/compose?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. -- 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
Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 32 Messages in 12 Topics
It looks like you've posted a NEW topic as part of a SUMMARY of topics in the group. If you need assistance, I suggest you select the New Topic button at the top of the site. Also, use a descriptive subject to help attract the participants that have an interest or area of expertise in the subject area. next... explain exactly what you're trying to do and how you wish to accomplish your task (Excel functions, VBA macros, or other) It would be helpful to supply examples or even a sample file. Since sometimes a problem takes 5 minutes to solve, but 15 minutes or more to figure out and assemble sample data. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: krishan jha kris4u1...@yahoo.com To: excel-macros@googlegroups.com Sent: Wed, June 5, 2013 2:49:46 AM Subject: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 32 Messages in 12 Topics Hi Team excel, I want to create horizontal filter in excel file which having huge data. could you please help me. Thanks, Kris --- On Tue, 6/4/13, excel-macros@googlegroups.com excel-macros@googlegroups.com wrote: From: excel-macros@googlegroups.com excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 32 Messages in 12 Topics To: Abridged Recipients excel-macros@googlegroups.com Date: Tuesday, June 4, 2013, 8:36 PM Today's Topic Summary Group: http://groups.google.com/group/excel-macros/topics * Urgent need Cold Fusion - Technical Specialist @ NJ [1 Update] * Macro - To Combine data from multiple worksheets into one single worksheet [2 Updates] * Urgent Need Windows Admin @ OH [1 Update] * Please help Excel Gurus [6 Updates] * Formula require [4 Updates] * Hey I want to know how to create variable macros for creating the attendence sheet plese help me out [2 Updates] * [No Subject] [3 Updates] * Want to add every third row or coloumn! [5 Updates] * Marge Data from Different workssheet. [3 Updates] * Know cell.address for a clicked hyperlink [1 Update] * Need to builtd carreer in MIS/Database Reporting [1 Update] * use full link to learn Excel [3 Updates] Urgent need Cold Fusion - Technical Specialist @ NJ adam smith adam.app...@gmail.com Jun 04 09:48PM +0530 * * * * *Apps**-**Star** LLC* * ……GO for IT ,IT Works* * **Dear Associates,* *My name is **ADAM SMITH* *Account Manager at APPS-STAR LLC * *About Apps-Star LLC* ...more Macro - To Combine data from multiple worksheets into one single worksheet KAUSHIK SAVLA savla.kaus...@gmail.com Jun 04 09:23PM +0530 Hi Team, Need your help in creating the macro doing the below:- I am having huge data in different worksheets I am having 10 worksheets in total I want to get the data copied from each ...more Paul Schreiner schreiner_p...@att.net Jun 04 09:44AM -0700 What experience do you have with VBA and macros? If you record a macro in which you use Ctrl-End to locate the last used cell, you can then use the row number from that selection to determine ...more Urgent Need Windows Admin @ OH adam smith adam.app...@gmail.com Jun 04 09:15PM +0530 *Apps**-**Star** LLC* * ……GO for IT ,IT Works* * *Dear Associates, My name is *ADAM SMITH* Account Manager at APPS-STAR LLC * * *About Apps-Star LLC* ...more Please help Excel Gurus Harish P Y py.har...@gmail.com Jun 03 08:52PM -0700 Hi Every One, Please find the attached file, Kindly help me with the required formula In the file there is a table, with start date end date amount and corresponding months in rows ...more Vabz v...@vabs.in Jun 03 10:13PM -0700 Hi Chek this file. I have changed dates in header to respective month ends since deductions are made at the end of the month. HTH//Vabs On Tuesday, June 4, 2013 9:22:38 AM UTC+5:30, ...more Harish P Y py.har...@gmail.com Jun 04 11:14AM +0530 Hi, Thank you very much for replying to my quire y, firstly the amount needs to be calculated for a day and then equally distributed for no of days in that particular month. kindly help me ...more Vabz v...@vabs.in Jun 04 12:10AM -0700 PFA On Tuesday, June 4, 2013 11:14:15 AM UTC+5:30, Harish P Y wrote: ...more P.VIJAYKUMAR vijay.4...@gmail.com Jun 04 04:47PM +0530 Respected Harish, On what ratio do you want to distribute the amount based on the date.what are the specific criteria for distributing. Regards, VIJAYKUMAR -- ...more Bé Trần Văn betnmtdongna...@gmail.com Jun 04 11:14PM +0800 Formula Cell G5 =$F5/($E$5-$D$5) Fill down and fill right 2013/6/4 P.VIJAYKUMAR vijay.4...@gmail.com ...more Formula require Prabhakar S
$$Excel-Macros$$ Rerquire Formula.xlsx
Dear Experts, Please find the attached xl file formula required please help. Regards Gulam Hameed -- 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. Rerquire Formula.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Rerquire Formula.xlsx
Activity for yes status =COUNTIFS($D$3:$D$56,I5,$C$3:$C$56,yes) Activity for no status =COUNTIFS($D$3:$D$56,I5,$C$3:$C$56,no) On Wed, Jun 5, 2013 at 7:26 PM, Gulam Hameed gulamham...@gmail.com wrote: Dear Experts, ** ** Please find the attached xl file formula required please help. ** ** Regards Gulam Hameed -- 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. -- 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.
RE: $$Excel-Macros$$ Rerquire Formula.xlsx
Thank you so much priti Gulam Hameed From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of priti verma Sent: Wednesday, June 05, 2013 5:30 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rerquire Formula.xlsx Activity for yes status =COUNTIFS($D$3:$D$56,I5,$C$3:$C$56,yes) Activity for no status =COUNTIFS($D$3:$D$56,I5,$C$3:$C$56,no) On Wed, Jun 5, 2013 at 7:26 PM, Gulam Hameed gulamham...@gmail.com wrote: Dear Experts, Please find the attached xl file formula required please help. Regards Gulam Hameed -- 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 mailto:excel-macros%2bunsubscr...@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. -- 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. -- 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$$ Need Urgent Oracle DBA, with Data warehousing @ CA
*Apps-Star LLC* *……GO for IT ,IT Works* * *Dear Manager My name is *ADAM SMITH* Account Manager at APPS-STAR LLC * * *About Apps-Star LLC * Apps Star is a global IT consulting company with 1,000 consultants in America, Europe and Asia/Pacific, and approximately $1 billion in annual revenue. Client focused and results driven, Apps Star partners with organizations to develop technology strategies and solutions that deliver tangible business value * * *Requirement Of the Day From Direct Client * * * *Title** :* *Oracle** DBA,* *Location : **Sunnyvale**, CA* *Duration** : 8+ Months* * * * * *Primary Skills**:* *Oracle DBA, with Strong experience in Oracle Data warehousing* *Responsibilities:* • *DBA in Data warehousing Tuning experience* • Very good knowledge of oracle internals • Parameter set-up for *Data warehousing environment* • Knowledge about *Oracle Parallel execution, Oracle multi-level partitioning (partition wise joins, split, merge, partition exchange, etc.) and Oracle Wait Events* • *UNIX Shell scripting* *Desired Skills * • Experience working with O*racle Grid Control (good to have)* • Good knowledge of* Data warehouse concepts. (preferred)* • Expert in *database instance and query tuning. (good to have)* • Knowledge of *NetApp storage knowledge and AIX background is preferred. (Good to have) * Send me your Resume to *a...@apps-star.com* with below details: Full Legal Name : Location : Visa status : Availability : Relocation : *ADAM SMITH* - *Client Support Account Manager ** Call: 773-309-1667 |Email: a...@apps-star.com Y:adam_ap...@ymail.com|G:adam.ap...@gmail.com F: adam.ap...@facebook.com L: *www.linkedin.com/pub/adam-smith/71/8a0/566/* ** Note: If you have received this mail in error or prefer not to receive such emails in the future, please reply with REMOVE in the subject line and the email id(s) to be removed. All removal requests will be honored ASAP. We sincerely apologize for any inconvenience caused.* -- 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$$ Invitation to use Google Talk
I've been using Google Talk and thought you might like to try it out. We can use it to call each other for free over the internet. Here's an invitation to download Google Talk. Give it a try! --- You've been invited by Mr Excellent to use Google Talk. If you already have a Google account, login to Gmail and accept this chat invitation: http://mail.google.com/mail/b-c528d6c904-a6dfd3dbb6-vJ5PLNYUE0qDRwsYIyTh04uXkPw To sign up for a Google account and get started with Google Talk, you can visit: http://mail.google.com/mail/a-c528d6c904-a6dfd3dbb6-vJ5PLNYUE0qDRwsYIyTh04uXkPw?pc=en-rf---a Learn more at: http://www.google.com/intl/en/landing/accounts/ Thanks, The Google Team -- 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$$ Need Urgent Oracle DBA, with Data warehousing @ CA
*Apps-Star LLC* *……GO for IT ,IT Works* * *Dear Manager My name is *ADAM SMITH* Account Manager at APPS-STAR LLC * * *About Apps-Star LLC * Apps Star is a global IT consulting company with 1,000 consultants in America, Europe and Asia/Pacific, and approximately $1 billion in annual revenue. Client focused and results driven, Apps Star partners with organizations to develop technology strategies and solutions that deliver tangible business value * * *Requirement Of the Day From Direct Client * * * *Title** :* *Oracle** DBA,* *Location : **Sunnyvale**, CA* *Duration** : 8+ Months* * * * * *Primary Skills**:* *Oracle DBA, with Strong experience in Oracle Data warehousing* *Responsibilities:* • *DBA in Data warehousing Tuning experience* • Very good knowledge of oracle internals • Parameter set-up for *Data warehousing environment* • Knowledge about *Oracle Parallel execution, Oracle multi-level partitioning (partition wise joins, split, merge, partition exchange, etc.) and Oracle Wait Events* • *UNIX Shell scripting* *Desired Skills * • Experience working with O*racle Grid Control (good to have)* • Good knowledge of* Data warehouse concepts. (preferred)* • Expert in *database instance and query tuning. (good to have)* • Knowledge of *NetApp storage knowledge and AIX background is preferred. (Good to have) * Send me your Resume to *a...@apps-star.com* with below details: Full Legal Name : Location : Visa status : Availability : Relocation : *ADAM SMITH* - *Client Support Account Manager ** Call: 773-309-1667 |Email: a...@apps-star.com Y:adam_ap...@ymail.com|G:adam.ap...@gmail.com F: adam.ap...@facebook.com L: *www.linkedin.com/pub/adam-smith/71/8a0/566/* ** Note: If you have received this mail in error or prefer not to receive such emails in the future, please reply with REMOVE in the subject line and the email id(s) to be removed. All removal requests will be honored ASAP. We sincerely apologize for any inconvenience caused.* -- 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$$ Urgent need Cold Fusion - Technical Specialist @ NJ
* * * * *Apps**-**Star** LLC* *……GO for IT ,IT Works* * **Dear Associates,* *My name is **ADAM SMITH* *Account Manager at APPS-STAR LLC * *About Apps-Star LLC* *Apps** Star is a global IT consulting company with 1,000 consultants in America, Europe and Asia/Pacific, and approximately $1 billion in annual revenue. Client focused and results driven, AppsStar partners with organizations to develop technology strategies and solutions that deliver tangible business value* * **Requirement Of the Day From Direct Client** * *Cold Fusion - Technical Specialist* *Location: Wayne, NJ* *Duration : 2 Years* *Rate: $Low * * * *Details of Position:* Develops debugs application programs; executes system integration tests; supports production applications; knowledge of Agile Development a plus: Scrum methodology *Management Skills:* Excellent oral written communication skills, excellent problem-solving skills, flexibility, adaptive to change, good interpersonal skills, demonstrate self-initiatives, good planning and organizing, must possess the following traits for Agile Development: forward thinker, excellent collaborator, adaptive to change, ability to work well in a self-organizing team, demonstrate commitment to process self-improvement *Primary Skill: *Cold Fusion *Additional Skills:* · SQL Programming – A MUST! · Cold Fusion - Advanced · JavaScript - Intermediate · SQL PL/SQL - Advanced · .NET Environment - Intermediate · ADO .NET - Intermediate · ASP .NET Web Programming – Beginner Send me your Resume to *a...@apps-star.com* with below details: Full Legal Name : Location : Visa status : Availability : Relocation : SSN: *ADAM SMITH* - *Client Support Account Manager ** Call: 773-309-1667 |Email: a...@apps-star.com Y:adam_ap...@ymail.com|G:adam.ap...@gmail.com F: adam.ap...@facebook.com L: **www.linkedin.com/pub/adam-smith/71/8a0/566**/*http://www.linkedin.com/pub/adam-smith/71/8a0/566/ -- 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.
Re: $$Excel-Macros$$
Hi guys , I am using 2007 Microsoft excel. I am using pivot table but when I create it every time I need to go in pivot option then select display tab and then select pivot classic option every time. Is it any option for classics display. When I create pivot table then it directly create in classic option. Sent from my BlackBerry® Smartphone on Loop Mobile. -Original Message- From: Prafull Jadhav prafulltjad...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 3 Jun 2013 11:47:06 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dear Vikas, if the cell value length is less then 11 then find the solution with Vlookup and Mid function. if length if more then 10 then you have to edit the formula and add the condition. On Mon, Jun 3, 2013 at 11:35 AM, Vikas Bhosale vikin...@gmail.com wrote: Hi Frnd here I attached excel file Sent from my BlackBerry® Smartphone on Loop Mobile. -Original Message- From: chhajersand...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 3 Jun 2013 05:41:42 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How many alphabets are there? are there always 4 alphabets grouped together? And are always the alphabets in capital letter? Sandeep Sent on my BlackBerry® from Vodafone -Original Message- From: Vikas Bhosale vikin...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 3 Jun 2013 05:32:34 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Hi experts , I am beginner of excel. And I want to convert alphabet in number . Like. ABCD = 1234 A=1 B=2 C=3 D=4 E=5 F=6 G=7 H=8 I=9 J=0 In excel one cell there is ABCD I want to convert this alphabet in number like 1234 Other example: GJIA then need to convert in 7091 Please help me to solve this problem I use if conditions then concatenate but not get Wright. Answer and this process is very lengthy. Plz plz help me to solve this problem. Sent from my BlackBerry® Smartphone on Loop Mobile. -- 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. -- 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. -- 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,
$$Excel-Macros$$ Please help me adding variables to my macro
I am attaching a macro that I recorded. But I need the variables to be updated Basically this macro is going thru several tabs and update the pivot tables by simply changing the dates. So everytime I run the macro, I want dates in these pivot tables to be updated to today. Please look at the attached. Thanks -- 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. Book3.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Need Urgent Electronic Data Interchange (EDI) @ NJ
*Apps-Star LLC* *……GO for IT ,IT Works* * *Dear Manager My name is *ADAM SMITH *Account Manager at APPS-STAR LLC * * *About Apps-Star LLC * Apps Star is a global IT consulting company with 1,000 consultants in America, Europe and Asia/Pacific, and approximately $1 billion in annual revenue. Client focused and results driven, Apps Star partners with organizations to develop technology strategies and solutions that deliver tangible business value * * *Requirement Of the Day From Direct Client * * * *Title** **:** Electronic Data Interchange (EDI) * *Location : **Wayne**, NJ* *Duration** : 8+ Months* *Interview: **F2F interview/local candidates preferred* * * *Explanation for Position:* This requisition is for a supplemental staff position in the Electronic Data Interchange (EDI) mainframe group. The EDI group utilizes IBM’s, formerly Sterling, product Gentran to transform data from application flat file format to EDI format and vice versa. Currently both ANSI and EDIFACT are supported. Although EDI supports over 35 different EDI messages, the majority of the volume are 210s, 214s, 215s, and 240s. *Details of Position:* · The individual must have extensive knowledge of Gentran on the mainframe, COBOL, JCL, MQ, Syncsort, IBM utilities on the mainframe, VSAM, File Aid, Expediter, S/FTP/S, Connect Direct (formerly Sterling RDX), Easytrieve and REXX. · If the candidate has working knowledge of ESP, DB2, SQL and Changeman, it is a plus. · The individual will be involved in every phase of the development lifecycle. · He/ She must be able to attend requirements meetings, translate the requirements into design documents, code from a design document, create test scenarios/cases/scripts, perform and support various testing cycles, create implementation plans and implement the change. · In addition, this person will recommend process improvements and support the application including off site coverage. Send me your Resume to a...@apps-star.com with below details: Full Legal Name: Location: Visa status: Availability: Relocation: *ADAM SMITH* - *Client Support Account Manager ** Call: 773-309-1667 |Email: a...@apps-star.com Y:adam_ap...@ymail.com|G:adam.ap...@gmail.com F: adam.ap...@facebook.com L: *www.linkedin.com/pub/adam-smith/71/8a0/566/ * **Note:** If you have received this mail in error or prefer not to receive such emails in the future, please reply with **REMOVE** in the subject line and the email id(s) to be removed. All removal requests will be honored ASAP. We sincerely apologize for any inconvenience caused. * -- 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$$ Re: Help Needed
But what u want to do with this data ? prince On Wednesday, June 5, 2013 6:50:19 PM UTC+5:30, Patil M G wrote: HI Team Excel Experts I am learning Excel and new to Macro coding. I want to create attached INPUT FILE Format into Output Format...always INPUT FILE have huge data, difficult to do it manually could you please help me to generate macro or is their any other solution ( formula) to over come this problem -- Thank You Patil MG 91 99016 16995 -- 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.
Re: $$Excel-Macros$$ Help Needed
its serving my requirement..thank you so much for help paul thanks Patil MG On Wed, Jun 5, 2013 at 8:05 PM, Paul Schreiner schreiner_p...@att.netwrote: Try this macro. if it does what you're looking for, then I can walk you through how it operates. *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* Patil MG mailpati...@gmail.com *To:* excel-macros@googlegroups.com; Patil M G Gmail mailpati...@gmail.com *Sent:* Wed, June 5, 2013 9:25:36 AM *Subject:* $$Excel-Macros$$ Help Needed HI Team Excel Experts I am learning Excel and new to Macro coding. I want to create attached INPUT FILE Format into Output Format...always INPUT FILE have huge data, difficult to do it manually could you please help me to generate macro or is their any other solution ( formula) to over come this problem -- Thank You Patil MG 91 99016 16995 -- 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. -- 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. -- Thank You Patil MG 91 99016 16995 -- 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$$ Conditional Search Replace
Dear Friends, Do we have any functionality to do conditional search replace... For example what if I wants to search for values less than 80% replace them by 80% in selected range! Do we have any features... Best Regards, Amit Desai 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. -- 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.