Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello, I would really appreciate it if anyone can help with the following, my
$70 book has only confused me further. I am trying to write a macro that will enter a value from a cell into a variable number of rows below it in the same column. eg copy the value from cell A1 into the cells commencing at A5 and on for the number of rows specified by an integer entered in cell A2, and then do the same for B2 etc In the following example the Number 2 is entered in 4 rows, the number 3 is entered in 2 rows 2 4 3 5 2 4 2 4 2 4 4 4 Sincerely appreciate someones help. Ian Grega |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy down with variable number of rows | Excel Discussion (Misc queries) | |||
defining a variable-size worksheet area for copying & pasting | Excel Worksheet Functions | |||
Copying and Pasting Rows Macro | Excel Discussion (Misc queries) | |||
Copying multiple rows to other worksheets (but amount of rows varies) - How? | Excel Discussion (Misc queries) | |||
sum and variable rows | Excel Worksheet Functions |