Posted to microsoft.public.excel.misc

1S2RSK

external usenet poster

Posts: 2

Formula - Referencing Between Worksheets

I have searched the help-base, and to no avail...the easiest of tasks perhaps
and I cannot get it right.

I have a column that ends in a sum (such as B2 though B 29 equals B30 on
WORKSHEET 1). I want that value to show in a box in Worksheet 2. Since B30
is a formula in itself, each time I tinker with it, I get REF errors of
sorts, and no idea how to get it right.

Any suggestions???

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Referencing worksheets	jbaldwin	Excel Discussion (Misc queries)	2	July 4th 07 10:11 PM
Array formula referencing other worksheets	broderp	Excel Worksheet Functions	1	December 8th 06 09:27 PM
Referencing worksheets	yukon_phil	Excel Discussion (Misc queries)	5	September 1st 06 08:25 PM
Formula Referencing data on multiple worksheets	ChrisPrather	Excel Worksheet Functions	6	August 22nd 06 05:14 AM
Referencing Worksheets	Cincy	Excel Discussion (Misc queries)	4	July 19th 06 08:59 PM

All times are GMT +1. The time now is 05:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us