okay, I have a doozy of a problem. I'm looking for someone to point me in the right direction, not actually write the code.
essentially, I need this:
If cell.value = {userArray} and cell.offset(0, 2).value = {taskArray}
Then cell.offset(0, 2).interior.colorindex = 3
I have three different {userArray}s and {taskArray}s and there will essentially be different code for each of the arrays and that's fine.
The {userArray} is highly volatile so it needs to be generated from the spreadsheet list to make updates easy. The [taskArray} is less volatile but does change.
here is the data the arrays should contain.
my problem is setting up and forming the arrays so they can be used within the IF statment.
Can someone give me some tips or reference where I can learn the VBA needed to accomplish this?
essentially, I need this:
If cell.value = {userArray} and cell.offset(0, 2).value = {taskArray}
Then cell.offset(0, 2).interior.colorindex = 3
I have three different {userArray}s and {taskArray}s and there will essentially be different code for each of the arrays and that's fine.
The {userArray} is highly volatile so it needs to be generated from the spreadsheet list to make updates easy. The [taskArray} is less volatile but does change.
SRC Report Inprog-D.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | userGrp1 | taskList1 | userGrp2 | taskList2 | userGrp3 | taskList3 | ||
2 | User1 | Task1 | User6 | Task2 | User10 | Task3 | ||
3 | User2 | Task2 | User7 | Task3 | User11 | Task4 | ||
4 | User3 | Task3 | User8 | Task6 | User12 | Task5 | ||
5 | User4 | Task4 | User9 | User13 | Task6 | |||
6 | User5 | Task5 | User14 | |||||
7 | Task6 | User15 | ||||||
Sheet1 |
here is the data the arrays should contain.
my problem is setting up and forming the arrays so they can be used within the IF statment.
Can someone give me some tips or reference where I can learn the VBA needed to accomplish this?