thisisthenameofanewworkbook.xlsb",
>
> _
> FileFormat:=xlExcel12, _
> CreateBackup:=False
> Workbooks("thisisthenameofanewworkbook.xlsb").Close
>
> End Sub
>
> I hope this helps.
>
> *Paul*
>
>
> -
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
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
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
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)
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
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
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
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
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
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
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
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
At E2 (sheet Advanced Filter), Select =113 300 or =10
To get results.
2014-08-14 22:12 GMT+07:00 Paul Schreiner schreiner_p...@att.net:
I don't believe you can do it with a FORMULA.
But you can do it with a Change Event macro.
You would create an autoFilter for rows 5-###
Then,
I don't believe you can do it with a FORMULA.
But you can do it with a Change Event macro.
You would create an autoFilter for rows 5-###
Then, record a macro in which you filter based on your two criteria
( 113000, 10)
In your change event, check the value of Cell K1.
and execute
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
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
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 =
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
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
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
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
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
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
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.
** **
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
Sent: 10 May 2013 12:30
To: excel-macros@googlegroups.commailto: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
@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
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
-
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
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
-
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
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
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
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
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
: $$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
Try this
Sub Filter()
Application.ScreenUpdating = False
On Error Resume Next
Dim Rec As Double
Dim rng As Range
Set rng = Selection
Rec = Range(A6).End(xlUp).Row
For i = 1 To Rec
If InStr(rng.Cells(i, 1).Formula, Range(C1).Value) Then
rng.Cells(i, 0).EntireRow.Hidden
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
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
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
Try This
Sub CopyNonBlankRow()
On Error Resume Next
Dim cell As Range
Dim rng As Range
Set rng = ActiveSheet.Range(B2:B ActiveSheet.UsedRange.Rows.Count)
Sheets(Data).Delete
Sheets.Add.Name = Data
For Each cell In rng
If cell.Value Then cell.EntireRow.Copy
thanks but nonblank data is not being copied in data sheet.
On Jul 25, 7:29 pm, Rajan_Verma rajanverma1...@gmail.com wrote:
Try This
Sub CopyNonBlankRow()
On Error Resume Next
Dim cell As Range
Dim rng As Range
Set rng = ActiveSheet.Range(B2:B ActiveSheet.UsedRange.Rows.Count)
[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
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
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
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
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
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,
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
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
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
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
Agreed.
_
View photos of singles in your area! Looking for a hot date?
http://clk.atdmt.com/NMN/go/150855801/direct/01/
--
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 .
--
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
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
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
Dear Mahesh,
Please use below codeIt should work now..You should also use
operators with your code. Let me know if further help is required.
Sub DateFilter()
'
' Filter Macro
'
'
Dim StartDate As Date
Dim EndDate As Date
StartDate = Worksheets(Cover Page).Range(A4)
EndDate =
59 matches
Mail list logo