Hi-
I have a database full of different tables on each worksheet. On each table, I input test scores and then run my macro. The test scores go to the last worksheet labeled 'data'. My problem is when I leave a test blank on the table (when there is no score for that specific test), a zero appears under that test in 'data'. I tried turning off zero value, but that got rid of every zero, even the ones that actually represent a test score. To make a long story short, I need blank cells to stay blank and cells with zeros to stay zero. If anyone can help me, it would be much appreciated!
-Jessica