I just have the actual cell number where when you type in one cell it links
into a cell on the other worksheet. After the link, I do a data sort on the
complete table and it puts the cell with the entire row correct on the table
where the actual data sort is done, however on the linked worksheet it just
sorts the one cell so I have data in the row that shouldn't be there....i.e.
billie X X X
(The X's represent data that should be in row 2, where billie is the sorted
cell)
Hope my explanation is ok....Thanks so much for your help....I seem to have
tried everything, even an individual sort on the linked page which does the
same thing.
"Billie" wrote:
I have a worksheet that has data links to another worksheet but when I do a
data sort it works fine on one but it only sorts the cell on the worksheet
with the linked data. How do I get the complete row to sort on the sheet
with the links?
|