macro help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

squiggle - 23 Aug 2006 05:50 GMT

Hi I want to setup a macro that will send information from Sheet2 cell A5 to
Sheet1 cell B4.

Can anyone please help with the formula required to send the reqd info?

Reply to this Message

Muhammed Rafeek M - 23 Aug 2006 06:33 GMT

Sub SendInfo()

Sheet1.Range("B4").value= Sheet2.Range("A5").value

end sub

you can also use link: Enter =Sheet2!A5 into Sheet1 cell B4

> Hi I want to setup a macro that will send information from Sheet2 cell A5 to
> Sheet1 cell B4.
>
> Can anyone please help with the formula required to send the reqd info?

Reply to this Message

Adarsh - 23 Aug 2006 07:45 GMT

Good!!!

> Sub SendInfo()
>
[quoted text clipped - 8 lines]
> >
> > Can anyone please help with the formula required to send the reqd info?

Reply to this Message