Excel Forum
Similar Content
Vlookup Across Multiple Workbooks
Tutorial: How to use the VLOOKUP function across multiple workbooks in Excel. This will create a lin...
Formula to Get Value of Last Non-Empty Cell in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel....
Automatically Copy New Data to Another Worksheet
: This macro allows you to quickly and easily copy all new data from one worksheet to anoth...

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.