View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
xianwinwin
 
Posts: n/a
Default 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