VBA code to return multiple entries in each row based on criteria

  • Unfortunately i can't test because my mac doesn't support the dictionary object, but try:

  • Also, this will make the keys none case sensitive. Still, check your spelling of the keys.