- I've input files (test1.xls, test2.xls, ...)
- I've Userform with Listbox
What I need to do.
- open input files and copy all contents to new workbook (Result.xls)
- Now Result.xls contains 2 sheets (test1.xls, test2.xls)
- read header from file and display on Listbox for user to select.
- Listbox should show
---------------
CPU
MEM
DISK
Network
Queue
---------------
- If user selected CPU and MEM
- add 2 sheets in Result.xls name CPU and MEM
- copy content from selected header to sheets.
- add name of input sheets to header. (e.g. Test1/CPU)
- see the results look like in attached file. (Result_Test.xls)
Optional :
- Finally, plot graph of CPU tab -> time + Test1\CPU, time + Test2\CPU (2 graphs)
put the graph in CPU tab and do the same with MEM tab.
attached file is what I've done so far.
Thank you in advance.
Bookmarks