Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop

2015-10-07 Thread Leo
thisisthenameofanewworkbook.xlsb", > > _ > FileFormat:=xlExcel12, _ > CreateBackup:=False > Workbooks("thisisthenameofanewworkbook.xlsb").Close > > End Sub > > I hope this helps. > > *Paul* > > > -

Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop

2015-10-07 Thread Paul Schreiner
Abhishek, snarky...I like it! :) Paul From: Abhishek Jain <abhishek@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Wednesday, October 7, 2015 2:37 AM Subject: Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save it on des

Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop

2015-10-07 Thread Paul Schreiner
l 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: Abhishek Jain <abhishek@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.co

Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop

2015-10-07 Thread Abhishek Jain
Yes, we can. On Sun, Oct 4, 2015 at 3:47 PM, PRADEEP KUMAR KOKNE < pradeepkumar...@gmail.com> wrote: > Hello all, > > Can you write code for to filter(Column S)-> select the complete visible > data and paste it in new workbook and save it. > > Example: Column S can have 50 lines data with 10

$$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop

2015-10-04 Thread PRADEEP KUMAR KOKNE
Hello all, Can you write code for to filter(Column S)-> select the complete visible data and paste it in new workbook and save it. Example: Column S can have 50 lines data with 10 names 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) !

$$Excel-Macros$$ Filter rows with com

2015-09-26 Thread BK
Dear Experts, Kindly tell how to filter rows in excel sheet with comment in a particular column -- 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)

Re: $$Excel-Macros$$ Filter rows with com

2015-09-26 Thread ashish koul
Option Compare Text Sub filteroncomments() Dim commenttext As String Dim commentrng As Range Dim cl As Range With ActiveSheet .FilterMode = False .UsedRange.EntireRow.Hidden = False On Error Resume Next Set commentrng = ActiveSheet.UsedRange.SpecialCells(xlCellTypeComments)

Re: $$Excel-Macros$$ Filter Data for Current Month

2015-08-03 Thread Soumyendu Paul
Is there anyone to help? On Tue, Aug 4, 2015 at 10:43 AM, Soumyendu Paul soumyendu...@gmail.com wrote: I want to filter all data for all July irrespective of year -- 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

$$Excel-Macros$$ Filter Data for Current Month

2015-08-03 Thread Soumyendu Paul
I want to filter all data for all July irrespective of year -- 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.

Re: $$Excel-Macros$$ Filter Data for Current Month

2015-08-03 Thread Mandeep Baluja
Check this out !!! Sub test() With Sheets(Master).Range($A:$AB) .Parent.AutoFilterMode = False .AutoFilter Field:=3, Criteria1:=xlFilterAllDatesInPeriodJuly, Operator:=xlFilterDynamic End With End Sub Regards, Mandeep Baluja On Tuesday, August 4, 2015

$$Excel-Macros$$ FILTER ISSUE

2014-09-22 Thread big smile
Respected Excel Guru / Friends I have 6 entries in excel files from Raw 3 to Raw 8 I want the formula that --- When ever i filter any raw by selecting any family name - Ex I filter Dhimant Parmar - EX R7 then i want in B1 What ever is in f - column after filter. When ever i change my filter

Re: $$Excel-Macros$$ FILTER ISSUE

2014-09-22 Thread Vaibhav Joshi
Chandresh bhai, it is not issue but requirement..here you go... Add formula =row() in column P each cell corresponding to data. Add formula =INDIRECT(RSUBTOTAL(6,$P$2:$P$9)C6,FALSE) to cell B2. So as when you filter data you will get your desired result. Note: This will work only for filter

Re: $$Excel-Macros$$ FILTER ISSUE

2014-09-22 Thread big smile
Thank you Vaibhav Bhai for your good command over Excel Formulas God Bless you .. You are help is very good to this group. Keep it up. On Mon, Sep 22, 2014 at 2:44 PM, Vaibhav Joshi v...@vabs.in wrote: Chandresh bhai, it is not issue but requirement..here you go... Add formula =row() in

Re: $$Excel-Macros$$ FILTER ISSUE

