Hi,
I'm new to VBA so apologies for asking simple questions!
I have a workbook called "ME". I want to write a macro that will import data from columns A1 till J5000 in worksheet"temp" in another workbook called "XY", and put them in a worksheet called "IM" in the original workbook. Can someone please help me with the code. I also want to put in a code that will opne up workbook "XY" in case it is not open.
Thanks!
I'm new to VBA so apologies for asking simple questions!
I have a workbook called "ME". I want to write a macro that will import data from columns A1 till J5000 in worksheet"temp" in another workbook called "XY", and put them in a worksheet called "IM" in the original workbook. Can someone please help me with the code. I also want to put in a code that will opne up workbook "XY" in case it is not open.
Thanks!