Copy paste of first row

Welcome to the MrExcel board!

You didn't say if you were looking for a macro solution or a manual solution. Here is the outline of a manual solution. If you need a macro, try recording these steps for some starting code. If you cannot figure out the detailed steps to follow the instructions below, post back with which version of Excel you are using.

1. Select the data area including headings.

2. Apply AutoFilter.

3. Use the AutoFilter on the first column to show the '1' values.

4. Select all the way from the second '1' value down to the end of the visible data in the first column.

5. Use GoTo|Special to select 'Visible cells only'.

6. Set the AutoFilter back to show all rows.

7. Insert|Rows

8. Now use AutoFilter to filter the first column to 'Blanks'.

9. Copy the headings and select the visible blank area of the table and Paste.

10. Remove the AutoFilter.

Hi Peter,

Yeah i forgot to mention that. Actually i m looking a macro solution as number of rows is around 1000.

Thanks

So, did you try this?

Peter_SSs said:

If you need a macro, try recording these steps for some starting code.

Click to expand...

What version of Excel are you using?