View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lee lee is offline
external usenet poster
 
Posts: 184
Default Transferring Info from one chart to another if meets certain crite

I have a master chart (info below) that has day age of a certain product.
When that product gets a certain age (range of 15-26 days) I want that
information to show up on another chart within the same worksheet. It will
go away when it gets older than 26 days. Any help is appreciated.

Product # Name date age
90382 Pen 1/30/2009 4
32532 Pencil 1/19/2009 15
31532 crayons 1/25/2009 9
313541 Paper 1/10/2009 24