By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,757 Members | 1,990 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,757 IT Pros & Developers. It's quick & easy.

Excel - filter row instead of column

P: 1
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
Share this Question
Share on Google+
2 Replies


kadghar
Expert 100+
P: 1,295
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

Expert 5K+
P: 8,434
Sorry shik, I've deleted your post. TheScripts is an English-only forum.
Jan 27 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.