Is there a way to make a copy of a macro-enabled excel file into a new excel file where all of the original values and formatting matches the original (ie. if a a data field is a vlookup formula I want the shown data to be copied not the formual itself)???
Any help would be greatly appreiciate and save me a lot of time
Matt
Any help would be greatly appreiciate and save me a lot of time
Matt