2014-09-22 Thread Vaibhav Joshi
Cheers Bro.. Keep Smiling :) + *I did not do this for you. God is here working through me for you.* On Mon, Sep 22, 2014 at 3:39 PM, big smile bigsmile...@gmail.com wrote: Thank you Vaibhav Bhai for your good command over Excel Formulas God Bless you .. You are help is very good to

Re: $$Excel-Macros$$ Filter

2014-09-03 Thread daya p
sir, not accurate pls with combo box some changed bcoz if any 1 change data in sheet its not correct so i hide that data only want 2 show form is i select india than next combo (state) show all state names than i select 1 state name than it it show its capital with 4 th combo data Country

Re: $$Excel-Macros$$ Filter

2014-09-03 Thread Bé Trần Văn
You attempt to 1 again. 2014-09-03 14:57 GMT+07:00 daya p princedaya2...@gmail.com: sir, not accurate pls with combo box some changed bcoz if any 1 change data in sheet its not correct so i hide that data only want 2 show form is i select india than next combo (state) show all state

$$Excel-Macros$$ Filter

2014-08-30 Thread daya p
Hi Friends, I need help regarding filter data form with 3 combo box label 1st combo i select INDIA next if i select State (in2nd combo) name as Gujrat 3rd combo vl show Gandhinagar Country State Capital INDIA Karnataka Banglore INDIA Maharashatra Mumbai INDIA Goa Panaji INDIA Gujarat

Re: $$Excel-Macros$$ Filter

2014-08-30 Thread Bé Trần Văn
B2 select and click the Filter button to filter, Type in C2 or D2 and click the Filter button to filter. 2014-08-30 19:20 GMT+07:00 daya p princedaya2...@gmail.com: Hi Friends, I need help regarding filter data form with 3 combo box label 1st combo i select INDIA next if i select

Re: $$Excel-Macros$$ Filter Issue

2014-08-15 Thread Bé Trần Văn
*To:* excel-macros@googlegroups.com *Sent:* Thursday, August 14, 2014 10:37 AM *Subject:* $$Excel-Macros$$ Filter Issue Hi Guys, PSA. What I am ultimately looking for is a formula that would automatically return all the information based on three different criterias. In cell K1

Re: $$Excel-Macros$$ Filter Issue

2014-08-14 Thread Paul Schreiner
the people you can, As long as ever you can.” - John Wesley - From: Bill Q ronsmith...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, August 14, 2014 10:37 AM Subject: $$Excel-Macros$$ Filter Issue Hi Guys

Re: $$Excel-Macros$$ Filter on name in all sheet than paste in Master sheet

2014-08-12 Thread Paul Schreiner
Sachdeva shivanisachdeva...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, August 12, 2014 2:12 AM Subject: Re: $$Excel-Macros$$ Filter on name in all sheet than paste in Master sheet Hello friends, I am very happy that all user have very helping nature, Sorry I did not explain all

Re: $$Excel-Macros$$ Filter on name in all sheet than paste in Master sheet

2014-08-12 Thread Ashish Kumar
Check This !! Regards Ashish -- 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

Re: $$Excel-Macros$$ Filter on name in all sheet than paste in Master sheet

2014-08-11 Thread Satendra kumar
Hi, Use this ?? Sub Collect_Data1() Dim fld As Folder Dim fl As File Dim k As Long Dim wkb As Workbook Dim i As Long Dim fso As New FileSystemObject Set fld = fso.GetFolder(C:\Users\satendra.kumar\Downloads\New folder\New folder) With Application .DisplayAlerts = False .Calculation =

Re: $$Excel-Macros$$ Filter but exlude bad results script help!

2014-07-14 Thread Anoop K Sharma
Here you go.. On Fri, Jul 11, 2014 at 10:04 PM, Matt Painter mattr11...@gmail.com wrote: I pull data from a site called NDRIN.com its nd's land data base that i work off. Now i have a script that filters the results when i searchwhich is great.. but these admins dont enter the stuff

$$Excel-Macros$$ Filter Issue with Dates

