Excel Forum

Excel Magic Trick 417: Get Last Value from Multiple Sheets

See how to get the last value in Column B from across many sheets using the LOOKUP and INDIRECT functions. This is from a post at the Mr Excel Message Board.

Got a Question? Ask it Here in the Forum.