ExcelBanter - how to read the data from -- Excel sheet

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how to read the data from -- Excel sheet (https://www.excelbanter.com/excel-worksheet-functions/126267-how-read-data-excel-sheet.html)

Manmohan Singh

how to read the data from -- Excel sheet

hi All

how to read the data from Excel sheet.i have Range name, Sheet name.
how i can pickup data according to the range name........

Thanks
Manmohan Chauhan

JE McGimpsey

how to read the data from -- Excel sheet

One way:

Assume Sheet name = "Sheet1", Range name = "MyRange":

=Sheet1!MyRange

In article ,
Manmohan Singh wrote:

hi All

how to read the data from Excel sheet.i have Range name, Sheet name.
how i can pickup data according to the range name........

Thanks
Manmohan Chauhan

All times are GMT +1. The time now is 09:55 AM.