theguruguy
New Member
- Joined
- Dec 15, 2018
- Messages
- 12
my problem is that i have a list of user id's in column A. in columns B-? are permissions associated with that user ID.
I need to go through every row and sort by permission that would fit in a similar category. For example if a column value starts with grp.app.xxx
I would want to move all those to the same column on a different sheet. that new header column could be called apps.
then it continues is evaluation of the rows, doing the same thing for grp.ctx.xxx, moving to a new column on the new sheet with the header citrix, and again from grp.share.xxx. ect,ect. so columns could have more than one value in them so the script would have to append the data. most importantly keeping the data associated with the user.
after it finishes the row it would need to go to next row and do it again. about 1000 user id's
after is is all over it would be great to sort the columns with multiple values alphabetically..
im so lost on this.
I need to go through every row and sort by permission that would fit in a similar category. For example if a column value starts with grp.app.xxx
I would want to move all those to the same column on a different sheet. that new header column could be called apps.
then it continues is evaluation of the rows, doing the same thing for grp.ctx.xxx, moving to a new column on the new sheet with the header citrix, and again from grp.share.xxx. ect,ect. so columns could have more than one value in them so the script would have to append the data. most importantly keeping the data associated with the user.
after it finishes the row it would need to go to next row and do it again. about 1000 user id's
after is is all over it would be great to sort the columns with multiple values alphabetically..
im so lost on this.