Matching data using Excel
I have a large spreadsheet with data which I need to extract data periodically.
Basically this will require pulling data based on a match of one or more
columns.
I typically use Access to do this and export the file later to be processed
using Excel.
Was wondering if there is some macro which can do this without having to use
Access.
Thanks in Advance
Michael Lew
|