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 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 05:21PM +0530 > >Hi, > >i have lots of data in excel Column A. in which some records are in Upper >Case. > >By which formula how can we find out these Records > >raj kumar >Raj kumar >SADAN KUMAR >MADAN KUMAR ...more > >Amresh Maurya <amreshkushw...@gmail.com> Jun 04 05:24PM +0530 > >Dear Bharti Ji, > >Use this formula. >=IF(ISERROR(FIND(" ",A1)),EXACT(A1,UPPER(A1))) > >Regards >@K > >...more > >priti verma <pritiverma1...@gmail.com> Jun 04 05:41PM +0530 > >PFA, >It may be helpul > > >...more > > Want to add every third row or coloumn! >chhajersand...@gmail.com Jun 04 04:21AM > >Dear expert, >Many time I have to add every third or every forth or every second row or >column >etc...can you suggest a function which will ease my problem! Till now I am >adding required cell one by ...more > >VBA VABZ <v...@vabs.in> Jun 04 10:44AM +0530 > >Hi > >Send sample file for more clarity > >Thanks > > >...more > >NOORAIN ANSARI <noorain.ans...@gmail.com> Jun 04 12:26PM +0530 > >Dear Sandeep, > >Select required range and run this code... > >Sub InsertSpecificRows() >Dim InsQuan As Integer >On Error Resume Next >InsQuan = InputBox("Enter number of rows to insert", "Your Call") ...more > >chhajersand...@gmail.com Jun 04 07:03AM > >Dear Noorain, >Thanks for the reply but can we do it by using function. >Sandeep Chhajer. > >Sent on my BlackBerry® from Vodafone > >-----Original Message----- >From: NOORAIN ANSARI ...more > >Prince <prince141...@gmail.com> Jun 04 04:59AM -0700 > >=SUMPRODUCT((IF(MOD(ROW($A$1:$A$11),*2*)=0,1,0)),($A$1:$A$11)) with CSE > >Just replace the bold number (2) with 3 or 4 and enjoy > >Regards >Prince > > > > >On Tuesday, June 4, 2013 9:51:49 AM ...more > > Marge Data from Different workssheet. >Tariq Aziz <tariqkh...@gmail.com> Jun 04 08:53AM +0500 > >Dear Vijy Kumar > > >i already try this add-in but it is not working. > > >Tariq > > >...more > >Vabz <v...@vabs.in> Jun 03 10:17PM -0700 > >Hi > >PFA Macro which i have made for users. > >You can change as per your need. > >HTH//Vabs > >On Tuesday, June 4, 2013 9:23:42 AM UTC+5:30, Tariq Aziz wrote: >...more > >"P.VIJAYKUMAR" <vijay.4...@gmail.com> Jun 04 04:25PM +0530 > >Respected Tariq, > >You can also download the add-in called "Kutools" from the following link : >http://www.extendoffice.com/download/kutools-for-excel.html > >Regards, >VIJAY KUMAR >...more > > Know cell.address for a clicked hyperlink >priti verma <pritiverma1...@gmail.com> Jun 04 01:46PM +0530 > >Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) >MsgBox Target.Parent.Address >End Sub > > > >...more > > Need to builtd carreer in MIS/Database Reporting >syed aliya raza hashim <hashim...@gmail.com> Jun 04 01:19PM +0530 > >Please contact 9953256629 at a very reasonable price from a Co orporate >Employee >-- with real time project experience > >Regards >syed aliya >...more > > use full link to learn Excel >VBA VABZ <v...@vabs.in> Jun 04 10:18AM +0530 > >Thanks!! > > >...more > >Nikhil Shah <nikhil201...@gmail.com> Jun 04 12:27PM +0530 > >Thanks.. > >Nikhil > > >...more > >Prafull Jadhav <prafulltjad...@gmail.com> Jun 04 12:36PM +0530 > >Thanks a lot.....It really good one. > >...more > >You received this message because you are subscribed to the Google Group >excel-macros. >You can post via email. >To unsubscribe from this group, send an empty message. >For more options, visit this group. >-- >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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of 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.
