| View previous topic :: View next topic |
| Author |
Message |
mpnayak201976 General User

Joined: 10 Aug 2008 Posts: 34
|
Posted: Tue Aug 26, 2008 7:04 pm Post subject: copy row in to another row |
|
|
i would like to copy whole row and paste in to another row with macro
in one cell i have value 2 and in another cell i have value 5.
i would like to copy row no. 2 and paste it in to row no.5
how can i do this with help of macro.
thanks |
|
| Back to top |
|
 |
purdygoode General User

Joined: 15 Dec 2007 Posts: 12 Location: 67216
|
Posted: Wed Aug 27, 2008 4:16 am Post subject: |
|
|
1st> select the row tab, copy
2nd> select cell "A", paste
pg |
|
| Back to top |
|
 |
jrkrideau Super User

Joined: 08 Aug 2005 Posts: 6733 Location: Kingston ON Canada
|
Posted: Wed Aug 27, 2008 4:35 am Post subject: |
|
|
Follow mpnayak201976 's directions but with Record Macro on
Tools > Macros > Record Macros _________________ jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
 |
mpnayak201976 General User

Joined: 10 Aug 2008 Posts: 34
|
Posted: Fri Aug 29, 2008 7:37 am Post subject: |
|
|
hye,
somebody pls. help i want to write a macro
to cut row and paste in to different row
i write row number in cell b2 and b3.
example: b2 = 5 and b3 = 41
then cut row number 5 and paste in to row number 41
thanks |
|
| Back to top |
|
 |
David Super User


Joined: 24 Oct 2003 Posts: 5668 Location: Canada
|
Posted: Fri Aug 29, 2008 8:07 am Post subject: |
|
|
You could start by asking in the Macro forum for possibly better results.
Also, did you not try jkr's suggestion?
David. |
|
| Back to top |
|
 |
mpnayak201976 General User

Joined: 10 Aug 2008 Posts: 34
|
Posted: Fri Sep 05, 2008 5:05 am Post subject: |
|
|
thanks for your interest.
now problem solved. |
|
| Back to top |
|
 |
|