hi, I'm trying to transfer data from one excel file to another. The format of the file i want to transfer the data to is different from the file I'm getting the data from. How can I transfer these data to different cells. I could copy and paste all the way through but it would take forever. So probably a macro or a piece of code that could help??
Bookmarks