Forum Discussion

Paulene Blazey's avatar
Paulene Blazey
Copper Contributor
Nov 09, 2018

Linking cells on different work sheets in a workbook

Ive no doubt there is a simple and straightforward way to do what I need to do.  I have worksheets in a workbook containing monthly data, producing a summed total for that month. I need to link that summed total to the next month (another worksheet) to create and preserve a running total throughout the year.  How?  Help is gobbledegook.  Can anyone give me a step by step way to achieve this?

office 365

1 Reply

Sort By
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Nov 10, 2018

    I hope I got you right.

    say, The sheets are named "JAN", "FEB" and so on..

    say, on sheet "JAN" - the month total is in cell K55 and you want this to appear in cell A1 of sheet "FEB" - enter in Cell A1 of sheet "FEB" =JAN!K55  (this will show the value of sheet JAN K55)

    and so on..

    hope this helps.

    thanks..

Resources