Excel Forum



Excel Magic Trick #205: Get C21 Values From Across Sheets


Amazing Trick with INDIRECT function! See how to get the values from all the C21 Cells From Across Many Sheets and list them in a column without having to do it manually. Create Sheet References with Concatenation and the INDIRECT function. See 4 (four) different methods to deal with different types of sheet tab names (sheet References Worksheet tab names).





Got a Question? Ask it Here in the Forum.