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
JsiPxi wrote:
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?
--
Dave Peterson