I think I've done a terrible job explaining. Should we start again?Originally Posted by SamT
Where does Class Ref come from?
How does does Field 3 (from Sheet) get in there.
When some records are "Merged with field Above" What operations are done? Are some added, subtracted, Min'ed, Max'ed, what?
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
I think it would be easier to show you what I have so far: my.pcloud.com/publink/show?code=XZVlHLZVMUogqSrCqBubtcGwaCS4f7PBBNk
I've got tables in separate sheets at the moment. I want to combine everything into one big table. The thing that is constant is the regno field. Each table has it and it could be used as the primary key to match data together. What would be the best way to combine everything into one table?
Reply With Quote