Solved: in Excel 2007, pasting to visible cells only

[K. Georgiadis]

I'll see what I can do. The data table has 8700+ rows and it will take a little thinking to come up with a representative fragment.

I can already tell you that the hidden rows do NOT occur at regular intervals.

PS: OK, here is a representative fragment of the file. Right now the table is filtered for corn. Columns D:J contain static numbers which need to be replaced with dynamic formulas. I want to create formulas in D2:J2 and copy them down to the visible rows only.

Obviously, a manual paste is easy enough in this sample but the real table has 8760 rows.