View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alexandra Lopes Alexandra Lopes is offline
external usenet poster
 
Posts: 35
Default Order the names by ranking

Hi,

I'm sending you an example..And I would like to have this data
automatically sorted anytime a value in cols Q has changed.

I hope that this helps..

Thanks


Alexandra Lopes wrote:
Hi,

I made the 4 steps that you said me and I saw no changes in the data..

I am using excel 2007. . I don't know if it interests.


Gary''s Student wrote:
Sure let's debug in a fresh, new worksheet:

1. put some names in col A
2. put some random values in col B (NOT SORTED)
3. install the macro in the proper area (instruction in previous post)
4. change a value in column B
5. tell me what occurred.