I have a 21 column report of service calls imported from an AS400 database.
I get a new report weekly. I need to copy/paste special/values to another
sheet so I can convert date and time fields and calculate the average time
to complete the service calls. There are 3 types of service calls indicated
in column D by a C, D, or T. Column G has either a Y or N, and column V has
a Y or N. I need to extract the date/time columns, E,F and J,K for each of
the 3 types of service calls that also has an N in columns G and V. My plan
is to do this 3 times, once for each type, storing the results and clearing
the data for each type. Any help accomplishing this would be greatly
appreciated....Thanx in advance....Mike