visual basic (copy and paste)

G

Guest

i need to copy and paste addresses from on sheet to another depending on the
cell value
EXAMPLE:

IF cell a2 on sheet 1 says "1" then copy the address (cells a1 to a5 on sheet
1) to cells d1 to d5 on sheet 2

if cell A2 on sheet 1 says "54" then copy THAT address (cells a1 to a5 on
sheet 1) to cells d10 to d15 on sheet 2
ANYONES HELP WOULD BE VERY APPRECIATED thanks
 
D

Don Guillett

Please post in only ONE group so as to not waste the time and effort of
those of us who may reply.
 
B

Bearacade

Is it just me or is your value doesn't make any sense?

if value is 1, paste Sheet1(A1:A5) to Sheet2(D1:D5)
if value is 54, Past Sheet1(A1:A5) to Sheet2(D10:D15)

How does 1 relate to D1:D5 and 54 relate to D10:D15?

and A1:A5 is a range of 5 cells, D10:D15 is a range of 6 cells..
 

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

copy and paste (visual basic) 1
help to copy and paste with VB 2
help to paste via visual basic 1
Finding and copying whole rows 1
Copying cells from one sheet to another 5
Copy non merged to merged cells again 1
Copying a cell ref. down a column, changing worksheet # along the 5
Copy paste non merged to merged cells 1

Top