I've a folder which has 10 excel files. I want to combine A1:B100 from every file into a single file vertically one after another, such that the range becomes A1:B1000. And then I want to plot column A vs column B. Can someone please help me? Thank you.
combineimporting excel data
- Multiple import/edit of xls files
- How to read multiple excel tabs each as a separate matrix
- How to read only specific columns in from an Excel file, not consecutive columns
- How to sequence series of excel files and extract certain rows:columns from each file automatically
- Coupling of coorresponding sheets of excel files