asked on

EXCEL AND INTERACTIVE PICTURE

Hi,

I'm working with a spreadsheet which have a Picture of some buildings We are working on. (Google Earth Picture)

Below the Picture, the cells are filled as a Data Base showing information regarding some Structural Problems located in those Buildings and in the Comun areas:
Column A is Problem Nº, Column B is the Problem, Column C , D and E are different repair costs and so on...

What I need is when the User click a cell in column A the Picture Shows (a rectangle, cirlce or whatever) in the Picture indicating the place where the problem is.

Is this possible ?... could you help me please ?

Thank you for your time.
Roberto.

patrickab

Pabilio,

Yes, it can be done but it would be specific to your picture and your workbook, so it needs to be done on your file. Thus please upload your file.

Once it is done, if the picture is re-sized then the whole set up would have to be re-done. It not the easiest way to do it.

It would be better to have numbered circles which relate to the items in your worksheet.

Patrick

Pabilio

ASKER

Here is the file...
Sorry for the delay...
Roberto.
INTERACTIVE-PICTURE.xls

ASKER CERTIFIED SOLUTION

patrickab

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Pabilio

ASKER

Hi Patrick,

You gave me a better solution than the one I asked here...

The pictures in Comments fit perfectly with what I´m doing.

Thank you very much...

Roberto.

patrickab

Roberto - I thought you'd like them. Thanks for the grade. Hope you like my picture from the Forbidden City. - Patrick

Pabilio

ASKER

The picture is very nice... and the roof is in better shape than the lot We have to fix... even when is a little bit older.
Thank you again for your idea.
Roberto.