Loading...
Please wait, while we are loading the content...
Similar Documents
Control and Manipulation of Worksheet Data
| Content Provider | Scilit |
|---|---|
| Author | Bissett, Brian D. |
| Copyright Year | 2020 |
| Description | The founding principal of this text is to provide the reader with the necessary tools to construct useful applications. In order to accomplish that task, the user must have the ability to control and manipulate data which resides in any given Worksheet within any given Workbook. In order to accomplish this, the programmer must have the ability to make determinations about what any given Workbook or Worksheet contains, and further must have the ability to determine where specific pieces of data actually reside within a specific Worksheet. The programmer must also have the ability to copy information in Worksheet cells to variables in VBA where it can be stored, examined, modified, and manipulated. Finally, the developer must also have the ability to create new Workbooks and Worksheets in which to store information that has been analyzed and processed by a VBA macro, most often for reporting purposes. This chapter covers these kinds and types of processes. Book Name: Automated Data Analysis Using Excel |
| Related Links | https://content.taylorfrancis.com/books/download?dac=C2014-0-29025-8&isbn=9781003051886&doi=10.1201/9781003051886-5&format=pdf |
| Ending Page | 212 |
| Page Count | 26 |
| Starting Page | 187 |
| DOI | 10.1201/9781003051886-5 |
| Language | English |
| Publisher | Informa UK Limited |
| Publisher Date | 2020-08-07 |
| Access Restriction | Open |
| Subject Keyword | Book Name: Automated Data Analysis Using Excel Computation Theory and Mathematics Manipulation Principal Worksheet Pieces Accomplish Stored |
| Content Type | Text |
| Resource Type | Chapter |
