Advanced filter - modifying formulae

Hey,

thanks for helping.

Currently this code filters value of only one cell which is cell "Y2"

Please Login or Register  to view this content.

Now i want to filter the data based on multiple criteria .


so now can i modify this code to filter the sheet based on cell values in cells "X2" "Y2","Z","AA,"AB,"AC"

example:

i want to filter the sheet with the following data

"X2" contains - ""Bazar"
"Y2" contains - "Ranjana"
"Z2" contains - "Y"
"AA" contains - "8000"

Now i want to filter the sheet based on these cell values.



So far for me , the code works for singe criteria

Hey PCI,

not exactly.

i am going to add different customers to this list everyday.

So basically what i wanted was to filter the sheet by custom text.

so example:

i want to filter the sheet with the following data

"X2" contains - ""Bazar"
"Y2" contains - "Ranjana"
"Z2" contains - "Y"
"AA" contains - "8000"

Now i want to filter the sheet based on these cell values.

hey Richard.

Thank you so much. This code works perfectly .

Thank you .

Hey PCI,

Thank you so much.

This code works perfectly.

Hey PCI,
Hey Richard,


I was thinking of placing the range used for filter's Criteria right at the top so that it becomes easier.

In sheet "STOCK IN HAND" there is a code which filters data from sheet "PRODUCt"
Here is the code

Please Login or Register  to view this content.

The problem is that this code clears the sheet everytime . If i type anything in cell a1 on sheet "Stock in hand" and change sheet for a second, then again if i come back to this sheet then the data gets cleared automatically.


I was thinking of placing the range used for filter's Criteria right at the top of sheet "STOCK IN HAND"

I have modified the code but its not working

Please Login or Register  to view this content.

Hey guys ,

I got his code to filter the sheet based on cell value in range "X1:AA2"
Thanks to PCI and Richard for this code,

Please Login or Register  to view this content.

the problem is that when I type in the range "X1:AA2" , then it hides these ranges as well because it filters and displays the data from row 2 onwards.


Is there any way to display the filered results from row 4 onwards?

This will ensure that my range for filerting stays right at the top.

I have attached my workbook

Change the filter range to start from row 4 instead of row 1

Or see Richard's suggestion in post #11

Hey jason,

Thanks,

Did you mean to do this?

Please Login or Register  to view this content.

I tried this but it does not work.
after autofilter is activated, the results are displayed from row 2 onwards.
so it hides the filter range cell.

So in post 7 you can see that PCI had moved the filter range down.

Insert 2 blank rows at the top of the sheet, move the criteria up into those rows.

anilpatni1234, with over 160 posts to your name, you really should know better.

Rule 08: Cross-posting Without Telling Us

Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

No further help to be offered, please, until the OP has complied with this request.

Hey Richard,
this thread is solved.

you can refer here https://www.excelforum.com/excel-pro...m-row-4-a.html


Thank you so much for your constant support.

THANK YOU SO MUCH

You don't seem to understand the forum rules very well do you?

I already flagged your earlier thread as a duplicate and had it closed down by a moderator. Why would you think it acceptable to start another one?

hey jason,

I am really confused .

For this purpose i am marking this thread as solved.

The question you asked is a follow on from this thread so you should have kept it here, not started a new one.

Regardless of whether or not you have marked the original thread as solved, the new one is still a duplicate. There is nothing confusing about it.

Hey guys.
(THANKS TO MARC FOR THIS VBA CODE)
(THANKS TO PCI and RICHARD FOR MODIFYING THE CODE FOR ME)


I have this code to filter sheet "PRODUCT" based on column "IN STOCK"
If cell matches "INSTOCK" then it is copied to sheet "stock in hand"

Here is the code:

Please Login or Register  to view this content.

Now the problem is that the vba code clears the entire used range.
If it possible that to add an exception - to not clear upto row 6?

Because if i enter any data in row 1-6, then it autoclears it

hey guys,

I tried removing

Please Login or Register  to view this content.

from the aboove code . it does not work.

here is the code which i want to edit.

Please Login or Register  to view this content.

Now the problem is that the vba code clears the entire used range.
If it possible that to add an exception - to not clear upto row 6?

Because if i enter any data in row 1-6, then it autoclears it

Hey guys,

Anyone please help me.

I am unable to crack it

This question is now crossposted .

here is the link

https://www.mrexcel.com/forum/excel-...ml#post5110486

That is not the same thread number that you linked to in post #18.

Does that mean that you are breaking the duplicate thread rule on mrexcel as well?