My workbook has data entry "sections", each section is 10 rows deep. I start
by making one section with all the needed entry spaces and formulas and then
create 499 duplicate sections by highlighting the first section (10 rows
worth) and then dragging down - using the box in the corner - to create 499
more copies of my first section. I want to use comments to help guide the
users through each section's entries, however the comments in the first
section won't copy down with my duplicate sections after I do the drag-copy
feature. Is there a solution to keep me from having to select each cell in
my 500 data entry sections and doing a paste special?