I use an Access based program and want to copy data from that program and paste it into Excel. Simple enough, no? However, due to the nature of the Excel spreadsheet I use, it is very difficult to paste into the specific Excel cell. The sheet has so many merged cells that the cell I want to paste into is very small. Since copying the data from Access is easy enough, could I create a macro to paste that information, and could I create a macro to copy from Access into Excel? Sorry for being naive on this. Thanks.
