In worksheet One, starting with A3, I have 10 columns and 10 rows full of
number data. Using VBA, I would like to go to worksheet Two, column A, Row
3, and enter the following: Concatenate (One!A3," ",One!A4," ",One!A5) and
copy this formula (relatively) from A3 through A12.



Can someone tell me how this is done or point me in the right direction?



Thanks!