Apologies if this is not the correct thread.
Looking for some insights into the Excel Copy and Paste - Special.
More specifically on the ability to Copy a data set/range from one workbook, to another workbook, copying everything in that range, except the 'visibility' of the formulas in certain cells.
Ie: The origin workbook contains VLookup, etc. I do not want that showing or copied across to the new workbook.
Thanks in advance.