ConnorTheScot
New Member
- Joined
- Mar 11, 2013
- Messages
- 28
Good afternoon all,
I am looking for some assistance with a worksheet i am adapting for work.
What i have currently is a Macro which when pressed, filters out any blanks and returned equipment from column V (The filter drop down is in V5).
Now there is an adaption being put in so that this column will now show the quantity of equipment outstanding. For example if 4 items were sent and 2 returned, the column will show "2 Outstanding" through use of a formula. What i require is for the GenerateJobDetailsReport macro to filter out all the blanks and returns and only show the rows which has a quantity outstanding.
Any suggestions are appreciated
I am looking for some assistance with a worksheet i am adapting for work.
What i have currently is a Macro which when pressed, filters out any blanks and returned equipment from column V (The filter drop down is in V5).
Sub GenerateJobDetailsReport()'
' GenerateJobDetailsReport Macro
ActiveSheet.Range("$A$5:$V$718").AutoFilter Field:=3, Criteria1:="<>"
ActiveWindow.SmallScroll ToRight:=4
Range("V5").Select
ActiveSheet.Range("$A$5:$V$718").AutoFilter Field:=22, Criteria1:= _
"Outstanding"
End Sub
Now there is an adaption being put in so that this column will now show the quantity of equipment outstanding. For example if 4 items were sent and 2 returned, the column will show "2 Outstanding" through use of a formula. What i require is for the GenerateJobDetailsReport macro to filter out all the blanks and returns and only show the rows which has a quantity outstanding.
Any suggestions are appreciated