2013-12-03 Thread Chandra Shekar
Hello, Am trying filter data by date range suppose if date as two different months(30/11/2013 - 01/12/2013) data is not getting filtered out. Could you please let me know what is the issue in the code. Thanks in advance. Regards, Chandru -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

$$Excel-Macros$$ Filter Data of Bold letter

2013-09-11 Thread Ashish Bhalara
Dear experts, I have a data columnar and want filter only bold letter data, is it possible, if yes please tell me how it done. Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you

Re: $$Excel-Macros$$ Filter Data of Bold letter

2013-09-11 Thread अनिल नारायण गवली
Dear Ashish, Pl share the workbook with us. Warm Regards, Gawli Anil. Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Sep 11, 2013 at 1:20 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I have a data columnar and want

Re: $$Excel-Macros$$ Filter Data of Bold letter

2013-09-11 Thread xlstime
Hi, Please read below link http://support.microsoft.com/kb/213923 . Enjoy Team XLS On Wed, Sep 11, 2013 at 1:20 PM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Dear experts, I have a data columnar and want filter only bold letter data, is it possible, if yes

Re: $$Excel-Macros$$ Filter Data of Bold letter

2013-09-11 Thread अनिल नारायण गवली
Dear Ashish, Pl see the attached workbook. Is it ok? Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Sep 11, 2013 at 2:11 PM, अनिल नारायण गवली gawlianil8...@gmail.com wrote: Dear Ashish, Pl share the workbook with

Re: $$Excel-Macros$$ Filter Data of Bold letter

2013-09-11 Thread Prafull Jadhav
Dear Anil and Xlstime Sir, can we use below method? Sub prafull() For Each x In Range(G2:G139) If x.Font.Bold = True Then x.Offset(0, 1).Value = 1 End If Next x End Sub On Wed, Sep 11, 2013 at 2:23 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear Ashish, Pl see the attached

Re: $$Excel-Macros$$ Filter Data of Bold letter

2013-09-11 Thread Ashish Bhalara
Thanks Mr.Anil others I got it. On Wed, Sep 11, 2013 at 5:36 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear Anil and Xlstime Sir, can we use below method? Sub prafull() For Each x In Range(G2:G139) If x.Font.Bold = True Then x.Offset(0, 1).Value = 1 End If Next x End Sub

$$Excel-Macros$$ Filter to work in tandem

2013-07-18 Thread Eugene Bernard
I have two excel workbooks in open condition. If I filter a value of one particular column in first workbook, i need the same filter condition should get applied to the other open worksheet also. How to achieve this. Please share me the macro or codes. Thanks Eugene -- Are you =EXP(E:RT) or

$$Excel-Macros$$ Filter on Row to hide column

2013-05-10 Thread Amit Desai (MERU)
Dear Friends, Please help. I need a macro or any other solution to put a filter in a row number 3 of the attached file. I have few columns as Wk 1, Wk 2, Wk 3 Month (with other columns). I wants to see all the columns with column head as say Wk 1 in row 3. Attached is the sample file. Best

Re: $$Excel-Macros$$ Filter on Row to hide column

2013-05-10 Thread David Grugeon
You cannot filter horizontally. You could have a macro to hide all columns from column d onwards which were not Week1, if that is what you want. Regards David Grugeon On 10 May 2013 16:28, Amit Desai (MERU) amit.de...@merucabs.com wrote: Dear Friends, ** ** Please help. ** **

RE: $$Excel-Macros$$ Filter on Row to hide column

2013-05-10 Thread Amit Desai (MERU)
2013 12:30 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Filter on Row to hide column You cannot filter horizontally. You could have a macro to hide all columns from column d onwards which were not Week1, if that is what you want. Regards David Grugeon On 10 May 2013 16:28, Amit

RE: $$Excel-Macros$$ Filter on Row to hide column

2013-05-10 Thread Amit Desai (MERU)
: $$Excel-Macros$$ Filter on Row to hide column Dear Amit, Pl see the attachment. Warm Regards, Gawli Anil On Fri, May 10, 2013 at 12:32 PM, Amit Desai (MERU) amit.de...@merucabs.commailto:amit.de...@merucabs.com wrote: I am okay to have a macro too.. but in that case it should provide me solution

