So you have a bunch of CSV Files, The Primary key is the first Field. "Regno Number"
You have a Class Ref (Somewhere)
You have a Workbook somewhere that has a Sheet2 with some data.
You have a file of some sort called "extract_class."
Have I got that right so far?
- Where does Class Ref come from?
- How does does Field 3 (from Sheet2) get in there.
- When some records are "Merged with field Above" What operations are done? Are some added, subtracted, Min'ed, Max'ed, what?
- How does the "extract class" file fit in?
It is pretty easy to read all CSV files in a folder and Filter them on one or more Keys, but it's those unknowns that count.
Theis in the details
Don't worry, we go thru this discovery process a lot. We don't have expertise in your Domain and you don't speak our lingo.