Thread: VBA Problems
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 4
Default VBA Problems

I have 4 charts like the following
Product Count Age
120 4
2 5
1 6
58 7
14 8
3 11
73 12
44 13
1 14
38 15
55 18
4 19
5 20
4 21
6 22
5 25
4 26
1 28

I would like to be able to take the product count that is the oldest that
has at least 5 products in it and put it into another worksheet. I am a
novice to say the least at excel and some of its functions. I have tried
with vlookup but just cant seem to get it. If anyone could give me a hand I
would be eternally grateful. Thank you in advance.

--