ExcelBanter - copy and paste (visual basic)

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - copy and paste (visual basic) (https://www.excelbanter.com/new-users-excel/92756-copy-paste-visual-basic.html)

ian123

copy and paste (visual basic)

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

Dave Peterson

copy and paste (visual basic)

You have a bunch of responses at the other locations of your posts.

ian123 wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 11:20 AM.