Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to multiple the rows by a given number
Hi guys, I wonder if anyone can assist me on this one: say I have the word Apple on cell A1 and the number 60 on cell A2, question is how can I have the word apple multiply 60 times between A1 to A60? Is there such possibility? (Without dragging the cursor to A60) [I have 500 addresses and I need to multiply each by either 60 or 50) Thanks for any help -- xianwinwin ------------------------------------------------------------------------ xianwinwin's Profile: http://www.excelforum.com/member.php...o&userid=35264 View this thread: http://www.excelforum.com/showthread...hreadid=550353 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to multiple the rows by a given number
Well the only way I know to do this is through a loop in VBA. If the word you
wanted repeated was in cell A1 and the number of times you wanted it repeated was in cell B1, then the following code when ran would paste the word in cell A1 down the number of times of cell B1. Sub mutliplerows() X = Cells(1, 2).Value i = 2 Do Until i = X + 1 Cells(i, 1).Value = Cells(1, 1).Value i = i + 1 Loop End Sub "xianwinwin" wrote: Hi guys, I wonder if anyone can assist me on this one: say I have the word Apple on cell A1 and the number 60 on cell A2, question is how can I have the word apple multiply 60 times between A1 to A60? Is there such possibility? (Without dragging the cursor to A60) [I have 500 addresses and I need to multiply each by either 60 or 50) Thanks for any help -- xianwinwin ------------------------------------------------------------------------ xianwinwin's Profile: http://www.excelforum.com/member.php...o&userid=35264 View this thread: http://www.excelforum.com/showthread...hreadid=550353 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to multiple the rows by a given number
thanks, I got familiar with macros :-) -- xianwinwin ------------------------------------------------------------------------ xianwinwin's Profile: http://www.excelforum.com/member.php...o&userid=35264 View this thread: http://www.excelforum.com/showthread...hreadid=550353 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Transforming Multiple Rows into 2 columns | Excel Worksheet Functions | |||
Move multiple rows of data that are not sequential | Excel Discussion (Misc queries) | |||
Is de-duping in advanced filter limited to a number of rows | Excel Worksheet Functions | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions |