Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Numbering dependant on amount in a cell
Hi there,
I am creating a Spreadsheet that calculates sample sizes depending on a number of criteria. Once the size has been established in a cell I want that number of rows to be numbered on another sheet starting at row 10. Does anyone know if I am able to achive this? Many thanks for your time! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Numbering dependant on amount in a cell
Sub numberRows() Const cellValue As String = "E1" r = 10 If IsNumeric(Worksheets("Sheet1").Range(cellValue).Va lue) Then For i = 1 To Worksheets("Sheet1").Range(cellValue).Value Worksheets("Sheet2").Range("A" & r).Value = i r = r + 1 Next End If End Sub "Monkey" wrote: Hi there, I am creating a Spreadsheet that calculates sample sizes depending on a number of criteria. Once the size has been established in a cell I want that number of rows to be numbered on another sheet starting at row 10. Does anyone know if I am able to achive this? Many thanks for your time! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CALCULATE GST AMOUNT FROM AMOUNT IN OTHER CELL | Excel Worksheet Functions | |||
Show or blank out a cell dependant on an selection in another cell | Excel Discussion (Misc queries) | |||
Dependant cell tracking | Excel Worksheet Functions | |||
sales tax total amount from one cell amount to another cell | Excel Discussion (Misc queries) | |||
Returning a Value dependant on a cell which could have different d | Excel Worksheet Functions |