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" <[email protected]>
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?

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:[email protected]...
> 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"
> <[email protected]>
> 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?
>

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:[email protected]...
> 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"
> <[email protected]>
> 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?
>

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" <[email protected]>
> 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?
>
>

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:[email protected]...
> > 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"
> > <[email protected]>
> > 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?
> >
>
>
>

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" <[email protected]>
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?

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:[email protected]...
> 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"
> <[email protected]>
> 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?
>

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:[email protected]...
> 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"
> <[email protected]>
> 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?
>

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" <[email protected]>
> 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?
>
>

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:[email protected]...
> > 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"
> > <[email protected]>
> > 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?
> >
>
>
>

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?

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" <[email protected]>
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?

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:[email protected]...
> 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"
> <[email protected]>
> 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?
>

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:[email protected]...
> 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"
> <[email protected]>
> 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?
>

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" <[email protected]>
> 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?
>
>

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:[email protected]...
> > 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"
> > <[email protected]>
> > 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?
> >
>
>
>