software

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 sheet1Somebody please point me in the right directionYou can do that with a VLOOKUP formula in column D.
See example cjoint.com/?demnBih7zj
amp; Excel help on VLOOKUP

HTH
--
AP

quot;bungiequot; gt; a écrit dans le message de
...
gt; I have been on a bit of a learning curve, Excel, Access, but VB has got me
gt; lost. Any idea's how I might go about the following please??
gt;
gt; I have two sheets, sheet1, and sheet2.
gt; In sheet1 at cell B1 I need to copy the numeric value, go to sheet2 find
the
gt; value in one of the cells. Then move two cells to right of it, and copy
that
gt; cell value. Move back to sheet1 select the cell D1 and paste.
gt; Then move to B2 copy the numeric value, go to sheet2 find the value in one
gt; of the cells. Then move two cells to right of it, and copy that cell
value.
gt; Move back to sheet1 select the cell D2 and paste.
gt; Then keep looping until I hit an empty B cell in sheet1
gt;
gt;
gt; Somebody please point me in the right direction
gt;
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

quot;Ardus Petusquot; wrote:

gt; You can do that with a VLOOKUP formula in column D.
gt; See example cjoint.com/?demnBih7zj
gt; amp; Excel help on VLOOKUP
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;bungiequot; gt; a écrit dans le message de
gt; ...
gt; gt; I have been on a bit of a learning curve, Excel, Access, but VB has got me
gt; gt; lost. Any idea's how I might go about the following please??
gt; gt;
gt; gt; I have two sheets, sheet1, and sheet2.
gt; gt; In sheet1 at cell B1 I need to copy the numeric value, go to sheet2 find
gt; the
gt; gt; value in one of the cells. Then move two cells to right of it, and copy
gt; that
gt; gt; cell value. Move back to sheet1 select the cell D1 and paste.
gt; gt; Then move to B2 copy the numeric value, go to sheet2 find the value in one
gt; gt; of the cells. Then move two cells to right of it, and copy that cell
gt; value.
gt; gt; Move back to sheet1 select the cell D2 and paste.
gt; gt; Then keep looping until I hit an empty B cell in sheet1
gt; gt;
gt; gt;
gt; gt; Somebody please point me in the right direction
gt; gt;
gt;
gt;
gt;

Thanks for the feedbacl

--
AP

quot;bungiequot; gt; a écrit dans le message de
news
gt; Ardus,
gt; Thanks a lot, typical newbie I was looking at it the hard way. Trying to
gt; move the active cell around, copying and pasting as it went. The way you
gt; pointed out works perfect.
gt;
gt; Again Thanks,
gt;
gt; Bungie
gt;
gt; quot;Ardus Petusquot; wrote:
gt;
gt; gt; You can do that with a VLOOKUP formula in column D.
gt; gt; See example cjoint.com/?demnBih7zj
gt; gt; amp; Excel help on VLOOKUP
gt; gt;
gt; gt; HTH
gt; gt; --
gt; gt; AP
gt; gt;
gt; gt; quot;bungiequot; gt; a écrit dans le message de
gt; gt; ...
gt; gt; gt; I have been on a bit of a learning curve, Excel, Access, but VB has
got me
gt; gt; gt; lost. Any idea's how I might go about the following please??
gt; gt; gt;
gt; gt; gt; I have two sheets, sheet1, and sheet2.
gt; gt; gt; In sheet1 at cell B1 I need to copy the numeric value, go to sheet2
find
gt; gt; the
gt; gt; gt; value in one of the cells. Then move two cells to right of it, and
copy
gt; gt; that
gt; gt; gt; cell value. Move back to sheet1 select the cell D1 and paste.
gt; gt; gt; Then move to B2 copy the numeric value, go to sheet2 find the value in
one
gt; gt; gt; of the cells. Then move two cells to right of it, and copy that cell
gt; gt; value.
gt; gt; gt; Move back to sheet1 select the cell D2 and paste.
gt; gt; gt; Then keep looping until I hit an empty B cell in sheet1
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Somebody please point me in the right direction
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;