View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default Macro 4 copy & paste between 2 books/files

Hi Guys,

Can you devise a macro that when I open two workbooks of similar structure,
one with the macro, and run the macro the data on the other opened sheet is
copied and pasted on the macro containing book.

Next time I run the same code the data is again copied from the other sheet
and pasted on the macro possessing workbook but in the end, i.e. after
non-blank rows.

Thanks in advance