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...
Pass Values from One Macro to Another Macro
Tutorial: How to pass variables and values to macros. This allows you to get a result from one macr...



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.