PDA

View Full Version : Help Refreshing table filters when updating a value



chichaspowa
10-27-2010, 05:19 PM
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
10-27-2010, 08:53 PM
Can you provide a sample workbook?

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

Bob Phillips
10-28-2010, 12:11 AM
Use the worksheet change event to trap the input and if it generates #N/A then reset the autofilter.

chichaspowa
10-28-2010, 12:27 PM
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
10-29-2010, 03:25 AM
My previous answer still applies, the picture helped not at all.

lynnnow
10-29-2010, 03:30 AM
xld, you sounded like Yoda here, :)