Hi,

I'm a bit struggling right now because I think I'm going to give myself waaaay to much work when I'm going to do everything manually.
So here's the thing. I have about 200+ raw data files and I copy and paste some of the data (4 columns) of these raw files into an a new document. So that's going to be 1 sheet for every file, so 1 document with a lot of sheets. See image for how the sheets will look like, don't look at the numbers these are made up because it's an example https://image.ibb.co/dEZqiv/Example.png

For every new sheet I have to do exactly the same except for one small difference, here are the actions required:
- Paste the first 4 columns
- Calculate column E,F,G (formulas are the same for every sheet)
- I have to look at the first graph (top one)
- Decide which part of the first graph I'm going to use (for example: 9 until 25)
- Highlight included period (in the example highlighted green)
- Make a new graph with that time period (bottom one)
- All the averages below are calculated with that time period

So the difference for every sheet is the highlighting part, and thereby affecting the graph and the calculated averages.
So I was thinking, is there a possibility to just paste the 4 columns, look at the graph, highlight the included period and excel will do everything else for me? And if so, how?