I have an old version of Excel and on my search I ran across this
comment
from Fluff MrExcel MVP who said:
I fear that applies to me - but here's what I want to do:
I intend to paste Version 1 of my data down Column A and Version 2 down Column F
I want the formatted data to appear down...