Copy formulas of previous row if values are filled in column A

Dear Friends,

I have a worksheet, called monthlysheet, in which cols. A - CX are there.

Assume that I have right now data from A4 - CZ104 (Row #3 is my header data).

From Col.A to Col.BZ are my values
From Col.CA to Col.CX are formula based columns.

Now, if i copy 50 data from some other workbook to this monthlysheet in cols. A - BZ, then I want to copy the formulas (all available in row #104) for the copied 50 data also.

i.e. if values are copied in Col. A then automatically the formulas in Col.CA to CX should be copied for the same number of copied data rows.

I need a VBA to automate the process.

Thanks & regards.

I dont know why you need VBA doe this? You can either set yup the formulas to show nothing if there is nothing in that row (and copy them way down before-hand, or, after you copy the data in, you can just double-click on the drag-handle on each formula cell, and it will fill down to the last row of data

Yes, it is easy to drag and fill.

But how about automation. Possibility of wrong dragging / mishandling may lead to entire report in vain.

That's the reason i need to automate the all formulas if data are copied in col.A.

Any further VBA solution?

Please...

any solution is highly obliged.