• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel: Merge cells with the same values for other columns?

TheaKyna

New Member
Hi, greetings to all!

I need some help with the Excel regarding merging cells. How can I merge cells automatically from this

75122

to this without merging manually each time? I want rows on column H and I to merge together if the row value on column A is the same.

75123

—Thank you.
 
TheaKyna
You could do it as You've written in Your the last sentence.
You should have an image - when?
I done it by doing manually one-by-one. It would be difficult to do it by this way if the data is large so I need help on sorting out data automatically. Anyway, thank you for responding :)
 
TheaKyna
Have You written VBA-code?
Step of VBA-code would be same as manually.
With You snapshots, it will be a challenge to offer any code.
... the code needs to verify too ... not with a snapshot.

Did You skip my question
- You should have an image - when?
 
TheaKyna
Have You written VBA-code?
Step of VBA-code would be same as manually.
With You snapshots, it will be a challenge to offer any code.
... the code needs to verify too ... not with a snapshot.

Did You skip my question
- You should have an image - when?
I'm not familiar with the VBA code. I can't quite gasp by your question - Did You skip my question .
 
TheaKyna
You need to upload a sample file.
I won't start to any code based a snapshot.

I answered Your question...
... but I need to know when that merge would do?
eg if You add a new row ... if You delete row ... after You write Order ID ... or You modify any Order ID?
There would be many combinations - when automatically should happen.
 
TheaKyna
You need to upload a sample file.
I won't start to any code based a snapshot.

I answered Your question...
... but I need to know when that merge would do?
eg if You add a new row ... if You delete row ... after You write Order ID ... or You modify any Order ID?
There would be many combinations - when automatically should happen.
The cell reference would be the Order ID. The rows on Column H (Pack.) & Column I (Time) should merge automatically if detected same duplicate data on Column A (Order ID).

--Thank you.
 

Attachments

  • Order.toship_copy.xls
    26.5 KB · Views: 5
TheaKyna
You skipped to 'when?'-question.
It would be really tricky to use automatic.
There are instructions to use.
 

Attachments

  • Order.toship_copy.xls
    37.5 KB · Views: 10
TheaKyna
As written in #8 reply
eg if You add a new row ... if You delete row ... after You write Order ID ... or You modify any Order ID?
There would be many combinations - when automatically should happen.

New would work ... but those others - would make unwanted results as You could figure.
That's why - You should do 'when' by selection as in my sample.
 
TheaKyna
As written in #8 reply
eg if You add a new row ... if You delete row ... after You write Order ID ... or You modify any Order ID?
There would be many combinations - when automatically should happen.

New would work ... but those others - would make unwanted results as You could figure.
That's why - You should do 'when' by selection as in my sample.

--Thank you.
 
Back
Top