NEED VB FOR PASTING THE CELL REFERENCE

[CAPTGNVR]

DEAR ALL

Need to do the follwing:
1. Say in col.A: A specific item like say '4center' is picked from
the columns. (to find what item is '4center')

2. Then pick from the same COL-C which has the 'sounding'.
(selection.copy)

3. Then should goto another location COL-X where details for
'4center' is stored and select the '4center ' and then in that row
goto COL-Y and replace the new sounding COPIED FROM COL-C, which
should paste as a link .

4. Then in the same row, must select COL-Z which gives quantities for
the new sounding. (selection.copy)

5. come back to col.A to '4center' row and insert the link in the COL-
D.

example:
COL-A COL-C COL-
D COL-X COL-Y
COL-Z
TANKS SOUNDING QUANTITY TANKS SOUNDING QUANTITY
1CENTER 20 100 1CENTER
20 100
2CENTER 15 200 2CENTER
15 200
4CENTER 25 300 4CENTER
25 300

Hope it is explained well.

Last two days I have been struggling to eliminate paste link error.

In short need to pick from col-A; goto col-X and locate match.
Then copy the cell next to '4center' and goto col-y and paste the
link.
Then goto next cell col-Z and copy and put it as past link in col-D.
pls help me with VB. Mine is giving error unable to paste error.