Forum Discussion

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 ...

office 365

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..