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?
Log TransformationHello, Should you ever log transform ordinal data? Or can you only log transform continuous variabl…
Including a ratio coefficient of other coefficients in the regressionDear All, I have been trying to run analysis using the paper of Acemoglu et al. (2008) about the ass…
mata analysis - Can someone please help me with this mata analysis *Data is about: The effect of Maternal Lipid Levels on Pregnant Women Without Complication in Devel…
to get away from command ab is unrecognizedHi my question is simple, i get command ab is unrecognized how can I get away from this …
Identify a segment of a stringHi, I want to assign a binary code to each column, 1 if it contains information from the first row …
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