Alright here is a stumper for me, hopefully you guys can help. What i have is
a list of lamptypes and how many they are per light fixture. Then i want to
sum all of them to a summary column. I have the columns with sumif's to add
only the particular lamptype chosen. What i am trying to do is use the
advancefilter in a macro.
What i want is when i get done with my huge list of lamptypes is have the
macro pick up all the unique types and display them in a list. The problem
that is occuring is that the first lamp always repeats itself for some
reason.

Here is the VB Macro script:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 12/14/2005 by Andrew Slater
'
' Keyboard Shortcut: Ctrl+Shift+L
'
Range("LAMPTYPE").AdvancedFilter Action:=xlFilterCopy,
CopyToRange:=Range( _
"AB5"), Unique:=True
End Sub

I can also send you a copy of the spreadsheet if you can really help me.
Just attach an email with your post.

Andy