ExcelBanter - Help in syntax

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Help in syntax (https://www.excelbanter.com/excel-programming/379689-help-syntax.html)

Anna

Help in syntax

Hi: Can any one please correct the syntax as i am trying to copy cell
A2 of sheet SALE0105 from file Sales_1106 ROLLING Y-T-D-New into file
Formulas of sheet SALE0105 into cell A2

=[Formulas.xls]SALE0105!A2(Formulas.xls,SALE0105,A2 with Sales_1106
ROLLING Y-T-D-New, SALE0105,A2)

Thanks,

All times are GMT +1. The time now is 02:29 PM.