Hi Community,
I am working on a workspace that used for following weekly cases of the team. I have a sheet includes total case numbers for each week in one line, so there are 52 cells in total. All the cells works with "sum" function. There are 3 worksheets like this for each case types. So I have three lines from three different worksheets like cell D1 to D52
I want to see this numbers on another sheet on one column and the numbers have to be updated when the first sheets are updated. I'm using "value" function and select "reference another sheet" to choose the appropriate cell in the first sheet.
But I cannot make it collectively. I need to make the same thing to all cells one by one. Is there another way to make it quickly if I'm using reference another sheet.
Thanks in advance.