Excel Subtotal Data from multiple worksheets - CR4 Discussion Thread

Home

Products & Services

Engineering News

Standards

Webinars

Engineering Forum

Login

CR4 Home | Software & Programming | Software & Programming

Rate

Comments: Nested

Anonymous Poster	Excel Subtotal Data from multiple worksheets 03/03/2009 10:17 AM
	I have an excel workbook with multiple worksheets. Similar equipment is on each worksheet. What is easiest way to get subtotal of all similar equipment on one sheet
	Reply

Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Join CR4, The Engineer's Place for News and Discussion!

Richard L Power-User Join Date: Feb 2007 Location: Oregon Posts: 292 Good Answers: 4	#1 Re: Excel Subtotal Data from multiple worksheets 03/03/2009 12:03 PM
	Easy...create a link to the data. Lets say you want to see data from sheet 3 cell A3 on sheet 1 cell B4. Find cell B4 on sheet 1 and type =Sheet3!A3 repeat as needed. OR Open Excel then the Help file and search for 'creating links", you will find several examples.
	Reply

You might be interested in: Perforated and Expanded Sheet Materials, Metal Sheet, Sheet Metal Fabrication Services

	Got Something to Say?
	Ask a Question Start a Discussion

	Search this Forum
	Software & Programming: Go

CR4 Sections

	Aerospace
	BioMech & BioMed
	Chemical & Material Science
	Civil Engineering
	Communications & Electronics
	Education and Engineering Careers
	Electrical Engineering
	General Discussion
	Instrumentation
	Manufacturing
	Mechanical Engineering
	New Technologies & Research
	Software & Programming
	Sustainable Engineering
	Transportation

	Site Directories
	Forum Directory Blog Directory User Group Directory RSS Feeds CR4 Rules of Conduct CR4 FAQ Site Glossary Who's Online (158 right now) Show Members