Forum Discussion
Excel 2017 Cell Copy between multiple worksheets
=[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)
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)
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?
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!