RE: $$Excel-Macros$$ Filter based on coulmns

2013-04-28 Thread Amit Desai (MERU)
@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 27 April 2013 18:34 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Filter based on coulmns So... you're saying copy/paste traspose isn't an option and you want a macro. do you know anything

RE: $$Excel-Macros$$ Filter based on coulmns

2013-04-27 Thread Amit Desai (MERU)
You are right. Can you please suggest some macro for that? Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 26 April 2013 17:17 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Filter based

Re: $$Excel-Macros$$ Filter based on coulmns

2013-04-27 Thread Paul Schreiner
- From: Amit Desai (MERU) amit.de...@merucabs.com To: excel-macros@googlegroups.com Sent: Sat, April 27, 2013 4:34:49 AM Subject: RE: $$Excel-Macros$$ Filter based on coulmns You are right.   Can you please suggest some macro for that?   Best Regards, Amit Desai   From:excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Filter based on coulmns

2013-04-26 Thread Amit Desai (MERU)
Can someone please answer? Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Amit Desai (MERU) Sent: 22 April 2013 18:15 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Filter based on coulmns Dear Friends, In general

Re: $$Excel-Macros$$ Filter based on coulmns

2013-04-26 Thread Paul Schreiner
- From: Amit Desai (MERU) amit.de...@merucabs.com To: excel-macros@googlegroups.com Sent: Fri, April 26, 2013 7:11:12 AM Subject: RE: $$Excel-Macros$$ Filter based on coulmns Can someone please answer?   Best Regards, Amit Desai   From:excel-macros@googlegroups.com [mailto:excel

$$Excel-Macros$$ Filter based on coulmns

2013-04-22 Thread Amit Desai (MERU)
Dear Friends, In general we filter data based on the contents in rows. I would like to know if we have any options to filter data columns. Could you please help. Best Regards, Amit Desai Disclaimer: This message and its attachments contain confidential

Re: $$Excel-Macros$$ Filter Data based on Criteria

2013-04-11 Thread C.G.Kumar
The macro provided does not serve the purpose. It does not filter data based on condition provided in row 1:2. The data needs to filtered on the same place and not on different location. Output given in sample sheet was only for checking the results . I hope you can modify the results .:) On

$$Excel-Macros$$ Filter Data based on Criteria

2013-04-10 Thread C.G.Kumar
Hi, I need to filter a long list in excel based on criteria (Cell Values). I can do it manually by selecting filter and then selecting manually each criteria like Name = Adag, Amount 5000 and so on . Is there any way where the list get auto filtered based on criteria mentioned at the top of

Re: $$Excel-Macros$$ Filter Data based on Criteria

2013-04-10 Thread Chaya
Dear Kumar, Please find the attachment. Might it will help you. Just select the item code from the A2 (cell) drop down and click on the button (filter). Regards, Chaya On Wed, Apr 10, 2013 at 1:58 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Hi, I need to filter a

Re: $$Excel-Macros$$ Filter Data based on Criteria

2013-04-10 Thread xlstime
Hi CG, Please try to use Advance filter and macro recording.PFA . Enjoy Team XLS On Wed, Apr 10, 2013 at 1:58 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Hi, I need to filter a long list in excel based on criteria (Cell Values). I can do it manually by

$$Excel-Macros$$ Filter

2012-01-02 Thread Aamir Shahzad
How to use the auto filter for only Text. How to use the auto filter for only Numbers -- Regards, Aamir Shahzad -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

Re: $$Excel-Macros$$ Filter

2012-01-02 Thread NOORAIN ANSARI
Dear Aamir, Please see attached sheet... -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Mon, Jan 2, 2012 at 11:09 PM, Aamir Shahzad

Re: $$Excel-Macros$$ filter out the cells with a particular formula

2011-08-19 Thread dguillett1
: $$Excel-Macros$$ filter out the cells with a particular formula see if it helps On Fri, Aug 19, 2011 at 6:24 AM, Sara Lee lee.sar...@gmail.com wrote: hi how do i filter out those cells in a column which has a particular vlookup formula in them... for example in one column in a table, i have

