Hi,
I'm having problems trying to figure out how to write a macro to extract information form one workbook to another. Here's what i need to do:
step 1: I have the old excel file open along with the new workbook.
step 2: I would like to have a macro button in the new workbook to extract the cell data from the other excel file that is open.
If someone could help me i would appreciate it.
Thanks,
Brian
Bookmarks