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 respondingTheaKyna
You could do it as You've written in Your the last sentence.
You should have an image - when?
Thank You (^-^)/
I'm not familiar with the VBA code. I can't quite gasp by your question - Did You skip my question .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?
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).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 skipped to 'when?'-question.
It would be really tricky to use automatic.
There are instructions to use.
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.