RE: $$Excel-Macros$$ filter out the cells with a particular formula

2011-08-19 Thread Rajan_Verma
= True End If Next Application.ScreenUpdating = True End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sara L Sent: Friday, August 19, 2011 6:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ filter out the cells

$$Excel-Macros$$ filter out the cells with a particular formula

2011-08-18 Thread Sara Lee
hi how do i filter out those cells in a column which has a particular vlookup formula in them... for example in one column in a table, i have vlook up fomula set up for the entire column ... some of the cells have vlook up( with true parameter) and some with (false parameter) How do i filter

Re: $$Excel-Macros$$ filter out the cells with a particular formula

2011-08-18 Thread ashish koul
see if it helps On Fri, Aug 19, 2011 at 6:24 AM, Sara Lee lee.sar...@gmail.com wrote: hi how do i filter out those cells in a column which has a particular vlookup formula in them... for example in one column in a table, i have vlook up fomula set up for the entire column ... some of the

Re: $$Excel-Macros$$ filter out the cells with a particular formula

2011-08-18 Thread Sara Lee
Thanks Ashish... but how do i filter out column I such that i extract values similar to a ( which use 0) and not b. Say suppose column I has 2cell records ... ? On Thu, Aug 18, 2011 at 9:05 PM, ashish koul koul.ash...@gmail.com wrote: see if it helps On Fri, Aug 19, 2011 at 6:24 AM, Sara

Re: $$Excel-Macros$$ filter out the cells with a particular formula

2011-08-18 Thread ashish koul
lets suppose col i is having formula type in j2 = checkpar(I2) then apply fill down use flliter and choose You have choosed 0 in j it will show all the cells with paramter 0 in col i. On Fri, Aug 19, 2011 at 7:06 AM, Sara Lee lee.sar...@gmail.com wrote: Thanks Ashish... but how do i

$$Excel-Macros$$ filter of nonblank cell

2011-07-25 Thread vickey
Is thereany way to filter / copy nonblank values toanother sheet. considering followng example. ID NAME 1 2 BBB 3 CCC 4 5 6 7 DDD 8 FFF 9 EE ID NAME 1 2 BBB 3 CCC 7 DDD 8 FFF 9 EE thanks in

RE: $$Excel-Macros$$ filter of nonblank cell

2011-07-25 Thread Rajan_Verma
(Data).Range(A Sheets(Data).Range(A65536).End(xlUp).Row + 1) Next End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vickey Sent: Monday, July 25, 2011 7:42 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros

Re: $$Excel-Macros$$ filter of nonblank cell

2011-07-25 Thread vickey
[mailto:excel-macros@googlegroups.com] On Behalf Of vickey Sent: Monday, July 25, 2011 7:42 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ filter of nonblank cell Is thereany way to filter / copy nonblank values toanother sheet. considering followng example. ID      NAME 1      

RE: $$Excel-Macros$$ filter of nonblank cell

2011-07-25 Thread Rajan_Verma
[mailto:excel-macros@googlegroups.com] On Behalf Of vickey Sent: Monday, July 25, 2011 8:13 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ filter of nonblank cell thanks but nonblank data is not being copied in data sheet. On Jul 25, 7:29 pm, Rajan_Verma rajanverma1...@gmail.com wrote

Re: $$Excel-Macros$$ filter of nonblank cell

2011-07-25 Thread Mahesh parab
Hi find attach as per your requirement. try : Sub test() Sheet1.UsedRange.Copy Sheet2.Select Sheet2.Range(A1).PasteSpecial Paste:=xlPasteValues On Error Resume Next Columns(B).SpecialCells(xlCellTypeBlanks).Select Selection.EntireRow.Delete On Error GoTo 0 End Sub On Mon, Jul 25, 2011 at 7:42

Re: $$Excel-Macros$$ filter of nonblank cell

