Ming Sheng
New Member
- Joined
- Apr 7, 2019
- Messages
- 1
How do I set up a central file in which every morning you can import and analyze the data in those 24 hourly summary files rather than doing this manually (copying/pasting from those 24 files each day).
I have to import the data to row-wise, should i select range using importbox or, sorry I am new to VBA.
Converting these from multiple files
<tbody>
</tbody>
To this
<tbody>
</tbody>
I have to import the data to row-wise, should i select range using importbox or, sorry I am new to VBA.
Converting these from multiple files
Time | 3:00 | |
Temperature | 37 | |
pH | 5.47 | |
dO2 | 52.3 |
<tbody>
</tbody>
To this
Time | Temperature | pH | dO2 | |
0:00 | 37 | 5.47 | 52.3 | |
1:00 | 37 | 5.8 | 53.3 | |
2:00 | 36.8 | 5.9 | 54.1 | |
3:00 | 36.5 | 5.4 | 53.3 | |
4:00 | 37 | 5.9 | 52.3 | |
5:00 | 37 | 5.9 | 50.3 | |
6:00 | 37 | 5.9 | 49.2 | |
~ | ~ | ~ | ~ | |
~ | ~ | ~ | ~ | |
~ | ~ | ~ | ~ | |
<tbody>
</tbody>