Once you have used functions to combine data from 2 or more worksheets into
one, how do you fix the data in those cells relative to the rows it is in, so
you may manipulate the data, ie with "no duplicates' and 'A-Z' sorting,
without the function and connection in the cells. I currently can't
manipulate the data without having the worksheets that the data came from
open. This makes it difficult to send the newly formed worksheet to anyone if
they can't manipulate the data.

Open to any ideas
--
Jim B