autofilter 2016

Hi guys and gals... I am having a nightmare and need some help! I am trying to filter my data by a specific column (in this case Column 'D') and then copy the filtered data to another worksheet in the same workbook. I have basically copied and pasted some VBA script I used on another project...

Hello all, Can decipher this impenetrable code sufficiently to make it ignore the first row on the sheet on which it runs? I am changing the sheet so that the control buttons take up row one. This sub is called from a larger sub that also changes the button settings so that they are...

Hi folks, I am a bit syuck on the auto-filter syntax. can anyone tell me how to change this so that I am not copying and pasting the whole row, but only copying range "A" to "L" to usdrws and pasting into range "B" to "M", (same rows as below). ws.AutoFilter.Range.Offset(1).EntireRow.Copy...

Mornin Ya'll. I've got a question on sheet 2 asking for a pressure, and a column on sheet 1 with multiple flange ratings. What I'd like the script to do is filter the flange ratings based on the pressure entered. For example, if the user entered 350 psi it would filter out everything below...