2011-07-25 Thread XLS S
use filter and select non blank then select data press alt+; then copy and paste On Mon, Jul 25, 2011 at 7:42 PM, vickey vikasda...@gmail.com wrote: Is thereany way to filter / copy nonblank values toanother sheet. considering followng example. ID NAME 1 2 BBB 3

$$Excel-Macros$$ Filter rows based on a list of values

2010-12-23 Thread Hole
Hi there, I need to filter rows in a sheet based on a columns matching a list of values. I've tried to play advanced filter but it doesn't seem to fit my needs... Any idea? Many thanks in advance anyway!!! -- --

Re: $$Excel-Macros$$ Filter Issue

2010-12-17 Thread Chandra Shekar
Hi, Is this code for my problem. Please let me know. Thanks Chandra Shekar On Fri, Dec 17, 2010 at 7:49 AM, ashish koul koul.ash...@gmail.com wrote: try this code Sub filterdata() Application.DisplayAlerts = False Dim i, j As Long For i = 2 To 6 Sheets(Sheets(1).Cells(i, 1).Text).Select

$$Excel-Macros$$ Filter Issue

2010-12-16 Thread Chandra Shekar
Hello, I have attached sample workbook I need a macro to do this task. In *Sheet1*I got Input Data based on *column A* I need to separate worksheets as shown in workbook. Thank you. Chandra Shekar -- -- Some

Re: $$Excel-Macros$$ Filter criteria of one row - show previous row...

2010-10-26 Thread NOORAIN ANSARI
Dear Robert, Please provide sample sheet...if possible.. Thanks regards, Noorain Ansari On Mon, Oct 25, 2010 at 9:42 AM, Robert Jacobs robertjacob...@gmail.comwrote: Thanks in advance to the expert that can help me I have an excel document with thousands of records, each record has a

$$Excel-Macros$$ Filter criteria of one row - show previous row...

2010-10-25 Thread Robert Jacobs
Thanks in advance to the expert that can help me I have an excel document with thousands of records, each record has a message associated with it that is listed on the row beneath that record... i.e. Record -SPR Office_Loc 123456 FS_FTW 234567 Message

$$Excel-Macros$$ Filter Query

2010-05-01 Thread karthikeyan
Hi All, I have create a filter through macro.Crietiria=100,Filed=3 Example:- col-A col-B col-C NameId Amt X 1 100 Y 2 200 Z

Re: $$Excel-Macros$$ Filter Query

2010-05-01 Thread Mahesh parab
Hi karthikeyan Before you adding the column code Field:=3, Criteria1:==100 it will filter Column C where Amount it equal to 100 but when you add the column between A B your Amount column will shift to column D this time code will be Field:=4, Criteria1:==100 On Sat, May 1, 2010 at 1:21 PM,

Re: $$Excel-Macros$$ FILTER

2010-04-11 Thread Ayush
Hi Vinod, It is very simple. Just select the 1st range and apply the filter and same for 2nd range. Please let me know if you have more questions. Best regards, Ayush Jain Group Manager On Apr 11, 10:16 am, vinod rao vinod.ma...@gmail.com wrote: Hi Vikas, How did you do this?. Regards Vin

Re: $$Excel-Macros$$ FILTER

2010-04-11 Thread vinod rao
Hi Ayush, I could put filter to one selected range and later when i want to put to other range the 1filter disappeared. Note that i am using 2003. Regards, Vin On Sun, Apr 11, 2010 at 11:37 AM, Ayush jainayus...@gmail.com wrote: Hi Vinod, It is very simple. Just select the 1st range and

Re: $$Excel-Macros$$ FILTER

2010-04-11 Thread Ayush
Hi Vinod, There is no workaround to filter twice in one spreadsheet in Excel 2003. Also,In Excel 2007, you will have to use Format as table style to apply filter to selected range. To use Format as Table, Just select the range and apply any table format from the dropdown and it will

Re: $$Excel-Macros$$ FILTER

2010-04-11 Thread Ayush
in xl2007. Weird. Regards - Dave. Date: Sat, 10 Apr 2010 23:52:13 -0700 Subject: Re: $$Excel-Macros$$ FILTER From: jainayus...@gmail.com To: excel-macros@googlegroups.com Hi Vinod, There is no workaround to filter twice in one spreadsheet in Excel 2003. Also,In Excel 2007, you

