Show values from another worksheet

[DellHater]

Hi
Had a request from a colleague to do the following.
We have an excel workbook with many sheets.
Many of them are linked together, but not in the workbook.
Basically, if you get a value on sheet 1, the actions to be taken for the value in sheet 1 are in sheet 2.
They want the actions from sheet 2 to be visible in sheet 1.
The whole workbook is a generated report, so this is something that will have to be done after the report is generated.

From looking at the report, I was wondering the best way to approach this.
Is it possible to have a 'pop up' window showing the values from sheet 2 if I click on the cell containing the value in sheet 1 ?
The other alternative, is to create a macro to insert the actions from sheet 2 in to sheet 1.
I prefer option 1 if it is possible.........

thanks in advance

 

[SkipVought]

Hi,

Why not just reference the sheet2 cell on sheet1? NO VBA REQUIRED!
[tt]
=Sheet2!A1
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[DellHater]

Cheers for that Skip, but its not that simple.
I've come up with an idea and have been searching for a way to do it on the web but can't find anything as yet.

Is this possible ?

I've tried vlookup and this works, but i need to return more than one value.
anything up to 15 values.


Click a cell then press ctrl +q to run a macro which does ..........

returnd the values in the 2nd sheet, but formatted in the active cell comment in sheet 1 ?

 

[SkipVought]

What is the structure of the data in the sheet from which you are obtaing data? Is it a PROPER TABLE? If it is, you can use a query, either via MS Aquer in another sheet or via ADODB and build a string of the accumulated value to assign to your one cell.

Otherwise, concatenate your lookup formulas to construct a string.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]