I need to have in the same cell; data from 3 differents reports. And be able
to "easily" swich wich report I want the data from on that cell.

ie: cell "A1" has the "Report 1" data, but now I want in the same cell (A1)
to have the report 2 data.

Report 1 and Report 2 have almost the same data but in different locations.
That's why I was trying to avoid creating a pivot table.

Of course the data in cell A1 means the same for both reports.

Thank you

Hi Hernan,

Suppose the data you want to display is in Sheet2!A5, Sheet3!B10 and
Sheet4!M20

In cell A1 on sheet1 enter the following formula:

=CHOOSE(A2,Sheet2!A5,Sheet3!B10,Sheet4!M20)

In cell A2 enter 1, 2, or 3. The formula will return the data from the 1st,
2nd or 3rd range referenced in the choose function.

You can give them a drop down list in A2 using Data Validation.

There are many other ways to impliment this idea, for example your drop down
list could be a list of the sheet names and you could employ the INDIRECT
function within the choose function.
--
Cheers,
Shane Devenshire


"HERNAN" wrote:

I need to have in the same cell; data from 3 differents reports. And be able
to "easily" swich wich report I want the data from on that cell.

ie: cell "A1" has the "Report 1" data, but now I want in the same cell (A1)
to have the report 2 data.

Report 1 and Report 2 have almost the same data but in different locations.
That's why I was trying to avoid creating a pivot table.

Of course the data in cell A1 means the same for both reports.

Thank you

Thank you so much Shane!
I just realize I didn't mention that I need more than one cell. So I think
the "choose" formula won't be the most appropiate one.

The spread that I need has 100 cells aprox that I need to be feed from this
reports
What I need is once I select "Report 1" all the cells must display the data
from that report only.

I think that drop down display idea you told me could be the best one. Do
you think you can tell me how it works, thank you for all your help!!

Hernan


"ShaneDevenshire" wrote:

Hi Hernan,

Suppose the data you want to display is in Sheet2!A5, Sheet3!B10 and
Sheet4!M20

In cell A1 on sheet1 enter the following formula:

=CHOOSE(A2,Sheet2!A5,Sheet3!B10,Sheet4!M20)

In cell A2 enter 1, 2, or 3. The formula will return the data from the 1st,
2nd or 3rd range referenced in the choose function.

You can give them a drop down list in A2 using Data Validation.

There are many other ways to impliment this idea, for example your drop down
list could be a list of the sheet names and you could employ the INDIRECT
function within the choose function.
--
Cheers,
Shane Devenshire


"HERNAN" wrote:

I need to have in the same cell; data from 3 differents reports. And be able
to "easily" swich wich report I want the data from on that cell.

ie: cell "A1" has the "Report 1" data, but now I want in the same cell (A1)
to have the report 2 data.

Report 1 and Report 2 have almost the same data but in different locations.
That's why I was trying to avoid creating a pivot table.

Of course the data in cell A1 means the same for both reports.

Thank you