visual basic (copy and paste)

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Please post in only ONE group so as to not waste the time and effort of
those of us who may reply.
 
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..
 
You must log in or register to reply here.

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
Use Formula from another worksheet 3
help to copy and paste with VB 2
add hyperlink using sheet names and cells(i,j) 3
help to paste via visual basic 1
Finding and copying whole rows 1
Vlookup and return sheet name also 2
Copying cells from one sheet to another 5

Back
Top