I hope somebody can help me and thank you in advance!!
My problem is that I have around 20 Excelfiles each of them has around 15 Worksheets. Now I would like to extract certain values in order to make calculations and finally to build graphs and diagrams. the value is written next to the descripiton which is common. With copy and paste I get crazy.
How can I automatize it that I can scan Excel files and worksheets for certain values (e.g. total production volume).
Thank you very much!
My problem is that I have around 20 Excelfiles each of them has around 15 Worksheets. Now I would like to extract certain values in order to make calculations and finally to build graphs and diagrams. the value is written next to the descripiton which is common. With copy and paste I get crazy.
How can I automatize it that I can scan Excel files and worksheets for certain values (e.g. total production volume).
Thank you very much!