RE: $$Excel-Macros$$ FILTER

2010-04-11 Thread Dave Bonallack
Agreed. _ View photos of singles in your area! Looking for a hot date? http://clk.atdmt.com/NMN/go/150855801/direct/01/ --

Re: $$Excel-Macros$$ FILTER

2010-04-10 Thread vinod rao
Hi Vikas, How did you do this?. Regards Vin On Wed, Apr 7, 2010 at 7:00 PM, Vikas Chouhan vikask...@gmail.com wrote: Hi, Go format as table, On Wed, Apr 7, 2010 at 6:23 PM, Jai jaihumtu...@gmail.com wrote: Dear All Members. How can put the filter 2 times in One Excel file . --

$$Excel-Macros$$ FILTER

2010-04-07 Thread Jai
Dear All Members. How can put the filter 2 times in One Excel file . -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ FILTER

2010-04-07 Thread Vikas Chouhan
Hi, Go format as table, On Wed, Apr 7, 2010 at 6:23 PM, Jai jaihumtu...@gmail.com wrote: Dear All Members. How can put the filter 2 times in One Excel file . -- Thanks For Mail. -- -- Some important

$$Excel-Macros$$ filter print to PDF (or similar)

2010-03-29 Thread holt
I hope that this request is posted in the correct group and someone can assist. A simple spreadsheet with 2 worksheets. The first is a predetermined list of 100 members names whilst the second contains a number of columns containing various pieces of information relating to the members. For

Re: $$Excel-Macros$$ FILTER IN EXCEL

2009-11-23 Thread Aindril De
Dear Sunil, You can use the following UDF: This Custom Function can be used to highlight them. Enter the following code in a standard module. (Alt + F11, then Insert, Module from the top menu) Function FilterOn(myCell As Range) As Boolean On Error Resume Next With

Re: $$Excel-Macros$$ FILTER IN EXCEL

2009-11-23 Thread Abhishek Jain
Hi Sunil, Attached file might help. I found it on net. Cheers to the original programmer. Best regards, AJ On Sat, Nov 21, 2009 at 2:27 PM, SSG sunilsga...@gmail.com wrote: Sir, Many times, it happens that we apply a filter on one or more columns. During the course of our handling and

$$Excel-Macros$$ FILTER IN EXCEL

2009-11-22 Thread SSG
Sir, Many times, it happens that we apply a filter on one or more columns. During the course of our handling and scrolling left-to-right or otherwise, we often forget which columns have been filtered. Is there a good and efficient and clear way of telling or highlighting FILTER columns, e.g., if

$$Excel-Macros$$ Filter by variable date range

2009-11-14 Thread Mahesh Fernando
Hi I need to create a macro when i put the start date and end date on a particular Cell for the macro to filter the data only to be between those two dates. The concern is the fact that The coding i did do not pick the variable dates Sub DateFilter() ' ' Filter Macro ' ' Dim StartDate As Date

Re: $$Excel-Macros$$ Filter by variable date range

2009-11-14 Thread Ayush Jain
/09, Mahesh Fernando maxfort...@gmail.com wrote: From: Mahesh Fernando maxfort...@gmail.com Subject: $$Excel-Macros$$ Filter by variable date range To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Date: Saturday, 14 November, 2009, 9:29 PM Hi I need to create a macro when i put the start

$$Excel-Macros$$ Filter Pivots

2009-04-22 Thread Prashanth Banneni
Hi All, I have an issue with the pivot tables filter, as i need to change the filter in as many as 10 sheets(20 pivot tables) to get the correct values. Is there any way where i filter it in one page and the remaining pivots change accordingly. Appriciate an early solution from you. Thanks in

$$Excel-Macros$$ FILTER COMMAND

2008-12-02 Thread Mattathil M. Pradeep
Dears.. Can we use 2 filter in single sheet. Attached excel sheet for your reference. Thanks and Regards Pradeep --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to