Macro To Work Between My TEST.xls File And Another WorksheetFeb 19, 2009
Below is the macro to work between my TEST.xls file and another worksheet which is opened within the same workbook with the TEST file. If there are more than 2 files, the code ActiveWindow.ActivateNext won't work.
The number of files received from my suppliers varies depending on how busy the volume is. It can be as many as 20 files a day.
ActiveCell.FormulaR1C1 = "=IF(RC