Using a formula to carry totals from 1 sheet to another

MS EXCEL

    Sponsored Links

    Next

  • 1. Insert Worksheets from List in Another Worksheet
    I list of names in column A of a Worksheet. I want to create a series of worksheets in another document using that list of names, all with the same format as the main sheet. Is there a way to do that?
  • 2. OR function with MATCH ?
    How would I use MATCH with the ability to set multiple variables for the match? My formula is: =INDEX('Due Now'!$A$2:$K$662,MATCH($B45&"Alpha"&"current",'Due Now'!$B$2:$B$600&'Due Now'!$E$2:$E$600&'Due Now'!$I$2:$I$600,0),10) My formula will lookup "B45AlphaCurrent". But I want the Alpha part to be either "Alpha" OR "Bravo" in this formula. Any thoughts? Thanks in advance.
  • 3. Entering date as MM/DD/YY no longer works, why?
    Hi all, Up until about a week ago I've been able to enter dates as mm/dd/yy and the cell would display it in what ever format it was set for. Example I enter the date 8/27/09 and based my settings it would display 2009-08-27. This stopped working for some reason. Now I have to enter the date with the year fist such as yy/mm/dd or yy-mm-dd. If I enter the month first and the dat second with the year last it displays what I type and pays no attention to the cell formatting. I found this problem to exist on both my excel 2003 and 2007. If I open the work book on a different computer the problem does not exist. I repaired the install and ran diag, but it did not fix it. I even uninstalled Office 03 and 07 and reinstalled, problem still exist. The machine I am having this problem on is XP Pro SP3. I don't have this problem with Excel 2007 running XP Pro SP2 or Win7 Ent. As this exist in both '03 and '07 I am thinking it has something to do with the OS. Any ideas?
  • 4. Trouble adding text in 2009-2010 academic calendar
    Hello, I downloaded the 2009-2010 academic calendar (Aug-Aug, Mon-Sun) and I can only add one line of text in a box. I run an at home daycare and I have used calendar templates in the past that allowed me to fill up each individual square with the names of each child i watched for the day. This one only lets me put on one name and then the rest disappear. IS there anyway to add more names so they are on individual lines in each box? Thanks for any help you can offer. Sincerely, Nikki
  • 5. Connections with multiple worksheets
    I am in a small office environment and have NO desire to learn Access. We have an Excel 2007 spreadsheet used by 3 people on a network with a number of formulas and about 4 worksheets. Obviously it gets annoying telling people to close the spreadsheet all the time to unlock it for editing. Consequently, I'd like to break it up into several different spreadsheets (we each manage our own files) which are linked to a master spreadsheet. Basically, I want to create a master sheet with connections to all three documents, which consolidates them into one list. I leave blank space to add information for new clients, but I don't want to copy the blank space into the master spreadsheet. Furthermore, I don't want to have blank space in between my linked tables. How do I draw data from all three sources and put it into one big table? For the record, the majority of this data is text and consequently, a PivotTable will not work. Please let me know what options are available to me.

Using a formula to carry totals from 1 sheet to another

Postby S0dCMDAz » Mon, 11 May 2009 02:10:01 GMT

I use the formula ='[RENT-EXCEL 2009.xlsx]APR09'!N2 to carry amounts from one 
workbook sheet to another.  My problem is I have 83 amounts to carry over and 
I have to do each one seperately by changing the "N" line number each time 
and then I have to verify my worksheet name for each entry.

Is there an easier way.

RE: Using a formula to carry totals from 1 sheet to another

Postby SmFjb2IgU2thcmlh » Mon, 11 May 2009 02:16:26 GMT

Copying that formula down will change the reference to N3,4,.... If you are 
not looking for a continuous reference, please let us know whats the next row 
to be referred after 2....


If this post helps click Yes
---------------
Jacob Skaria






Re: Using a formula to carry totals from 1 sheet to another

Postby RagDyeR » Mon, 11 May 2009 02:23:54 GMT

