visual basic (copy and paste)

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.

--
Don Guillett
SalesAid Software
[email protected]
"ian123" <[email protected]> wrote in message
news:[email protected]...
>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