Forum Discussion

Michael Gorman's avatar
Michael Gorman
Copper Contributor
Dec 27, 2017
Solved

Excel 2017 Cell Copy between multiple worksheets

I am setting up a new home business and I am creating an Income/Expense Workbook.  I am creating the first page to be a total of all expenses for each month and I need to know the formula for copying say cell H18 from Sep 2017 worksheet into say cell B4 in the 2017 Monthly Totals (which would be sheet 1).  I used to know this formula but I can't remember it now.  I've been trying to enter in =sum(Sep2017!H18) but when I do, it brings up a place where I want to save something, either the formula or the whole workbook.  I'm not sure on that.  Can someone tell me what the correct formula syntax is?  I would really appreciate any help.

office 365
  • Deleted's avatar
    Deleted
    Dec 27, 2017
    =[Sep2017]Sheet1!H18

    Where "Sheet1" is the name of the sheet. This will copy 1 value, if you want to sum
    a number of values in Sep2017, then try this:

    =SUM([Sep2017]Sheet1!H1:H18)
  • Deleted's avatar
    Deleted
    Dec 27, 2017
    =[Sep2017]Sheet1!H18

    Where "Sheet1" is the name of the sheet. This will copy 1 value, if you want to sum
    a number of values in Sep2017, then try this:

    =SUM([Sep2017]Sheet1!H1:H18)
    • Michael Gorman's avatar
      Michael Gorman
      Copper Contributor
      Dec 28, 2017

      Thanks Stephen, However, when I put that formula in, it keeps popping up a box entitled "Update Values Sep2017" with two options at the bottom to either "Open" or "Cancel".  And it has the name of my workbook in there.  So, I selected my workbook and the "Open" changed to "OK" and when I clicked on that it just put the formula I just typed in A1 where I had entered the formula.  Do you know why it would bring up this box to Update Values Sep2017?

      • Michael Gorman's avatar
        Michael Gorman
        Copper Contributor
        Dec 28, 2017

        Stephen,  Never mind.  I've finally figured it out and in a much easier way.  If I simply put an equal sign = and then go to the Sep2017 page and select H18 and hit Enter, it will place that total in for me.  Then if anything changes that total on the Sep2017 page, it will automatically change the total on my Sheet 1 or Monthly Accumulations.  But, your formula helped in remembering the long version of the formula I needed to use and then I got to thinking that if I did what I just described, it would work, and voila! it worked!  So, thanks for stimulating my thinking cap!

Resources