2 questions:

After N2, which direction are you looking to copy *from*, across (O2),
OR down (N3)?

On the second sheet, which direction are you looking to paste *to*;
down or across?
-- 

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------





I use the formula ='[RENT-EXCEL 2009.xlsx]APR09'!N2 to carry amounts from 
one
workbook sheet to another.  My problem is I have 83 amounts to carry over 
and
I have to do each one seperately by changing the "N" line number each time
and then I have to verify my worksheet name for each entry.

Is there an easier way. 



Similar Threads:

1.carrying entire row to another sheet using vlookup

Hi,

I would like to use a vlookup function but instead of bringing back one
cell (for example 3rd cell to the right of the value) I would like to
bring back an entire column. How do I do that?

Thanks,

Mike

2.setting a formula in cell on a totals sheet using VB

Need Help,

I have a Totals sheet with several worksheets that represent projects. The
number of worksheets(projects) will be added or deleted depending on project
completions. 

What I'm trying to do is have a Macro to run that will count the number of
worksheets (since the number is not constant) and force the formula -
+ 'sheetName" !B2 + 'sheetName' !B2 - into cell B2 on the Totals sheet.
Can anyone help

3.Carrying formulas from one sheet to the next within the same file

I have 52 tabs set up, one for each week of the year.  I enter data in the 
top of my grid on one sheet and I want it to add it to the cumulative total 
below.  Each week I want to copy and paste the grid with formulas to the next 
week (worksheet) but it is not carrying over the formulas.  I have the name 
of the referenced sheet in quotes in the formula.  How do I overcome this so 
I do not have to plug in the formulas every week?  Thanks in advance.

4.carrying over a column formula from one sheet to another copie

Thanks again Pete,  BTW, I checked out the cpearson.com link and found it 
very helpful too.  Thanks for that tip!  Carl

"Pete_UK" wrote:

> Assume you only have one sheet - Sheet1 - and that you are using
> columns A, B and C starting in row 2, allowing a row for headings. You
> can copy the sheet into the same workbook by CTRL-drag, i.e. hold the
> CTRL key down and drag the tab of Sheet1. Rename this second sheet as
> Sheet2, and in A2 enter this formula:
> 
> =Sheet1!C2
> 
> Copy this formula down for as many items as you have in Sheet1. You
> might like to clear all the data from column B of this sheet.
> 
> Now, copy Sheet2 using CTRL-drag and rename it to Sheet3. Highlight
> column A of Sheet3 and press CTRL-H (same as Edit | Replace) and enter
> these:
> 
> Find What:        Sheet1
> Replace With:    Sheet2
> 
> Click Replace All.
> 
> You can repeat this procedure until you have enough sheets.
> 
> Hope this helps.
> 
> Pete
> 
> Carl wrote:
> > I have a worksheet that has three columns all part of a formula.  Very
> > simple, the first column is the beginning subtotal, the second is any
> > additional numbers, the last column is the total of the two previous columns.
> >
> >
> > I want to make copies of the master sheet and carry over the total from one
> > sheet to the next copied sheet, however I need the numbers in the Total
> > column to end up in the Subtotal column of the copied sheet, and so on with
> > multiple copies.
> > 
> > Can this be done?
> > 
> > Thank you for your valued suggestions!  Carl
> 
> 

5.carrying over a column formula from one sheet to another copied sh

I have a worksheet that has three columns all part of a formula.  Very 
simple, the first column is the beginning subtotal, the second is any 
additional numbers, the last column is the total of the two previous columns. 
 

I want to make copies of the master sheet and carry over the total from one 
sheet to the next copied sheet, however I need the numbers in the Total 
column to end up in the Subtotal column of the copied sheet, and so on with 
multiple copies.

Can this be done?

Thank you for your valued suggestions!  Carl

6. Excel formula carrying forward in protected sheet

7. Carry data from sheet to sheet automatically

8. carry down total



Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 37 guest