Do you want the first item in the top20 list to be the most recently ordered
and then work backwards from there??
--
Gary''s Student - gsnu200812


"Xhawk57" wrote:

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.