Thread: macro Lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DamienO DamienO is offline
external usenet poster
 
Posts: 15
Default macro Lookup

Hello,
I've set up a macro to filter a list using a week number. Obviously the week
number changes. When i run the macro I have at the moment it keeps the
original week number e.g. 44, every time it runs. I set it up so that you
should be able to put the week number into cell "f2" and then the macro uses
the value to filter the list by.
What have I done wrong?