I have a macro that was rud fine until data was added to one of the tabs. The
data was added to data that was already on the data, at the bottom. The
proble we are having now is that the macro is not seeing these data and even
when we run the auto filter on one of the columns in the tab. There are
significant number of data that is not showing up in the dropdown auto filter
list.
Last time, someone suggested to check and make sure that the list doesn't
contain any blank cell. I found one and we added date in it but that didn't
fix the problem. Does anyone know what might be going on here. I am
completely stompped.
Please help