Fill formula down based on data in another worksheet VBA

[cmschmitz24]

I need help modifying a VBA code to fill down a formula based on data in another worksheet.

Worksheets(2).Name = "Data"
EndRow = Sheet1.Range("E" & Rows.Count).End(xlUp).Row
Range("A1").Formula = "=TEXT(Delinquency!R[1]C[6],""00000000"")"
Range("A1").Select
Selection.AutoFill Destination:=Range("A1:A" & EndRow), Type:=xlFillDefault

I need to copy the formula in cell A1 down on the "Data" sheet based on values in column E from the "Delinquency" sheet, starting with E2.

 

[bellman101]

Hi there,

Forgive me if I am misunderstanding your question, but I believe you could just say:

Range("A1:A" & EndRow).formula = Range("A1").formula

Also no need for the 'Select' line that way, which is always a bonus!

Cheers
JB

 

[cmschmitz24]

I'm still having issues, or my formula isn't working -

I need to have the formula in cell A1 on the 2nd worksheet filled down based on the data from the 1st worksheet in column E, starting with cell E2.

 

[JoeMo]

Try:

EndRow = Sheet1.Range("E" & Rows.Count).End(xlUp).Row
Sheets("Data").Range("A1:A" & EndRow).Formula = "=TEXT(Delinquency!R[1]C[6],""00000000"")"

No need to fill down.

 

[cmschmitz24]

Try:

EndRow = Sheet1.Range("E" & Rows.Count).End(xlUp).Row
Sheets("Data").Range("A1:A" & EndRow).Formula = "=TEXT(Delinquency!R[1]C[6],""00000000"")"

No need to fill down.

The 2nd worksheet does not have anything on it, it's blank, no headers, no text, etc. The code above will pull the right information via the formula for cell A1 on the 2nd worksheet, but it does not pull the formula for the rest of the data in column G on the first worksheet to the 2nd worksheet.
This is why I would copy the formula down the column.

 

[MARK858]

The 2nd worksheet does not have anything on it, it's blank, no headers, no text, etc. The code above will pull the right information via the formula for cell A1 on the 2nd worksheet, but it does not pull the formula for the rest of the data in column G on the first worksheet to the 2nd worksheet.
This is why I would copy the formula down the column.

Is that after testing? and why column G as it was column E you stated earlier?

 

[cmschmitz24]

My bad. I need the formula to pull from column G, based on data in column E.