Hi Ken

Thanks for your reply. I used the wrong terminology. I should have said
"linked", but your information is very useful. I appreciate the assistance.

Kind regards
Helen

"Ken Wright" wrote:

> The very best advice we could give you is to avoid merged cells like the
> plague. Format / Cells / Horizontal / Centre across selection will give you
> the same effect without the downsides.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ------------------------------Â*------------------------------Â*----------------
> It's easier to beg forgiveness than ask permission :-)
> ------------------------------Â*------------------------------Â*----------------
>
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:e1hhg11j8pk2jifkv17397sfepvhrm69jc@4ax.com...
> > 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"
> > <Helen@discussions.microsoft.com>
> > 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?
> >
>
>
>