Avatar of upobDaPlaya
upobDaPlaya
 asked on

In VBA how do I store a lookup value in an array, then loop thru the array

Attached I have a 3 tab spreadsheet: Source, Today, and Not Matched
1.In VBA I would like to compare the Today tab with the Source tab based on fields "Amt" "Store" and "Date"
2.If I find a match I would like to store the "ID" value from the source tab for the first match found (note there could be multiple matches)
3.I would then like to re-loop thru the Source tab to find any ID's that are not found in the stored value from above
4.The final step would be I would write out the missing ID's to a tab called "Not Matched"

I am familiar with looping, but I do not know the approach or syntax to create an array for the id and to store the array....
ee-Not-Matched.xlsx
Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Subodh Tiwari (Neeraj)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
upobDaPlaya

ASKER
This is great !  Can you explain what the scripting library does ?
SOLUTION
Subodh Tiwari (Neeraj)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
upobDaPlaya

ASKER
Thanks for the solution and the Dictionary link...very helpful
Subodh Tiwari (Neeraj)

You're welcome.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy