Repeated row
 

Good day;

I work with excell 2000

On an excell document i have a row which is repeated several times on the
same sheet. The cells of this raw contain texts.

Whenever i make a change to these texts on one row of these i would like
all the other rows to automatically modify accordingly.

How can i do that?

Thanks for your help.
Carlo

Hi Carlo

assuming your row of data is row 5 and is repeated at row 10 and row 15
in A10 type
=A5
and fill across (go to the bottom right hand corner of the cell until you
see a little black cross + and drag along the row as needed)
repeat at A15

Cheers
julieD

"carlo" wrote in message
...
Good day;

I work with excell 2000

On an excell document i have a row which is repeated several times on the
same sheet. The cells of this raw contain texts.

Whenever i make a change to these texts on one row of these i would like
all the other rows to automatically modify accordingly.

How can i do that?

Thanks for your help.
Carlo

Thanks a lot Julie.

This was so easy!!! Mind block: How did i think of it?

Thanks again
Carlo

"JulieD" wrote:

Hi Carlo

assuming your row of data is row 5 and is repeated at row 10 and row 15
in A10 type
=A5
and fill across (go to the bottom right hand corner of the cell until you
see a little black cross + and drag along the row as needed)
repeat at A15

Cheers
julieD

"carlo" wrote in message
...
Good day;

I work with excell 2000

On an excell document i have a row which is repeated several times on the
same sheet. The cells of this raw contain texts.

Whenever i make a change to these texts on one row of these i would like
all the other rows to automatically modify accordingly.

How can i do that?

Thanks for your help.
Carlo