+ Reply to Thread
Results 1 to 16 of 16

need assistance with merging cells

  1. #1
    Gord Dibben
    Guest

    Re: need assistance with merging cells

    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?



  2. #2
    Ken Wright
    Guest

    Re: need assistance with merging cells

    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?

    >




  3. #3
    Ken Wright
    Guest

    Re: need assistance with merging cells

    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?

    >




  4. #4
    Helen
    Guest

    Re: need assistance with merging cells

    Thank you for your reply. I am not the best when it comes to terminology. I
    mean "linking" the cells. What I am trying to do is set up an inventory
    combined with sales and purchases.

    I sell fabric. I have a sheet with my inventory on it and a sheet with my
    purchases on it (the fabric I buy to sell). On the purchases sheet I list my
    purchases for each month including supplier, cost etc. I was then wanting to
    link this information to the inventory sheet so I had a complete inventory at
    all times. At the end of the month I would go the inventory sheet and adjust
    for the sales I had made. I was originally going to do this in Access, but
    it wouldn't accept anything less than 1 unit and I sell in quantities as
    small as .25 of a unit.

    I hope this makes sense.

    I appreciate you assistance.

    Kind regards
    Helen

    "Gord Dibben" wrote:

    > 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?

    >
    >


  5. #5
    Helen
    Guest

    Re: need assistance with merging cells

    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?

    > >

    >
    >
    >


  6. #6
    Gord Dibben
    Guest

    Re: need assistance with merging cells

    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?



  7. #7
    Ken Wright
    Guest

    Re: need assistance with merging cells

    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?

    >




  8. #8
    Ken Wright
    Guest

    Re: need assistance with merging cells

    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?

    >




  9. #9
    Helen
    Guest

    Re: need assistance with merging cells

    Thank you for your reply. I am not the best when it comes to terminology. I
    mean "linking" the cells. What I am trying to do is set up an inventory
    combined with sales and purchases.

    I sell fabric. I have a sheet with my inventory on it and a sheet with my
    purchases on it (the fabric I buy to sell). On the purchases sheet I list my
    purchases for each month including supplier, cost etc. I was then wanting to
    link this information to the inventory sheet so I had a complete inventory at
    all times. At the end of the month I would go the inventory sheet and adjust
    for the sales I had made. I was originally going to do this in Access, but
    it wouldn't accept anything less than 1 unit and I sell in quantities as
    small as .25 of a unit.

    I hope this makes sense.

    I appreciate you assistance.

    Kind regards
    Helen

    "Gord Dibben" wrote:

    > 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?

    >
    >


  10. #10
    Helen
    Guest

    Re: need assistance with merging cells

    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?

    > >

    >
    >
    >


  11. #11
    Helen
    Guest

    need assistance with merging cells

    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?

  12. #12
    Gord Dibben
    Guest

    Re: need assistance with merging cells

    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?



  13. #13
    Ken Wright
    Guest

    Re: need assistance with merging cells

    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?

    >




  14. #14
    Ken Wright
    Guest

    Re: need assistance with merging cells

    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?

    >




  15. #15
    Helen
    Guest

    Re: need assistance with merging cells

    Thank you for your reply. I am not the best when it comes to terminology. I
    mean "linking" the cells. What I am trying to do is set up an inventory
    combined with sales and purchases.

    I sell fabric. I have a sheet with my inventory on it and a sheet with my
    purchases on it (the fabric I buy to sell). On the purchases sheet I list my
    purchases for each month including supplier, cost etc. I was then wanting to
    link this information to the inventory sheet so I had a complete inventory at
    all times. At the end of the month I would go the inventory sheet and adjust
    for the sales I had made. I was originally going to do this in Access, but
    it wouldn't accept anything less than 1 unit and I sell in quantities as
    small as .25 of a unit.

    I hope this makes sense.

    I appreciate you assistance.

    Kind regards
    Helen

    "Gord Dibben" wrote:

    > 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?

    >
    >


  16. #16
    Helen
    Guest

    Re: need assistance with merging cells

    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?

    > >

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1