Excel Forum
Similar Content
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...
LARGE Function - Get the Highest Values from a List in Excel
Tutorial: Return the largest value from a list, or any of the top values, in Excel. This method use...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.