BJ Data Tech Solution

Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.

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?
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?

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

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?

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