Marco

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Loi - 07 Dec 2004 17:51 GMT

Hi,

I have two spreadsheets, A and B, that have the same
format.

I would like to:
After I insert new rows in sheetA, It will be automatic
insert new rows in sheet B.

Can I use marco to do it? If I can, please show me how to
do it.

Or please show another ways.

Thank you
Loi

Reply to this Message

Raymond J. Johnson Jr. - 07 Dec 2004 18:55 GMT

| Hi,
|
[quoted text clipped - 12 lines]
| Thank you
| Loi

You might be able to have marco do it, but you'll have to work it out with
him.

Reply to this Message

Otto Moehrbach - 07 Dec 2004 20:04 GMT

Raymond
That was a cheap shot. Not everyone has the same command of English as
you. Would you like to compete with him in his language? Otto

> | Hi,
> |
[quoted text clipped - 15 lines]
> You might be able to have marco do it, but you'll have to work it out with
> him.

Reply to this Message

Sandy Mann - 07 Dec 2004 20:52 GMT

> Raymond
> That was a cheap shot.

Perhaps the * Jr * explains it.

Sandy

Signature

to e-mail direct replace @mailintor.com with @tiscali.co.uk

> Raymond
> That was a cheap shot. Not everyone has the same command of English as
[quoted text clipped - 19 lines]
> > You might be able to have marco do it, but you'll have to work it out with
> > him.

Reply to this Message

Otto Moehrbach - 07 Dec 2004 20:01 GMT

Loi
I am not sure of what you want to do, but if you want to insert the same
number of rows in the same place in both sheets, you can do that manually by
grouping the sheets.
Do this. Select sheet A. Now hold the Ctrl key down and select sheet
B. Now both sheets are selected. Now insert the rows and it will happen to
both sheets. HTH Otto

> Hi,
>
[quoted text clipped - 12 lines]
> Thank you
> Loi

Reply to this Message