Filtering

S

SamGB

Currently i have a .CSV file which contains all the data that has been
taken directly from another program, i need to filter out all the rows
i need using a filter that will only pick out the rows which contain a
departure time of 10:00 or earlier and insert it into a saved Excel
Spreadsheet which contains all the formulas i need.
Whats the best way of going about this??
Just to give you some background on the project...The data gets
imported from another program called RM Airline Managment

The .CSV file contains data in the following way:

Date | Aircraft reg | Schedualed Dep. time | Actual Dep. time | Delay
time

and i want to filter out the rows which only contain an schedualed dep.
time of 10:00 or less

Any help or ideas greatly appriciated
 
D

Dave Peterson

I'd open the csv file (another workbook will open).
then filter to show all the times I don't want (> time(10,0,0)) and then delete
those visible rows.

Then remove the filter and copy the remaining data to its final home. (and
close that .csv workbook, too.)

I bet that a recorded macro would get pretty darn close.
 
P

Peo Sjoblom

Either auto or advanced filter, easiest would be autofilter, apply the
filter, from dropdown in the Sched departure time select custom and greater
than 10:00, then select the visible table, press F5, special and visible
cells only, then delete them. Finally copy the rest of the data to where you
want it. Maybe even record a macro while doping this
--
Regards,

Peo Sjoblom

Portland, Oregon
 
F

flummi

Alternatively you could import the .csv file, save it as workbook,
create a new workbook and define a database query using the saved
workbook. You can have your formulas alongside the query and Excel will
automatically maintain them as the number of rows increases or
decreases. So you wouldn't need your old workbook anymore.

Hans
 
Top