Thread
:
copy and paste (visual basic)
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
copy and paste (visual basic)
This would have been the best place to post. Pls STOP multiposting
--
Don Guillett
SalesAid Software
"ian123" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett