Multiple spreadsheet formula

Yippy_Kiyey

Board Regular
Joined
Sep 28, 2008
Messages
96
I have a spreadsheet that has 51 tabs. The first tab is a summary page of the other 50 tabs. The columns are identical but the rows are not although they contain similar information. I need to summarize this tabs by bringing or linking certain total onto the summary page. Right I do that by using the "=" sign, but it takes so much time and very prone to errors. I want a formula that will link all the totals that I can copy across or down. This will be more efficient and accurate. Below is an example.

Excel Workbook
ABCDE
2Tab1 - Summary
3FundedJanFebetc
4101
5102
6103
7Total Funded
8
9Not Funded
10101
11102
12103
13Total Not Funded
14
15
16Tab-Proj 101
17Funded
18ItemsJanFebetc
19AAA1011
20BBB1011
21CCC1011
22Total Funded3033
23(Link this total to line 6 Tab1 - Summary)
24
25Not Funded
26Items
27AAA58
28BBB55
29CCC33
30Total not funded1316
31(Link this total to line 12 Tab1 - Summary)
32
33Tab-Proj 102
34Funded
35ItemsJanFebetc
36DDD
37EEE
38Total Funded
39(Copy this total to line 7 Tab1 - Summary)
40Not Funded
41Items
42DDD
43EEE
44Total not funded
45(Copy this total to line 13 Tab1 - Summary)
Sheet1
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Edit: Because I deleted some rows, the row number got messed up, ie, line 23 should read "link this total to line 4 tab 1 summary". Line 31 should say line 10 and so on and so forth.
 
Upvote 0

Forum statistics

Threads
1,221,574
Messages
6,160,602
Members
451,657
Latest member
Ang24

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
Back
Top