I have a long worksheet (34000+ rows) in which I have grouped data by a stock
number. In the column following the stock number is the name of the item to
which the stock number refers. When I subtotal the worksheet and go to level
two (subtotals only), the name disappears. It's easy enough to create a
formula to copy the item name from the row above the subtotal; but then, is
there an easy way to copy that formula to each of the subtotal rows (about
8000-10000) without having to paste to each cell individually? I tried
pasting to the entire column, but that causes the formula to be posted to the
hidden cells as well, and results in the same item name being in every cell
in the column.