NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON
 

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 SNDNG QTY TNKS SNDNG QTY
1C 20 100 1C
20 100
2C 15 200 2C
15 200
4C 25 300 4C
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.

NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND C
 

Try recording what you want to do into a macro recorder and modify that.

"CAPTGNVR" wrote:

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 SNDNG QTY TNKS SNDNG QTY
1C 20 100 1C
20 100
2C 15 200 2C
15 200
4C 25 300 4C
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.

NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON
 

a few questions:

1. i see 1c, 2c, and 4c are all in the same rows in col A and Col X. is that
always the case?
2. in your example, you want to paste a link from col Z to col D, but col Z has
no value, it's blank. is this the case?


--


Gary


"CAPTGNVR" wrote in message
ups.com...
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 SNDNG QTY TNKS SNDNG QTY
1C 20 100 1C
20 100
2C 15 200 2C
15 200
4C 25 300 4C
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.