Graphs for selected parameters across multiple workbooks

[vrazix]

I have many excel files in the same format with 10000~ rows of data and 50 columns. I'd like to be able to select multiple logfiles to compare particular columns (named by their header; R1) and graph them against each other.

For example,
1559.xls
1560.xls
1561.xls
1562.xls

All contain

Time Temp Power Resistance .. Flow
1
..
10000

I load the macro, choose any number of logfiles, and choose which parameters. For each parameter, a graph is generated that compares between each selected logfile. So, I could compare all 4 logfiles on all 3 (since time is the x-axis for the graph) parameters, or simply compare temperature between two logfiles.

Hopefully this makes sense; I realize this is a gigantic undertaking, so any assistance is appreciated. I have only begun fiddling around with vb and have essentially no previous coding experience (oh boy).

[Mordred]

I would suggest that you start by creating a User Form to create queries. You can get acquainted with forms from either here if you want to watch a video, or from here if you want to read about it. With a decent user form, and some code, you should be able to query data and compare them via graphs. The coding help you can find here, the design of the user form should be your design with all the query criteria that you can think of.

Take some time to design your form and then upload it. If you upload a file with data in it, please be sure to strip the data of sensitive and personal data (no names, addresses, and etc.).