Copy formula from one row to another

I have a bunch of formulas that run to about 6000 rows. Sometimes we will use all 6000, sometimes not. When sorting the data, it puts all the empty cells at the top and the ones with actual data after that. I need to create a macro that will only copy the formula to the next row, but only if data gets input in the cell above. By doing this, I can sort the rows with actual data properly. Thanks.

I tried, but that did not work

Please Login or Register  to view this content.

Maybe try again, the added solution will work.

Here is a sample sheet. The only thing I am trying to do is when I sort the data in the first sheet, I don;t want to sort the empty cells that have formulas. I appreciate your help.

With a filter on column F.

The empty cells are gone.

I marked the last row with the color red.

I can't post the example because it is 4 mb!

Filter on column F and click on empty cells. (everything without empty cells is selected en shown).

Can I do the same thing for all columns?

Yes, use the filter for every collumn.