View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Donna Donna is offline
external usenet poster
 
Posts: 180
Default Filling an empty row with the data in row above it

I have a spreadsheet that is about 12,000 rows deep, with about 1000 rows
that are blank, basically blank rows to show a data change, I don't want to
delete the row but fill it with the data that is directly above it. Is there
an easy way to do this. Or does someone have a macro?