Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic top 20 list
I have a running list of orders where as each new item is ordered it is added
to the bottom of the list (in column A is the date it was ordered, column B is the product, etc.). I would like to create a list in a separate workbook that shows only the last 20 products ordered by date (column A), and that updates automatically every time a new order is added to the "master list". I have started to experiment with a dynamic list using the =offset(...(counta()) function to define the range, but I am stuck on how I would display it in a new workbook and automatically update the new list. Any ideas/help is greatly appreciated. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic PivotTable List | Excel Discussion (Misc queries) | |||
Dynamic List | Excel Worksheet Functions | |||
Dynamic territory list | Excel Worksheet Functions | |||
Changing named Validation list to Dynamic list. | Excel Discussion (Misc queries) | |||
Making a dynamic list?! | Excel Discussion (Misc queries) |