Hello.
I need to copy columns between worksheets and then provide lookups values from a table. I have ditched Functions and Copy / Paste in favour of:
1) Loading the values to be looked up into a variant array
2) Using WorksheetFunction.Index/Match to populate a second array referencing the...