View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
A[_4_] A[_4_] is offline
external usenet poster
 
Posts: 5
Default Is there a simple function code to do it?.

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.