ExcelBanter - need assistance with merging cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - need assistance with merging cells (https://www.excelbanter.com/excel-worksheet-functions/41469-need-assistance-merging-cells.html)

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?

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?

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

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