LINKING WORKSHEET RESULTS

UMR67 · May 9th, 2002, 10:39 AM

Each week I create a spreadsheet of sales, revenue, costs, etc. How can I create a monthly summary spreadsheet that adds the weekly cell figures from previous sheets of the same format into a monthly summary sheet?

Aladin Akyurek · May 9th, 2002, 10:41 AM

Quote:

On 2002-05-09 09:39, UMR67 wrote:
Each week I create a spreadsheet of sales, revenue, costs, etc. How can I create a monthly summary spreadsheet that adds the weekly cell figures from previous sheets of the same format into a monthly summary sheet?

You could use some functions that can be used as 3d-functions like in:

=SUM(Sheet1:Sheet10!B4)

Mark W. · May 9th, 2002, 11:16 AM

See the Excel Help topic for "Consolidate data".

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 10:39 AM	#1
UMR67 New Member Join Date: May 2002 Location: CHARLOTTE, NC Posts: 1	Each week I create a spreadsheet of sales, revenue, costs, etc. How can I create a monthly summary spreadsheet that adds the weekly cell figures from previous sheets of the same format into a monthly summary sheet?

May 9th, 2002, 11:16 AM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	See the Excel Help topic for "Consolidate data".