Code to copy formula from specific cell to end of data

[winmaxservices1]

Hi,

I have data in sheet1 starting from a2
as mentioend below
A2=raj
A3=Stephen
A4=Mores
A5=wilfred
A6=mack
A7=sam
A8=cavina
A9=savio
A10=issac


I want to calculate length using =LEN('Sheet1'!a2) in cell a2 of sheet2
The formula should start from A2 in sheet2 till the end of data existing in Sheet1
I will keep adding data in sheet1

[Richard Buttrey]

..and what happens when you put that formula in A2 on sheet 2 and copy it down?

[winmaxservices1]

I want to set the Macro to copy the formula to till end of the data, because every time I will be pasting a new data in sheet 1 and will run macro. I want to avoid copy paste process everytime

[excelfandoo]

Hope the below code works:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[winmaxservices1]

its working Properly.
in a test sheet.

But it not working in My actual file. Might be because of sheet name.

My actual file contains "Paste Sheet" as sheet1 and "Process Data" as sheet2.
can you change the code accordingly.

[excelfandoo]

Please Login or Register  to view this content.

[winmaxservices1]

Hi,

Along with this can you give me separate vba code to add new worksheet with specific name?

[excelfandoo]

Please Login or Register  to view this content.