Hi
I need to copy range data from an excel sheet to an excel sheet in Master Workbook.Can u please tell me code to do that??
Thanks in advance.......
Jignesh
Code for that...
Workbooks("Book1.xls").Sheets("Sheet1").Range("A1").Copy Workbooks("Book2.xls").Sheets("Sheet2").Range("B2")
How's that ?
Like this thread? Share it with others