T
twollens
Ok, I have something that I am trying to do in VBA, and am completely a
a loss (even how to do it normally)
I need to take a spreadsheet that looks like this:
1 USER1 ASIA
2 USER2 ASIA
3 USER3 AMERICA
4 USER4 AMERICA
5 USER5 EUROPE
6 USER6 EUROPE
7 USER7 EUROPE
and end up with the following
USER1, USER2
USER3, USER4
USER5, USER6, USER7
Basically I need to comma seperate all the users from a region. Th
number of users in each region will not be the same. There is a chanc
that a region might not even be in the spreadsheet. There will be n
more than those 3 regions. They are already sorted in alphabetica
order by region.
Any ideas?
Thank
a loss (even how to do it normally)
I need to take a spreadsheet that looks like this:
1 USER1 ASIA
2 USER2 ASIA
3 USER3 AMERICA
4 USER4 AMERICA
5 USER5 EUROPE
6 USER6 EUROPE
7 USER7 EUROPE
and end up with the following
USER1, USER2
USER3, USER4
USER5, USER6, USER7
Basically I need to comma seperate all the users from a region. Th
number of users in each region will not be the same. There is a chanc
that a region might not even be in the spreadsheet. There will be n
more than those 3 regions. They are already sorted in alphabetica
order by region.
Any ideas?
Thank