Excel Forum
Similar Content
Get Day Name from a Date in Excel
Tutorial: How to get the name of a day from a date in Excel. This returns, for example, "Tuesday" fo...
Get Values from a Chart
Macro: This macro will pull the values from a chart in excel and list those values on another spr...
SMALL Function - Get the Lowest Values from a List in Excel
Tutorial: Return the smallest values from a list, or any of the smallest values, in Excel. This inc...



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.