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

"Loi" <(E-Mail Removed)> wrote in message
news:050b01c4dc85$5ea37bf0$(E-Mail Removed)...
| 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

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

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
"Loi" <(E-Mail Removed)> wrote in message
news:050b01c4dc85$5ea37bf0$(E-Mail Removed)...
> 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

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
"Raymond J. Johnson Jr." <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> "Loi" <(E-Mail Removed)> wrote in message
> news:050b01c4dc85$5ea37bf0$(E-Mail Removed)...
> | 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
>
> You might be able to have marco do it, but you'll have to work it out with
> him.
>
>

> Raymond
> That was a cheap shot.

Perhaps the * Jr * explains it.

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


"Otto Moehrbach" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
> "Raymond J. Johnson Jr." <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >
> > "Loi" <(E-Mail Removed)> wrote in message
> > news:050b01c4dc85$5ea37bf0$(E-Mail Removed)...
> > | 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
> >
> > You might be able to have marco do it, but you'll have to work it out
with
> > him.
> >
> >
>
>