How do I go about populating fields in an Excel worksheet for a particular field depending on the field's coordinates?
Ex:

| 200501|200502|200503|200504|200505|
---------------------------------------------------------------
Data1 | | 1 | | | 1 |
---------------------------------------------------------------
Data2 | 1 | | | | |
---------------------------------------------------------------

So I would populate field coordinates(Data1,200402) with a value of 1 if Data1 exists in 200502. The macro would take in the field coordinates (row,column) in this case (Data1,200502) and run the check in a database query.
Has anyone done anything similar like this before?
I would appreciate any help.