I have a set of averages I've calculated. In another location on the
same worksheet, I need to essentially reorganize this info to be
displayed in another way. I was just copying and pasting the values
but realized if there was a change in my calculations for any reason,
I'd have to go back and recopy/paste as the cells wouldn't update. So
what I've been doing is simply setting these cells equal to the
already calculated cells. (i.e. I have an a cell that I calculated an
average, say J100, and need the info to show up in F200, so in cell
F200 I enter "=J100").

However I have a LOT of data, and its rather time consuming to go thru
each cell and type "=J100", "=J101" and so forth. Is there a quick
way to do this rather than doing this one by one? I've not been able
to figure out how to do something like a copy/paste to tell it to just
equal the cell rather than the forumla/values.

Hope I've explained what I'm trying to do :)
Thanks!
Jennifer