Hi, my intent is to have the content and formatting of a cell on one sheet, returned to another. VLookups got me most of the way there, but do not return the formatting. So, is there a way to have a macro, dynamically pick up the location of the cell to copy from, and then paste it to a different cell. For instance, if I have "Sheet3!B1" in cell B5 on Sheet2, can a macro read that as the location to go to, perform a copy, and then return to Sheet2 and paste in cell C5?

Thanks in advance,
KT