Hi,
I've recorded Macros before but haven't really written VBA code, and I've run into something I don't think I can record. I'd like to create a Macro that copies a block of cells from a fixed location in one workbook and then pastes that table into different workbooks, wherever my active cell is in the 2nd workbook when I run the Macro. Other threads I've read just involve pasting cells to a fixed location in the second workbook, but I'd like to be able to have the Macro paste in different places as I've said, wherever my active cell is at the time. When I tried just recording the actions, the VBA code recorded the specific 2nd workbook file I used that time, but I'd like this to be able to apply to any workbook I open. Any help/guidance would be much appreciated, thanks!