I am trying to write Excel 2007/2010 macros using the Macro recorder that will copy data from one workbook to another workbook using the Copy and Paste Special/Values functions. The "To" worksheet's cell addresses and formats are identical to the "From" worksheet's, so this is very straightforward. I have some experience manually writing macros with if - then - else logic (for example), but this problem is beyond my knowledge. Any help will be appreciated. thanks.
Bookmarks