Petroleum Goodies: Excel List Navigator

Posted: 04 Apr 2014 08:44 PM PDT

Free Excel List Navigator: Navigate Your List

This tool simply helps you to filter your data from list and show the selected data. It takes the data from sheet All List and dump the selected data to sheet Selected List. You can do operation from the selected data or simply show them on chart.

This tool can be used for general purpose. In this spreadsheet we use an example to select individual well and show its production and calculate peak rates (oil and gas).

How To Use This Tool?

Put your multiple item list by column (all the way down). Item name could not be in order as long as you have the same item list name.
Click reload button to update item list to drop down menu
To select your item, select item list from drop down toolbar or click the forward or backward buttons.

Note: Don’t do any operation in sheet Selected List. Instead you can link to this sheet and do calculation in another sheet.

Using VBA macro? Yes.

Updates: v1: First release for Ms. Excel 2007+ (.xlsm) accepts more than 1 millions rows and for Ms. Excel 2003 (.xls) accepts more than 65 thousand rows.

Download List Navigator

Note: There is a file embedded within this post, please visit this post to download the file.Related Posts:

Saturday, April 5, 2014