Advance filter based on Criteria ....

[prakash24]

Need a Macro for Filter data for full flat rows. Each flat has 5 rows ...normal filter giving only one row for each flat ....is there any VBA solution for this Please???

Please find the attachment....

thank you..

[Mumps1]

I believe the problem is being caused by the merged cells that you are using. If you unmerge the cells and enter the data in each unmerged row, the filter should work properly. You should avoid using merged cells as they always give Excel problems when using macros.

[prakash24]

I believe the problem is being caused by the merged cells that you are using. If you unmerge the cells and enter the data in each unmerged row, the filter should work properly. You should avoid using merged cells as they always give Excel problems when using macros.

Yes You're right , is their any way to make a group of 5 rows each, and when I filter through normal filter, the filter should come in group...I tried it but didin't worked for me ..

[Mumps1]

You would have to unmerge the cells and then fill in the empty cells with duplicate data in each column. For example, after you unmerge A2:A5, you would have to enter 101 in rows 3 to 5. You would have to do this for all the unmerged cells.

[prakash24]

NO, I can't unmerge rows I have other things running around also ...

[Mumps1]

In that case, I believe that the filter won't work properly.

[Mumps1]

Click this link and follow the instructions: http://unlockedexcel.blogspot.ca/201...d-data-if.html

It is a very interesting work-around for you problem. I tried it and it works.

[Mumps1]

Attached is your file after I went through all the steps. You would have to check if there are any adjustments you may have to make.

[prakash24]

thanks Mumps1 ,can it be done through VBA?????? As I have more than 1000 number of data formatted in same way ....

[Mumps1]

If there is a way, unfortunately I'm not aware of it.