I want to read data for a parameter P(x,y) from excel file. The parameter is two dimensional.
And the data lies in one of the sheet(say Demand) of a excel file(say DataFile).
I have tried ReadList but it is not working as the range of x lies in A2:A50 and the range of y lies in E2:E50 and data lies in T2:T50.
Help me to read the data with out creating another sheet.
Best answer by MarcelRoelofsView original