If the two ranges would be "connected" by a single column that uniquely
identifies the row of information, then in the second table, use the vlooup
or combination of index and match to fill out the rest of the data by
pulling it from the first. .

--
Regards,
Tom Ogilvy


"Mex" wrote in message
...
Can one worksheet be copied to another in the same book with a link that
updates info and can each sheet be sorted differently and still carry the
correct info?