I am trying to make a macro which zips a file or files based on a speradsheet as follows:

File ref FIle name Zip file name
a b c
b d c
g e f

The file should go to the zip file referenced in the "Zip file name" and work using the default windows zip program.
i.e.the zip file should be called (c) containing files (b)

Pleae bearing mind the intention is that this will work for thousands of files. As per my little table, file (a) and (b)should appear in zip file (c) and file (g) should go to zip file (f).

Any help is greatly appreciated.

Thank you