Hello,
The case is that I have an Excel-file that have multiple sheets. The sheets have similar cells where there are values I am interested in analyzing. Thus, there is a generic order in which all numbers and values are in each sheet, eg: Each sheet in cell A1 have the value for numbers of graduated college students in the region - so, that the different sheets represent a different region.
How do I make a code in my do-file that reads through all sheets in my Excel data set, picks the value from cell A1 and adds them up?
I am just looking for the generic code that can be applied to different instances on Excel-files with multiple sheets where the order of content within each sheet is similar to each other.
I hope that someone can help me with this.
Best Regards, Andreas
Related Posts with How do I make a code in my do-file that reads through all sheets in my Excel data set, picks the value from (e.g.) cell A1 and adds them up?
Create a new string variable containing words of other string variables- -oaxaca- using normalize option for categorical predictor variables
- How to modify arguments (args) in a ML program?
- Interpreting negative interaction term
- Problem with generating a binary variable with individual's state and year specifications
Subscribe to:
Post Comments (Atom)
0 Response to How do I make a code in my do-file that reads through all sheets in my Excel data set, picks the value from (e.g.) cell A1 and adds them up?
Post a Comment