Helen

Are you actually "merging" the cells or are you "linking" the cells from
sheet1 to sheet2 as in =sheet1!A1 written on sheet2?

If the latter, you can change the order on sheet1 only if you first change the
formulas on sheet2 to values.

Am somewhat confused by your use of "one sheet" and "the other sheet".

Post back with more detail and the names of your sheets.


Gord Dibben Excel MVP

On Sat, 20 Aug 2005 23:33:07 -0700, "Helen"
wrote:

I have a query with merging cells. I know how to merge cells from one sheet
to another (just learnt that). I have an inventory list and as I purchase
goods I want to put the information on one sheet and have it merge to another
sheet for other purposes. On the other sheet can I change the order of the
inventory without affecting the merged information?