link a entire line in Excel to a spreadsheet I sort?

I have a multi-page spreadsheet with some repetitive information that I'd
like to link so I only have to type it once.

a bit more detail would be helpful in getting a suggestion

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Tontine2" <Tontine2@discussions.microsoft.com> wrote in message
news:BC667980-8F69-410F-AD19-12EBA7F78C31@microsoft.com...
>I have a multi-page spreadsheet with some repetitive information that I'd
> like to link so I only have to type it once.

On two spreadsheets, I change the $ amount on one and want it to change on
the other one at the same time. The problem seems to be that I sort one list
by date and the other by name. Could I link one whole line so that when I
sort it it will still link to the proper cell on the other spreadsheet?

"Don Guillett" wrote:

> a bit more detail would be helpful in getting a suggestion
>
> --
> Don Guillett
> SalesAid Software
> dguillett1@austin.rr.com
> "Tontine2" <Tontine2@discussions.microsoft.com> wrote in message
> news:BC667980-8F69-410F-AD19-12EBA7F78C31@microsoft.com...
> >I have a multi-page spreadsheet with some repetitive information that I'd
> > like to link so I only have to type it once.
>
>
>