I'm not sure exactly what you're trying to say.Because some of what you're
describing doesn't match up with the sample file you provided.
However, I THINK the problem is that in your original macro, you copied columns
A,B and Cand called them "Part Number", "Qty" and "VALUE" essentially, you were
OK, here's something to look at.
I'm not sure if you'll need help implementing it, but here's how it works:
There are several "Named Ranges".For instance, your entire list is called
"Data" in order to manage the Filters.The cell for "place" is called
"SearchPlace" and the cell for strings is call
You said you can put the ActiveX button on the sheet.
to create the VBA code, right-click the button and select "View Code".It will
open the VB Editor window and create a default "click" event for the button.
Now, as for what you want the macro to DO:
so, you just want to cycle through all cells,
