Looping between sheets picking up values on the way
 

I have been on a bit of a learning curve, Excel, Access, but VB has got me
lost. Any ideas how I might go about the following please??

I have two sheets, sheet1, and sheet2.
In sheet1 at cell B1 I need to copy the numeric value, go to sheet2 find the
value in one of the cells. Then move two cells to right of it, and copy that
cell value. Move back to sheet1 select the cell D1 and paste.
Then move to B2 copy the numeric value, go to sheet2 find the value in one
of the cells. Then move two cells to right of it, and copy that cell value.
Move back to sheet1 select the cell D2 and paste.
Then keep looping until I hit an empty B cell in sheet1


Somebody please point me in the right direction

Looping between sheets picking up values on the way
 

You can do that with a VLOOKUP formula in column D.
See example http://cjoint.com/?demnBih7zj
& Excel help on VLOOKUP

HTH
--
AP

"bungie" a écrit dans le message de
...
I have been on a bit of a learning curve, Excel, Access, but VB has got me
lost. Any idea's how I might go about the following please??

I have two sheets, sheet1, and sheet2.
In sheet1 at cell B1 I need to copy the numeric value, go to sheet2 find
the
value in one of the cells. Then move two cells to right of it, and copy
that
cell value. Move back to sheet1 select the cell D1 and paste.
Then move to B2 copy the numeric value, go to sheet2 find the value in one
of the cells. Then move two cells to right of it, and copy that cell
value.
Move back to sheet1 select the cell D2 and paste.
Then keep looping until I hit an empty B cell in sheet1


Somebody please point me in the right direction

Looping between sheets picking up values on the way
 

Ardus,
Thanks a lot, typical newbie I was looking at it the hard way. Trying to
move the active cell around, copying and pasting as it went. The way you
pointed out works perfect.

Again Thanks,

Bungie

"Ardus Petus" wrote:

You can do that with a VLOOKUP formula in column D.
See example http://cjoint.com/?demnBih7zj
& Excel help on VLOOKUP

HTH
--
AP

"bungie" a écrit dans le message de
...
I have been on a bit of a learning curve, Excel, Access, but VB has got me
lost. Any idea's how I might go about the following please??

I have two sheets, sheet1, and sheet2.
In sheet1 at cell B1 I need to copy the numeric value, go to sheet2 find
the
value in one of the cells. Then move two cells to right of it, and copy
that
cell value. Move back to sheet1 select the cell D1 and paste.
Then move to B2 copy the numeric value, go to sheet2 find the value in one
of the cells. Then move two cells to right of it, and copy that cell
value.
Move back to sheet1 select the cell D2 and paste.
Then keep looping until I hit an empty B cell in sheet1


Somebody please point me in the right direction

Looping between sheets picking up values on the way
 

Thanks for the feedbacl

--
AP

"bungie" a écrit dans le message de
...
Ardus,
Thanks a lot, typical newbie I was looking at it the hard way. Trying to
move the active cell around, copying and pasting as it went. The way you
pointed out works perfect.

Again Thanks,

Bungie

"Ardus Petus" wrote:

You can do that with a VLOOKUP formula in column D.
See example http://cjoint.com/?demnBih7zj
& Excel help on VLOOKUP

HTH
--
AP

"bungie" a écrit dans le message de
...
I have been on a bit of a learning curve, Excel, Access, but VB has
got me
lost. Any idea's how I might go about the following please??

I have two sheets, sheet1, and sheet2.
In sheet1 at cell B1 I need to copy the numeric value, go to sheet2
find
the
value in one of the cells. Then move two cells to right of it, and
copy
that
cell value. Move back to sheet1 select the cell D1 and paste.
Then move to B2 copy the numeric value, go to sheet2 find the value in
one
of the cells. Then move two cells to right of it, and copy that cell
value.
Move back to sheet1 select the cell D2 and paste.
Then keep looping until I hit an empty B cell in sheet1


Somebody please point me in the right direction