kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
Hi,
I have a variable MyItems as:
MyItems = ("Item 1", "Item 2", ....., "Item 11")
I also have 11 variables like:
Var1, Var2, ....., Var11
What I want to do is:
Look through column C for "Item 1" and when found, all records with Item 1 should have their values in column G, set to the value stored in Var1.
Then I repeat same for Item 2 to match Var2, and so on.
In my mind, I was thinking of loading those variables too to a list or an array.
MyVar = (Var1, Var2, ....., Var11)
But I don't know how to load it.
If what I am thinking is possible, can someone help me out?
Thanks in advance
I have a variable MyItems as:
MyItems = ("Item 1", "Item 2", ....., "Item 11")
I also have 11 variables like:
Var1, Var2, ....., Var11
What I want to do is:
Look through column C for "Item 1" and when found, all records with Item 1 should have their values in column G, set to the value stored in Var1.
Then I repeat same for Item 2 to match Var2, and so on.
In my mind, I was thinking of loading those variables too to a list or an array.
MyVar = (Var1, Var2, ....., Var11)
But I don't know how to load it.
If what I am thinking is possible, can someone help me out?
Thanks in advance