Hello,

I need a liittle help creating a VBA excel macro. I have a spreadsheet with 7 columns (A:G). I need the macro to apply a filter to the first row and select a criteria from column A. Then copy the data when selecting a criteria and copying results into another spreadsheet. The data is never the same so column A changes everytime i pull new data. Hopefully not to confusioning.




PROGRAM_SUBTYPE SIX_DIGIT DIVISION STORE CIC WHSE_PACK FO_QTY
Arrowhead 900703 5 10 17150003 6 1
Arrowhead 900703 5 322 17100069 6 1
Arrowhead 900703 5 2791 17150003 6 1
Arrowhead 900703 5 2913 17150003 6 1
Barilla 900717 5 1615 28200351 12 1
Barilla 900717 5 1877 28200340 12 1
Bushs Cocina 900724 5 244 29950090 6 1
Bushs Cocina 900724 5 244 29950090 6 1