Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill Down based on count in another sheet
I am using the following in Excel to copy a formula:
ThisWorkbook.Worksheets("Results 4").Range("3:2000").FillDown I need to only copy the formula for a certain number of rows up to 2000. The number of rows I need is based on the number of rows I have in worksheet "Results Data" in column A. So, if "Results Data" has data in column A2:A16, I will need to copy down the formula for all columns in worksheet "Results 4" to column 17. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count if based on criteria within cells on another sheet | Excel Discussion (Misc queries) | |||
Fill Cells Based On Cells In Another Sheet | Excel Worksheet Functions | |||
Count down with auto fill? | Excel Worksheet Functions | |||
Is there a way to count cells in a range based on fill color? | Excel Worksheet Functions | |||
Count nonblank AND fill color | Excel Worksheet Functions |