Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula down variable rows based on (lastrow) from another sh
I have a variable number of rows in Sheet1, starting on row 2 ( Row 1
contains a column header ). Lets say for example this time it is 500 rows. ( lastrow = 501 ). On Sheet 2 I have a column header in cell a1 and an existing formula in A2. How do I copy the formula down based on the lastrow value from Sheet 1. In this example, the macro would copy the formula down to A501. Thanks in advance for your help, Joe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula down variable rows based on (lastrow) from another sh
Basic code looks like this
Sub test() Dim LastRow As Long With Worksheets("Sheet2") LastRow = Worksheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Row .Range("A2").AutoFill Destination:=.Range("A2:A" & LastRow) _ , Type:=xlFillDefault End With End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "adidas12121" wrote in message ... I have a variable number of rows in Sheet1, starting on row 2 ( Row 1 contains a column header ). Lets say for example this time it is 500 rows. ( lastrow = 501 ). On Sheet 2 I have a column header in cell a1 and an existing formula in A2. How do I copy the formula down based on the lastrow value from Sheet 1. In this example, the macro would copy the formula down to A501. Thanks in advance for your help, Joe |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula down variable rows based on (lastrow) from another sh
Dim LastRow as long
with worksheets("Sheet1") lastrow = .cells(.rows.count,"A").end(xlup).row .range("A2:A" & lastrow).formular1c1 _ = worksheets("Sheet2").range("a2").formular1c1 end with But if you use column A to find the last row, then aren't you overwriting the stuff in that range? adidas12121 wrote: I have a variable number of rows in Sheet1, starting on row 2 ( Row 1 contains a column header ). Lets say for example this time it is 500 rows. ( lastrow = 501 ). On Sheet 2 I have a column header in cell a1 and an existing formula in A2. How do I copy the formula down based on the lastrow value from Sheet 1. In this example, the macro would copy the formula down to A501. Thanks in advance for your help, Joe -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula down variable rows based on (lastrow) from anothe
Hi Ron,
PERFECT Solution ! Your code worked perfect the very first time I used it. Thank you very much for saving me so much time, I appreciate it Have a great day, Joe "Ron de Bruin" wrote: Basic code looks like this Sub test() Dim LastRow As Long With Worksheets("Sheet2") LastRow = Worksheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Row .Range("A2").AutoFill Destination:=.Range("A2:A" & LastRow) _ , Type:=xlFillDefault End With End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "adidas12121" wrote in message ... I have a variable number of rows in Sheet1, starting on row 2 ( Row 1 contains a column header ). Lets say for example this time it is 500 rows. ( lastrow = 501 ). On Sheet 2 I have a column header in cell a1 and an existing formula in A2. How do I copy the formula down based on the lastrow value from Sheet 1. In this example, the macro would copy the formula down to A501. Thanks in advance for your help, Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide rows in an Excel worksheet based on a variable | Excel Discussion (Misc queries) | |||
Copy&Paste variable range based on cell value | Excel Programming | |||
Copy rows to new sheet based on variable cell reference | Excel Programming | |||
Copy Formula loop based on number of rows w/ data in a col B. | Excel Programming | |||
Using the Lastrow variable in a Count/Countif formula | Excel Programming |