Help Request: Linking Sheets 
Author Message
 Help Request: Linking Sheets

Hello All,

Most useful newsgroup!

I am a relative newbie using Excel but have the basics down pretty good.  
What I need some advice with is the following:

I track weekly revenue as a volunteer Treasurer at our local non-profit Golf Club.
I have been creating a new sheet for every week and would like to have a separate sheet that kept running totals of all the categories in each weekly sheet.  
As well as track revenue from various income sources I also pay a commission on each category and have Excel calculate that for me each week as well.  
What is the best way to create a 'Master' sheet that was linked to all the others?

Your suggestions will be greatly appreciated.



Thu, 14 Oct 2004 22:16:43 GMT  
 Help Request: Linking Sheets
Open new spreadsheet and use formulas like the following:

=sheet1!A13
= sheet1!z24*sheet1!A12


Hello All,

Most useful newsgroup!

I am a relative newbie using Excel but have the basics down pretty good.
What I need some advice with is the following:

I track weekly revenue as a volunteer Treasurer at our local non-profit Golf
Club.
I have been creating a new sheet for every week and would like to have a
separate sheet that kept running totals of all the categories in each weekly
sheet.
As well as track revenue from various income sources I also pay a commission
on each category and have Excel calculate that for me each week as well.
What is the best way to create a 'Master' sheet that was linked to all the
others?

Your suggestions will be greatly appreciated.



Thu, 14 Oct 2004 23:36:42 GMT  
 Help Request: Linking Sheets
Hi Daria,

I assume that all your weekly sheets have a standard format.  Create two new
sheets - rename them as "First" and "Last".  Drag these two worksheets so
that "First" is at the beginning of all your weekly sheets and "Last" is at
the end of your weekly sheets.

Create one more sheet with the same format as the other weekly sheets and
name it as "Summary".
See that this "Summary" is placed anywhere after the "Last" sheet.

The following formula in Cell A1 of "Summary" sheet will sum up all the A1
cells from "First" to "Last".

=SUM(FIRST:LAST!A1)

You can copy the above formula down, across to get the relative formulas.
And remember to place all your future weekly sheets anywhere between "First"
and "Last" sheets.

--
Regards,
Murthy


Hello All,

Most useful newsgroup!

I am a relative newbie using Excel but have the basics down pretty good.
What I need some advice with is the following:

I track weekly revenue as a volunteer Treasurer at our local non-profit Golf
Club.
I have been creating a new sheet for every week and would like to have a
separate sheet that kept running totals of all the categories in each weekly
sheet.
As well as track revenue from various income sources I also pay a commission
on each category and have Excel calculate that for me each week as well.
What is the best way to create a 'Master' sheet that was linked to all the
others?

Your suggestions will be greatly appreciated.



Fri, 15 Oct 2004 00:17:12 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Request for help transfering data between sheets

2. Request help linking data

3. Linking info in one sheet to another sheet

4. Macro to past link from Sheet 1 to Sheet 2

5. VBA to link cell on one sheet to cell on another sheet

6. Linked sheets - Insert rows in all sheets?

7. Linking Sheet Tab Name to Cell in Current Sheet

8. Excel Linked Sheet/Embedded Sheet

9. column A in sheet A linked to all sheets in workbook

10. need help linking drop down list to second sheet


 
Powered by phpBB® Forum Software © phpBB Group