View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Formula needs to include several worksheet tabs in one workbook

Hi

I would put
D:\GLOBAL X RAY\[customer price level4.xls]Sheet
into a cell, e.g. E1
then
=INDEX(INDIRECT("'"&E1&ROW(A1)&"'!$A2:$C2"),3)
Note the quotation marks

=INDEX(INDIRECT(" ' " &E1&ROW(A1)& " ' !$A2:$C2"),3)

This will evaluate to sheet 1 in the first instance, but as you copy
down the page, ROW(A1) will become B1, C1 etc and give rise to Sheet2,
Sheet3.
--
Regards

Roger Govier


"klafert" wrote in message
...
The problem is not the formula I use except for I need to specific a
range
that includes using more than one worksheet tab. Here is the formula
it
works for one worksheet because I only specifics one worksheet. I
just need
to know how to encode the range of the other worksheet tabs. first
worksheet
is sheet1 and goes through sheet16 in the same work book.

=INDEX('D:\GLOBAL X RAY\[customer price level4.xls]Sheet1'!$A2:$C2,3)
How do I edit this formula to include the other worksheet.