Can someone please help me with this, - I have found several similar queries, but cannot seem to adapt to my needs.
I have a 2 column range that I import data from a report. The first column contains codes, and the second column contains values.
I then have a helper range, that has a complete list of all codes ( the imported list will not be complete), and I have a Vlookup formula to fill in from the imported list.
I then want to copy this complete list to a data table.
I can make it copy as a straight copy paste, but cannot make it paste Values, - I need to do this to get rid of the formulas.
Below is the code that I have, - the data that I import has spaces in the code, so I have put in a routine to remove the spaces so the Vlookup works,
Many thanks in advance.....
Moderator's Edit: Use code tags when posting code. To do so in future, select your code and click on the # icon at the top of the post window.
Please Login or Register to view this content.