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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - link a entire line in Excel to a spreadsheet I sort? (https://www.excelbanter.com/excel-discussion-misc-queries/95897-link-entire-line-excel-spreadsheet-i-sort.html)

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.

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

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

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