Hi all,
I am starting to work on Excel for my research. I have several sheets in one documents (i.e. 01 June, 02 June, 03 June, etc). Then I want to grab a couple of data from each sheets in a sheet called "Summary". However, what I did is that I keep on moving from "Summary" sheet to another sheet just to click the cell that I want in each sheet. While the data that I want to grab are in the exact same cell number, only in different sheets.
Capture.JPG
I am not sure if I explain it clearly. But is it possible to: instead of clicking back and forth to different sheets to grab the data, I want to write ='B5'!$C$92 (based on the image that I have attached) and then just drag it downward to copy the formula..
Sory if I do not explain it clear enough..
Thank you for your time
Regards,
Ricardo
Bookmarks