This user has a database that he daily downloads data from a source and
loads it into the database.  He then exports 5 queries all into a
single workbook for the day.  He recreates this workbook every day but
he has comments for specific parts that he needs to copy over from the
day before, but they aren't always in the same place, or even included
in the next day, thus the vlookup.

I've created macros to format his daily input and his daily output.
The macro asks him to select yesterdays file and then it creates the
vlookup and pastes it in to lookup the data.

He knows that the easy solution is to remove the spaces, but if at all
possible we'd like to workaround some other way.

Cheers,
Jason Lepack