Determine Last row of data in a Column and Use value to copy a Formula in another column

[DryJeans]

Hello,

Here is what I am trying to do. I want to determine the last row containing data in a column and use that number as a reference to copy a formula in a different column to the same row number. Here is a worksheet:


Indicator Payee ID Payee Name len
P 222201 PHARMACY SOLU 6
P
p
p
p
p
p
p
p
p


Column A (Indicator) has 10 records in it. I want to get that figure using this command:

Range("A" & Rows.Count).End(xlUp).Row

Once I obtain the number of rows that have data in them (in this instance, 10), I want to proceed to column D (len) and copy the formula that is in row 1 to the LAST row that the above code calculated (in this case, 10). Can someone shed some light as to how I would do this??

Thanks!

[TMS]

Something like:

Please Login or Register  to view this content.