| View previous topic :: View next topic |
| Author |
Message |
g.bardi
Guest
|
 Posted: Tue Mar 09, 2004 6:52 am Post subject: Copy cell range from one sheet to another |
 |
|
| Could someone pls tell me how to copy the content of a range of cells of a sheet to a range on another sheet of the same document? |
|
| Back to top |
|
 |
carl
Super User
Joined: 21 Apr 2003
Posts: 920
Location: Germany
|
| Posted: Tue Mar 09, 2004 8:22 am Post subject: |
|
|
on your "result page" pick a cell, perhaps A1 and enter =(Sheet 1, A1) then drag horizontally and vertically till you have all the cells you want. It is always up to date witith changes you make to the first "origin Sheet"
NB I usually use the sigma symbol and then delete the word SUM that appears
_________________
carl
Using OpenOffice.org 2 on XP sp2 |
|
| Back to top |
|
|
dfrench
Moderator
Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand
|
|
| Back to top |
|
|
dem_azul
Newbie
Joined: 07 Jan 2005
Posts: 1
|
| Posted: Fri Jan 07, 2005 1:03 am Post subject: |
|
|
| Any API solution??? Thank's. |
|
| Back to top |
|
|
DannyB
Moderator
Joined: 02 Apr 2003
Posts: 3991
Location: Lawrence, Kansas, USA
|
|
| Back to top |
|
|
|
