Hello,
Someone asked me for help. I wonder if it's possible. When it's possible and someone helps me with the right code I'll raise the amount op points.
We have a macro initilising a autofil...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_203...
I have a filter within Excel to return a desired subset of data from a larger set of data. Within VB, I want to work with only those that are visible as a result of the filter. I've included a samp...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20448075.html
Zones:
Visual BasicDate Answered: 01/08/2003 Grade: A Views: 0
I have a spreadsheet full of data and have manged to 'autofilter' the required data in my VBA code. However, I have not managed to master the 'step to next row' bit in the VBA code. Any suggestions...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_21022880.html
Zones:
Visual BasicDate Answered: 07/22/2004 Grade: B Views: 0
I have a macro that should take all of the data on sheet DLOAD add an autofilter to it then move it to the various sheets depending the 6 types of criteria that will appear in column A. For some r...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 09/09/2004 Grade: A Views: 0
I have an autofilter above the first row of some data that I have. I would like to use VBA to loop through the items in the first column of the autofilter and print a page for each entry. The dat...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/02/2004 Grade: A Views: 0
Hi
Is there VB Code where a message box appears to select the criteria on the autofilter.
Thanks
Denis
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/07/2004 Grade: A Views: 0
I need to modify the following Autofilter code such that it takes a variable "y" in place of 30. Any help?
Selection.AutoFilter Field:=30, Criteria1:="<>USD", Operator:=xlAnd 'y is the curre...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/27/2004 Grade: A Views: 0
Hi,
How do you get autofilter onto 3 different columns that are not side by side, I cannot seem to do the autofilter on each column individually because whenever i add autofilter onto one column, ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 11/02/2004 Grade: A Views: 0
I have a user who is putting together a spreadsheet.
They have a worksheet with a lot of data. The column headings have an autofilter applied to them. The resulting data is then used to create a...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 11/21/2004 Grade: A Views: 0
Hi there -
I have a sheet with about 200 columns that has the Autofilter turned on.
I would like to divide the columns into two worksheets and use the first sheet to filter BOTH sheets.
(che...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 04/20/2005 Grade: A Views: 0
