Remove the merged cells and put the value in each row???
If you want to try, then visit Debra Dalgleish's site for a way to fill empty
cells from the value in the cell above.
http://contextures.com/xlDataEntry02.html
> Because I have merged some cells over 2 rows, when I try and autofilter them,
> only half the row of data comes up. How can I stop this from happening?

Signature
Dave Peterson