Linking Sheets within a workbook?

Melissa823

New Member
Joined
Jun 8, 2007
Messages
3
Hi All!

Question for you! :)

I have 6 sheets in a workbook. Several cells in 5 of those sheets, I need to link to the sixth sheet. Is there anyway that I can link these as a group instead of linking each indiviudal cell? I would say that I have a couple hundred, and doing them individually makes my head hurt! :)

Please help!
TIA!
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

PATSYS

Well-known Member
Joined
Mar 12, 2006
Messages
1,750
2 questions:

1. When you said you need to link several cells of the 5 sheets to the 6th sheets, did you mean summing those cells in the 6th sheet or what kind of linking are you referring to?

2. Are the formats in all the sheets the same e.g. you are linking cell J10 of the 6th sheet to cell J10 of the other 5 sheets?
 

Melissa823

New Member
Joined
Jun 8, 2007
Messages
3
Yes, I need to link them together to come up with a Sum on the final sheet.

Yes, the formats are the same in each sheet.

TIA! :biggrin:
 

PATSYS

Well-known Member
Joined
Mar 12, 2006
Messages
1,750
Assuming your sheetnames are:

Sheet1
Sheet2
Sheet3
Sheet4
Sheet5
Sheet6

In Sheet6, e.g. cell J10, enter this formula:

=SUM(Sheet1:Sheet5!J10)

That will sum up all the values in cell J10 of Sheets1 to Sheet5. Copy down or up as necessary.

The key here is the arrangement of the sheet. Sheet1 must come first and Sheet5 must be at the other end (just before Sheet6). Sheet6 must not be in between those sheets.

Hope I have explained it clearly..
 

Forum statistics

Threads
1,181,648
Messages
5,931,213
Members
436,784
Latest member
amuljono

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top