Help Refreshing table filters when updating a value

[chichaspowa]

Hello once again, and thank you all so much for the great help u have supplied me with.

I need a little help on something that possibly very simple for you.

I have a worksheet where i input data and have a table on another sheet with vlookup formulas, updating everytime i input something on the inicial sheet.

What happens is that i hide the #N/A error so that it doesnt come up with a whole lot of results, and when i input something new again i have to go remove the filters manually and again filter the #N/A to view the new result on the table.

Can someone help me with some code to automatically do this process. I would kindly apreciate it and be forever greatful. Thanks :)

[lynnnow]

Can you provide a sample workbook?

It may be solved with just the use of a function than writing code.

[Bob Phillips]

Use the worksheet change event to trap the input and if it generates #N/A then reset the autofilter.

[chichaspowa]

im gonna post a jpeg so u know exactly what im looking for there.

I want that last column (Column S) to have the #N/A and 0 values filtered, and everytime i input info on the other sheet it automatically updates.

I think i would have to write some kind of code on that particular sheet. Would u guys help me out please.

[Bob Phillips]

My previous answer still applies, the picture helped not at all.

[lynnnow]

xld, you sounded like Yoda here, :)