Calulations between two worksheets

**kaziba** · 10-13-2007, 05:34 PM

I have created two worksheets. I need to calculate between them.example:=Purchase bhwf26-paymentc2
Purchasebhw is one worksheet and payment is other. Please tell me the formula for it coz mine is not working.

**Paul** · 10-13-2007, 07:17 PM

I have created two worksheets. I need to calculate between them.example:=Purchase bhwf26-paymentc2
Purchasebhw is one worksheet and payment is other. Please tell me the formula for it coz mine is not working.\

Hi kaziba,

Try this one:

Please Login or Register  to view this content.

If your sheet name has a space in it, surround it with single quotes, like so:

Please Login or Register  to view this content.

**kaziba** · 10-14-2007, 02:59 PM

thanks Paul it works.

**VBA Noob** · 10-14-2007, 04:44 PM

Closed for cross posting.

Please read forum rules below

VBA Noob

Calulations between two worksheets

LinkBack

Thread Tools

Display

Calulations between two worksheets

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions