Find repeat and than merge and centre

[Sandy Mann]

Firstly, Merge and centre the Yellow color rows.
I don't see what your obsession is with merging rows After merging all rows
with CZ001 and copying to another Workbook you will have:

221000800011 Biraja Star T V 12568.5775 7075 5493 400 BLUE DEACTIVE

which is the data in the top row, in a cell 48 rows high. What is the
benefit in merging?

Secondly, copy the data Zone wise For example Cz001 in another workbook
sheet1, Cz002 in sheet 2, CZ003 in sheet3, Nz001 in Another workbook
sheet1.Nz002 in sheet2,Ez001 in another sheet1 and so on.

Why use other Workbooks? Why not just other Worksheets in the same
Workbook?

Finally why not ask Aidan Heritage who wrote the existing Macros in the
Workbook?


--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Hardeep_kanwar]

Dear sir,
First i don't want to merge and centre the A:A column as i Mentioned you
earlier that only yellow colour Column i.e (B:B, D,H:H,I:I,J:J,K:K,L:L,M:M)

Secondly the Macors which is given by Mr.Aidan Heritage it works fine but
it will copy in the same workbook due to our Client requriement they want
individual workbook for every Zone.
The code is given by u i.e MERGEITCENTRE it work in some cells for example
if one cell is repeated 4 times it will merge only 2 or 3 times. I think it
will merge only 2 cells instead of 3 or 4 cells. In B1:B4 is same after run
the code it will merge the B1:B2

I hope you understand my problem

Thanks in advance

Hardeep kanwar