Copy an equation down to the last row.

Hello,

I run a macro to import data from another file. Everytime the data is imported, the number of data rows changes. The data goes from column A to column Y. In column Z I have an equation. This equation should be copied down for all the rows. Meaning if the last row is row 208, the equation should be copied down to row 208. Then next time before the data is imported, the column should be cleared (except for the first row--so that I have the equation in a cell) and then copied down to the last row again, which might be row 104 or 350...etc. (Meaning if the data rows decrease, the equation should not go past the data rows).

How can I do this?

Thank you in advance for your help!

Sincerely,

az!

Assuming the formula exists in Z2, then like so:

Please Login or Register  to view this content.

Just a question...

If you are copying the same formula down each time you import your data, why do you need to clear (delete?) the formula in the 1st place? I would think it would be far simpler to copy the formula down to way past where you think you would need them, and then just leave the formulas there, and modify them so that they show nothing if there is nothing in that row (ie, if the data does not reach down that far)?

pick a cell within the row - lets call it A2 (Im assuming that only row 1 will contain headings, if not, adjust the formula accordingly). then use something like this....

=if(A2="","",your-formula-here)
copied down

happy to help