copy and paste (visual basic)

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
 

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

help to paste via visual basic 1
visual basic (copy and paste) 2
help to copy and paste with VB 2
copy range and paste into every 3rd cell of new range 4
Excel VBA to move cells to sheet2 based on selection in sheet1 0
If match copy cells in visual basic. 3
Very strange behaviour of VLOOKUP in Excel 2010 4
Variable Frame Reference 1

Top