VBA to match columns of data and copy to another worksheet

[amxtomzo]

I have a work sheet with several columns of data starting in A5 to A22.
there could be as many as 100 columns going over as far right as possible. using the same rows.

Some of the columns contain the exact same list of data.
Row 5 in all of these contains is the name of the zone for that data

So I would love to have a VBA code that could look through these list and on another worksheet in starting column A list all the zones from row 5 and in column B list all the data 1 time from those zones since they are all the same

Then in Column C list the next group of Like zones and put the corisponding list in column D

and so on and so fourth untill I have found all "like" zones that are the same with the list of data in the next column to the right

This will save us a lot of pre production time and be a GREAT help to us


Thank you very much for your assistance

Thomas

 

[hiker95]

amxtomzo,

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these: