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.