Hello, I hope you can help me. I have a workbook that has many worksheets, one worksheet I'll call it SOLD is pulling needed information from the other worksheets. In the SOLD worksheet I have a column for the date sold and this worksheet using the auto filter. I want it to only show those non-blank rows and update automatically when I update information from the other worksheets. The information on all the sheets are updated all day long but when I go to the sold sheet it isn't updating using this filter and therefore hides the information unless I select the auto filter button, then select all, then select non-blanks again. Is there a way to have it auto apply and show the new information without having to go through this because I just plain forget at times to go the extra steps?

Thank you, hope this will help me and others.
Diva