Fill in blank rows [Closed]

Report
Posts
1
Registration date
Monday January 25, 2016
Status
Member
Last seen
January 25, 2016
-
Is there any formula or Macro that I can use to fill in blank rows from the last cell above that has data in it. For example, I have a spreadsheet with over 40,000 rows andthere are many filled in but there could be anywhere from 1 to 20 blank rows before i get to the next filled row. Is there any way that I can automatically look for the last row with data and copy that for the next several blanks?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!