Values between Work Sheets

[Pete Watters]

I have 6 work sheets, each work sheet calculates values I
would like placed in specific cells in other work sheets.

can this be done, if so how can I do it or could you
direct me to documentation that will tell me how to do it.

 

[Norman Harker]

Hi Pete!

The standard approach is to use the form:
='Budget 2003'!A1
Note the use of the single quote to enclose the sheet name. If there
are no spaces in the name, these aren't necessary but it's a good
habit to get into.
If you leave them out and there are no spaces, no problem if you
change the sheet name and use one with spaces because Excel will do it
for you.
But if you attempt a "hand written" entry where the quotes are
necessary, it will all end in tears with a request for a file name and
canceling leading to a dreaded #NAME?

If you are in, say Sheet1 and want to bring in data from A1 of Sheet2:

Type =
Navigate to Sheet2 and point to A1 and left click
Press Enter

The syntax for a multiple sheet addition of the same cells is:

=SUM('2003 Jan:2003 Dec'!B14)

This will sum all entries in B14 in the sheets between 2003 Jan and
2003 Dec. Note that punctuation very carefully.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 15th July: Holidays and Observances
Tuesday 15th July: Brunei Darussalam (Sultan's Birthday); Ukraine
(Holy Trinity); United Kingdom (St. Swithin's Day); Observances: O-Bon
/ Festival of Souls (Shinto)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.