I know that I had previously found a solution to this, but seem to hav
lost it (human memory failure). We export reports from Crystal int
Excel for manipulation. The reports have groupings or subgrouping
that end up not having data in each cell under the grouping header. T
slice and dice the info, we need to "fill down" the data in one row
all the way down till where the next cell contains data, and then cop
the cell with data and fill down all the blanks till the next fille
cell and so on. I found one macro, but it only did it for a specifie
Column and each time you run it you have to change the macro to specif
the number of rows to be changed. It works, but I know there was
better solution that I just cannot reconstruct.

Any help would be appreciated

--
Message posted from http://www.ExcelForum.com