Thread: Automatically create list in different sheet on basis of other lis
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pair_of_Scissors[_2_] Pair_of_Scissors[_2_] is offline
external usenet poster
  
Posts: 11
Default Automatically create list in different sheet on basis of other lis
Is it possible to create a new list based on the contents of the values in
the first sheet?

I have a list in the first sheet of my workbook. In column B I have all
sorts of values from 0001 to 9999.

What I want: on the second sheet I want that list automatically generated,
but only when they have values of 4000 to 4999 and 8000 to 8999 in column B.

An event macro or something? But how?
Reply With QuoteReply With Quote