Excel - filter row instead of column - Visual Basic 4 / 5 / 6

Hi!!

After reading all the advanced programming questions that people in this forum had made, I feel embarrased of asking this... anyway I know anybody here can easily help me... thanks in advance...

In excell files I know how to filter in a column the cells that contain certain word, but I would like to know if I could use the same filter for a row.

I hope somebody can help me. Thanks!!

Jan 24 '08 #1

Subscribe Post Reply

10279

kadghar

1,295

Expert 1GB

Hi!!

After reading all the advanced programming questions that people in this forum had made, I feel embarrased of asking this... anyway I know anybody here can easily help me... thanks in advance...

In excell files I know how to filter in a column the cells that contain certain word, but I would like to know if I could use the same filter for a row.

I hope somebody can help me. Thanks!!

Well this is not exactly an Excel Forum, but I think it can be done using VBA.
Talking about Excel, I don't know if that's possible. I've never seen it before. But it doesn't seem like a big problem.

What I recommend you is to create 2 subs, one will select the range and store it in a global array. To make it look "professional" it can replace the first column with some ComboBoxes.

The second sub will be the one that cleans the range and returns the filtered one, asking the parameters to the cells related to the combo boxes.

HTH

Jan 25 '08 #2

Killer42

8,435

Expert 8TB

Sorry shik, I've deleted your post. TheScripts is an English-only forum.

Jan 27 '08 #3

Similar topics

from HTML to Excel

by: v_verno | last post by:

Good day, I have a web page that shows info retrieved from a MySQL db and I would like to convert all these data into an .XLS file. Have searched the net high and low but seems that I'm unable to...

Javascript

Creating Excel document from Dataset and XML ?

by: Paul | last post by:

Hi all Arggghhh........... The problem.....I want the user to be able to create an excel document and name particular cells in the document where they want the data to be placed and then save...

.NET Framework

Filter a report based on same filter on a form

by: Richard | last post by:

Hi, I have a form based on a table. When I filter the form I want to run a report based on the same table with the same filter as the form. No problem until I want to filter a combo box where...

Microsoft Access / VBA

gridview paging weirdness +excel output

by: Andrew Nav | last post by:

I dragged a table from a datasource on to my web form and the GridView cpntrol was created. I turned on paging, and Edit and Delete buttons. I ran the app and everything worked great - not a...

ASP.NET

Is there a way to open a *FILTERED* recordset on an excel file ?

by: Radu | last post by:

Hi, I have the following problem: I open a recordset based on excel/csv files, but then I need to filter (in code) in order to extract only data pertaining to a specific person. This code is...

Microsoft Access / VBA

Data Set to Excel ?

by: Rob | last post by:

Is there an easy (and fast) way to transfer the contents of a dataset to Excel (without using the Excel object ) ?

Visual Basic .NET

255 Character Limit for Linked Excel data

by: Grip | last post by:

Hi, I have gone throught the group and Microsoft's online help and have seen many suggestions but I am still seeking clarity: 1. I have an excel spreadsheet. Column A contains text that may...

Microsoft Access / VBA

Excel Import - having difficulties

by: RazSam | last post by:

Hi I am developing in c# .net 2,0 web forms and having some problems. Code is attached below. I have written code to export the contents of a Grid View to Excel, this works. The problem occurs...

.NET Framework

Get Last Column & Row of Data in Excel Worksheet

by: DThreadgill | last post by:

Hi all - having a bit of problem with this code. It works in one of the databases that I have but not the one I'm currently working with...I've compared references and they're both the same: When...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General