Macro to Drag Down Formula

[tsioumiou]

Hello,

I am trying to automate the "Sheet2" to have the formulas dragged down depending on the rows on Column A on "Sheet1"

For example I will be pasting work on Column A sheet 1 that might be around 300 lines. Sheet 2 formulas should be dragged down to line 300 as well with a macro.

By drag down i mean with the formulas too.
Attached a dummy workbook

Would appreciate any help

Thanks

[Legend Rubber]

Book111.xlsm
Something like this?

[tsioumiou]

Yes this is the idea but its not what i need.
The problem with this is that you manually have to input formulas on Sheet2 Column A in order for it to work. (like you have done on A15, A16 etc)

I want those cells to be empty until i paste things on Sheet1 Column A.

Will probably need a macro...

Thanks

[Legend Rubber]

can i ask why they cannot have the formula in them before pasting?

[tsioumiou]

That was the mainly the reason i opened this thread.
One of the reasons is the unknown number of rows that will be pasted on sheet1 (might be tens of thousands).
Also there will be a few more worksheets with the same preference which will make the file much heavier.
A couple more reasons..

[tsioumiou]

One last try, maybe someone will notice this and help out a bit ...

[Legend Rubber]

i am sure that someone smarter than i could find a solution with a code that would do something like...
if the cell A1 in Sheet1 is not empty than copy/paste info to next available line in sheet2...
but i cant figure out how to do it...
Sorry, i did try to help...