Why not use a pivot table. Pace you rcursor in the middle of the data and
select Data - Pivot Table - follow the wizard (or just choose finish as XL
will normally make all of the correct assumptions).

Place the X's in the left column and the Y's across the top and the values
in the middle...
--
HTH...

Jim Thomlinson


"A" wrote:

Hello,
I have a problem here in Italy...

I have this collection (array):

id name_x name_y value
--- ------------ ----------- --------
1 alfa beta 10
2 beta gamma 100
3 gamma gamma 1000
.... ........... .......... ...........

And I have this blank Excel file (only the name of the first row and
column):

alfa beta gamma
--------------------------------------
alfa
beta
gamma


I need to search for the exact coordinates and put the value in the
collection in the excel file...like this:

alfa beta gamma
-------------------------------------------
alfa 10
beta 100
gamma 1000


Is there any simple code to do that?.
Thank you in advance.

Ale.