vba filtering

Hi all, first post on here.</SPAN> I’m having trouble cracking the VBA code I need to allow a user to select a region name from a drop-down list on Sheet1 that will filter results (based on their selection) in 9 other named worksheets (Week36 through to Week44). </SPAN> The drop-down list is...

Greetings! I am trying to have this Macro export a CSV, works great, however I need it to stop if there is a blank on the A. Can anyone help? I tried the endXLUP Up, but no avail.. Sub Export() Dim wsOld As Worksheet Dim wsNew As Worksheet Set wsOld = ActiveSheet lastrow =...

Hi guys, I need some help with filtering on vba. Part of my macro requires for me to filter specific words and then delete those rows. The issue i know what specifically I need to keep and what I need to filter out and delete mag. Ha he each time o run the macro. E,g, I might have a list of...

<TBODY> S.No</SPAN> Job type</SPAN> Problem</SPAN> BD</SPAN> B.D</SPAN> B/D</SPAN> B_D</SPAN> B D</SPAN> PJ</SPAN> P.J</SPAN> P/J</SPAN> P_J</SPAN> P J</SPAN> PM</SPAN> P.M</SPAN> P/M</SPAN> P_M</SPAN> BDS BD/S BD.S </SPAN>...

I guess my first question is how to search the board for I have to feel this question has been posed before but I was unable to find it. It is a really simple request, since the person I am writing the VBA code for wishes to be able to change the 'filter' which is the value of a cell In my...

I am using Windows XP with Excel 2007, I am a complete novice to VBA and am trying to find a script that will help me to do the following<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I have a large excel file that has multiply columns, and...