Looping between sheets picking up values on the way

G

Guest

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
 
G

Guest

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
 
A

Ardus Petus

Thanks for the feedbacl

--
AP

bungie said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

add hyperlink using sheet names and cells(i,j) 3
Excel VBA to move cells to sheet2 based on selection in sheet1 0
If function across sheets prints value of cell 4
Cell highlighting question 4
comparing two sheets og copy value 8
Compare and copy/paste 1
Countif and sumif combination problem 2
Autofill link to another sheet 1

Top