A B C D
1 Name Tel no Name Tel no
2 Aashiq Ezzy 6540029 Dawoodi Musken 2402582
3 Fakhri Musken 2438362 Aashiq Tailor 9809748
4 Fatemi Musken 2448319 Abbas Kothari 7993640
5 Hozefa Musken 2416985 Husaini Musken 2400384
6 Kutabi Musken 2451009 Abbas Miyaji 9280774
7 Abdeali Chikh 9782514
8 Taher 2410111

THE ABOVE IS A SAMPLE DATA
Cell (A&B) is one group and (C&D) is another group.

Imagine, more datas will be added daily in each group. and I need
macro to run so the it will identify automatically the last row o
each group and it is has to be sorted by name.

Hope someone help me.
Thanks in Advanc

--
Message posted from http://www.ExcelForum.com

See my response in .misc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"gmangad " wrote in message
...
A B C D
1 Name Tel no Name Tel no
2 Aashiq Ezzy 6540029 Dawoodi Musken 2402582
3 Fakhri Musken 2438362 Aashiq Tailor 9809748
4 Fatemi Musken 2448319 Abbas Kothari 7993640
5 Hozefa Musken 2416985 Husaini Musken 2400384
6 Kutabi Musken 2451009 Abbas Miyaji 9280774
7 Abdeali Chikh 9782514
8 Taher 2410111

THE ABOVE IS A SAMPLE DATA
Cell (A&B) is one group and (C&D) is another group.

Imagine, more datas will be added daily in each group. and I need a
macro to run so the it will identify automatically the last row of
each group and it is has to be sorted by name.

Hope someone help me.
Thanks in Advance


---
Message posted from http://www.ExcelForum.com/