Hi. I have worksheet A and worksheet B. Worksheet A has several columns
that can be sorted in any order. Worksheet B also has several columns that
can be sorted in any order. My problem is that I need to copy the content of
certain cells from worksheet B to worksheet A, but, as B is capable of being
re-sorted then that means the source cell reference changes and thus I'm left
with 'blanks' (or zeroes) in the worksheet A cell destination. I can see
that the problem would go away if I made the column list in worksheet B
'static', but that is not possible as both worksheets are designed to be
sorted. I've tried all the usual things between the source cells and the
destination cells such as paste link, paste special, paste hyperlinks but no
matter what I try, if worksheet B is re-sorted then I loose the pointer to
the data in worksheet A. Hope this makes sense.
--
Peter