copying a line for an X number of times

[AVRAHAMROOS]

Scenario:

1. I paste a number of text lines in Sheet1 starting in A1 (only one column)

2. In Sheet2, in Cell H1 I use a COUNTA function which tells me how many lines I added to Sheet1

3. I have a formula in Sheet 2 cell B1 that looks at line 1 of the text I added in Sheet1 and returns a numerical value based on it.

4. I want to automatically (Macro) copy that formula downwards for the number of lines I added (which is given in call H1)

How do I do this?

 

[AVRAHAMROOS]

the formu;a needs to be copied so that the second line refers to the second and the third to the third etc.

 

[FormR]

Hi, welcome to the forum.

Something like this maybe:

Sub m()
With Sheets("Sheet2")
    .Range("B1").AutoFill Destination:=.Range("B1:B" & .Range("H1").Value), Type:=xlFillDefault
End With
End Sub

 

[AVRAHAMROOS]

Great! wonderful. That did the trick

 

[AVRAHAMROOS]

Wanted to thank you again and show you what you have helped build:
https://docs.google.com/document/d/1dwFQvAZcL73OYXD-ykiY_4_hJGqi_nCQ9GN9OlaoKWM/edit

 

[FormR]

show you what you have helped build

Nice work