moving numbers from one sheet to another sheet in a work book

[peugenej]

Im using excell 2007.I have a number total in cell b40 sheet #2 I would like to copy that number to cell g5 sheet # 1 to be added to a total on that sheet and I am not sure how to do this. Would someone be able to help me with this. Thank you

 

[dave3009]

Try

With Sheet1.Range("G5")
.Value = .Value + Sheet2.range("B40").Value
End With

 

[Dryver14]

as formula

in G5 on sheet 1 input

=sheet2!B40

 

[peugenej]

I enter sheet2!b40 and I got #ref!. I didnt get the number that was in b40. Im using excell 2007 with windows xp I thought that would work.I think its something like that. Thank you

 

[dave3009]

You need to use VBA for this type of thing. This is not something a worksheet function can do.

 

[peugenej]

this formula worked =sheet2!B40. I changed the sheet name to budget and when I change to =budget2!b40 it worked fine. Sorry i left that change out. Thank you very much.