Hi,
There is a issue i want to solve.

In worksheet1, I have some data like: index number (when I add data in new row its last index number +1) /name/address

In worksheet2, I have some formulas that are taking data from worksheet1 like "=if(isblank('sheet1!a3);"";'sheet1!a3)" I can copy this to 200 rows so it will work.... but it can be 1000 rows of data or even more in the future

I need:
Macro that will automaticly do:
1)if in sheets("sheet1").cells(last row, 1) is a number then
sheets("sheet2").range(cells(last row offset(-1,0) , 1) , cells(last row, 18) copy and paste in offset (1 , 0)

Example:
if any number appears in worksheet1.range("a2") then
worksheet2.range("A1:S1") select and copy
worksheet2.range("A2:S2") paste

if any number appears in worksheet1.range("a500") then
worksheet2.range("A499:S499") select and copy
worksheet2.range("A500:S500") paste

I would like to do it automaticly without using any button.

Any ideas? Help highly appreciated!