macro help

[squiggle]

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?

 

[Muhammed Rafeek M]

Sub SendInfo()

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

end sub

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

 

[Adarsh]

Good!!!

Sub SendInfo()

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

end sub

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