I wrote a simple macro that basically extracts data from a worksheet and puts it into a text file. The problem is though when I copy the macro to a different entirely new workbook of the same format and different data, the macro will keep referencing the original workbook and keep extracting data from that one. What do I do?
Bookmarks