Need help to Group Rows based on Cell Content in Col A

[Mallappa]

Hi Friends,

Basically, I am looking for a macro code which would help me to group the rows based on the cell content in the column A.
I have a spreadsheet which have country names in column A and data in others columns, I want to group all the countries based on its sub areas. I have to repeat this task for 10 files every week, which I am doing manually now. It takes hell lot of time and effort. . Every week data keeps on changing so rows are not dynamic but particular sub area countries will be one or the other.
Eg- A, B, C countries should be grouped together. W, X, Y, Z should be grouped together. but sometimes country would be missing say country X, but shouldn't matter, rest should be grouped.

Any help on this is highly appreciable as it will save lot of time for me.. (I m very weak in VB)

Thanks in advance. Please help

 

[johnhangey]

when you say group rows, do you mean rearrange them, say by using "filter"? Sounds like something easy, Im just having a hard time understanding your example.

 

[hiker95]

Mallappa,

What version of Excel are you using?

Can you post a screenshot of the raw data worksheet, and, post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
MrExcel HTML Maker
Or, when using Internet Explorer, just put borders around your data in Excel and copy those cells into your post.

If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data scrubbed/removed/changed
mark the workbook for sharing
and provide us with a link to your workbook.