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

G

Guest

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
 
J

JE McGimpsey

One way:

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

=Sheet1!MyRange
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Multiple sheet querries 4
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
Importing The Excel Sheet I choose 4
Cannot get previous data after ctrl + w 0
Conditional formatting on a dynamic range - workaround 1
How can I update my charts x axis (dates) automatically with new d 1
SUMIF or SUMIFS help 1

Top